Skip to main content
Participating Frequently
May 7, 2025 5:51 AM UTC
Question

Search Functionality in Read only grid

Hi Experts,

I m using read only grid in my interface, where i used expression as data source . If I search the column data correct results are not showing up. Lets say if have fields with status " NOT started" i can see 3 rows of data in grid, but if i search for "Not Started " and hit enter. only one result is showing up in grid. How to solve this

Thanks

    6 replies

    stefanhelzle0001
    Brainy
    May 7, 2025 5:58 AM UTC

    How do you implement that search?

    docs.appian.com/.../fnc_system_a_queryfilter.html

    Participating Frequently
    May 7, 2025 6:30 AM UTC



    This status name filter not gving me expected results [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] 

    konduruc733182
    Inspiring
    May 7, 2025 6:39 AM UTC

    Could you please share the interface expression where you have defined the grid source.

    konduruc733182
    Inspiring
    May 7, 2025 6:12 AM UTC

    Assuming your using a textfield to collect the input and use that variable to pass in your query. It might be an issue with case sensitivity. I would recommend you to format the values before you pass into the query.

    mathieud0001
    Genius
    May 7, 2025 9:17 AM UTC

    Why have an actual drop down filter for the status instead of searching for it in the text field?