can we populate unique values of that column in dropdown format inside ptcschipdatafilter widget

Hi @AP_10343008 ,

I'm afraid this is not possible for ptcs-chipdatafilter widget, please consider raising an enhancement idea in https://community.ptc.com/t5/ThingWorx-Ideas/idb-p/thingworxideas

As a workaround which requires some extra implementation effort, you can use a dropdown widget listing unique values for the chosen column, use expression function to build and output the query in JSON for filtering based on the selected item in dropdown, then pass the expression output to the input of the query data service that bound with the Grid Data.