Skip to main content
G
girishk5785
July 20, 2021
Question

Search Filter for TextBox Field

  • July 20, 2021
  • 8 replies
  • 0 views

Hello All,

I have added readable grid into an interface and linked the record to this interface which will provide me all the fields of the record.

In the record user filter option available part of the a!gridfield. In the record I have enabled set showSearchBox to true which provides us with a global search option.

But I have a requirement to add filter for text field for example, Iike

CustomerName


The version I'm using is 21.2, any alternative way to achieve this?

Thanks & Regards

Girish

8 replies

selvakumark
selvakumark
Participating Frequently
July 20, 2021

Hi [mention:b0be4e9f5ac8403d820bf0a00e17f248:e9ed411860ed4f2ba0265705b8793d05],

I'm sharing a workaround here, but please analyze whether it'll fit your use case.

Instead of an entity-backed record, we can create an expression-backed record, where we can customize the search filter to apply to the desired columns. A simple query entity can be the source of the expression.

docs.appian.com/.../Service-Backed_Record_Tutorial.html

G
girishk5785Author
July 20, 2021

Hi Selvakumar,

Thankyou for the reply. One question i mind will expression-backed record not be slower when performing the search?

selvakumark
selvakumark
Participating Frequently
July 20, 2021

There will not be much difference unless your entity-backed record was a synced record. Synced records perform faster than normal ones.

peter.lewis
peter.lewis
Employee
July 20, 2021

If you're using a grid that uses record data, can you create a user filter where users can select a customer? https://docs.appian.com/suite/help/latest/filter-the-record-list.html

G
girishk5785Author
July 20, 2021

Hello Peter,

Using the user filter I will get a drop down list which is not required. I need the field as a free text to perform the search.

peter.lewis
peter.lewis
Employee
July 20, 2021

Sure but you can search in the dropdown to find the customers you need. Do you explicitly need to search by keyword instead of searching to find / select the customers? 

If you do explicitly need to search by a key word, I'd suggest just adding a text box above your grid and save the results of the search into a local variable. Then, use that local variable as a filter in your record grid by applying a filter with a!recordData(). The one downside to this is that the user experience won't be as nice, but it should allow you to search what you want.

Terms & ConditionsAccessibility statement