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.