macro that searches and retrieves data

[HaRsHaS_ V]

Hi All

Background: I have created a sql query for a particular data and it shows as intended in clean tabular form. 

Example

Custom field	Field value
color	red, blue
clothes	jeans, shirt

Question: I would want to know if there is any macro that searches and retrieves data.

What I mean is when someone types color , the related data should show up. Any possibility of this.

Because we do not want the complete table to shown to users.

Regards

Harsha

[Andrey Khaneev _StiltSoft_]

Hi @HaRsHaS_ V,

The Table Filter macro does exactly what you described. You can set different filter types like dropdown or text filter. Also, it might be useful to set Show first N rows to 0+ values so that the table will show empty until it is filtered.