Filters in Readonly grid

Question

Hi Team , 
 
 The requirement is to add dropdown filters to all fields between the header label and the first row in Readonly grid . Is this possible in Appian?

Stefan Helzle · Answer

My advice is, to not try to implement an Excel in Appian. While the Appian capabilities can be stretched to some extend, more sooner than later you will bump into a problem. 
 And then, Appian has a separate component GridPlus which might help you with this. 
 GridPlus Component Plug-In

Teja Kunchala · Answer

goddativ5526 a!localVariables( local!search, { a!sectionLayout( label: "", contents: { a!sideBySideLayout( items: { a!sideBySideItem( item: a!textField( label: "", labelPosition: "COLLAPSED", value: local!search, saveInto: local!search, refreshAfter: "UNFOCUS", validations: {} ) ), a!sideBySideItem( item: a!buttonArrayLayout( buttons: { a!buttonWidget( label: "SEARCh", style: "OUTLINE" ) }, align: "START", marginBelow: "NONE" ) ) } ) } ) } ) When clicked on search, refresh the query that is getting the data to in grid and the query need to contain query filters for the fields to search. Just for your reference but its not recommended to use. For 50 fields, you have to use a!queryfilter and pass the local!search and return the data which is not good as per performance.

Harshmodi · Answer

Hey goddativ5526 , 
 I&rsquo;ve used an example where all department names are displayed in an editable grid. When I search for 'dep', the grid filters the data based solely on the department name field, as the filtering is specifically applied to that column. 
 NOTE: Limit what&rsquo;s searchable : Avoid searching across all 50 fields unless absolutely needed &mdash; it can degrade performance.

Harshmodi · Answer

Hey goddativ5526 ,

"I&rsquo;ve used an example where all department names are displayed in an editable grid. When I search for 'dep', the grid filters the data based solely on the department name field, as the filtering is specifically applied to that column." 
 NOTE: Limit what&rsquo;s searchable : Avoid searching across all 50 fields unless absolutely needed &mdash; it can degrade performance.

Abhishek Karumuru · Answer

hi goddativ5526 Appian does not support placing dropdowns inside the grid header row or just below it,

Varun Teja Gurrapu · Answer

Hi goddativ5526 , as Abhishek Karumuru mentioned, Appian doesn&rsquo;t natively support dropdowns directly under grid headers (like Excel-style filters), but you can create a very similar experience using filters above the grid. We have a alternative way to implement very closely as shown below. Use a cascading dropdown and add filters into the Read only grid. This will add custom filters. Hope this helps you!!!