Filter rows from read only grid using multichoice dropdown

Question

Hi, 
 I have a read only grid as shown below, I want to filter data by selecting value from " Status " dropdown and by pressing " Search " button. 
 Please help me with it.

Danny Verb · Accepted Answer

In the data parameter on your grid, use the function a!recordData(). Here you can add a!queryFilter() to the filters parameter. To filter by the dropdown, you should create a local variable called local!selection. See code below: 
 
 a!localVariables(
 local!selection,
 {
 a!columnsLayout(
 columns: {
 a!columnLayout(
 contents: {
 a!multipleDropdownField(
 label: "Status",
 labelPosition: "ABOVE",
 placeholder: "Select Status",
 choiceLabels: {
 "Option 1",
 "Option 2",
 "Option 3",
 "Option 4",
 "Option 5",
 "Option 6",
 "Option 7",
 "Option 8",
 "Option 9",
 "Option 10",
 "Option 11",
 "Option 12"
 },
 choiceValues: { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 },
 value: local!selection,
 saveInto: local!selection,
 searchDisplay: "AUTO",
 validations: {}
 )
 }
 )
 },
 showDividers: false
 ),
 a!sectionLayout(
 label: "",
 contents: {
 a!columnsLayout(
 columns: {
 a!columnLayout(
 contents: {
 a!buttonArrayLayout(
 buttons: {
 a!buttonWidget(
 label: "Search",
 icon: "search",
 submit: true,
 style: "LINK"
 )
 },
 align: "END"
 )
 }
 )
 }
 )
 },
 marginBelow: "NONE"
 ),
 a!gridField(
 label: "",
 labelPosition: "ABOVE",
 data: a!recordData(
 recordType: 'recordType!{dc0053d9-f64e-4075-99f9-0f4948307dab}ABC_Exam',
 filters: {
 a!queryFilter(
 recordType!ABC_EXam.fields.status,
 "in",
 local!selection
 )
 }
 ),
 columns: {
 a!gridColumn(
 label: "Start Date",
 sortField: 'recordType!{dc0053d9-f64e-4075-99f9-0f4948307dab}ABC_Exam.fields.{startDate}startDate',
 value: fv!row['recordType!{dc0053d9-f64e-4075-99f9-0f4948307dab}ABC_Exam.fields.{startDate}startDate'],
 align: "START"
 ),
 a!gridColumn(
 label: "End Date",
 sortField: 'recordType!{dc0053d9-f64e-4075-99f9-0f4948307dab}ABC_Exam.fields.{endDate}endDate',
 value: fv!row['recordType!{dc0053d9-f64e-4075-99f9-0f4948307dab}ABC_Exam.fields.{endDate}endDate'],
 align: "START"
 ),
 a!gridColumn(
 label: "Status",
 sortField: 'recordType!{dc0053d9-f64e-4075-99f9-0f4948307dab}ABC_Exam.fields.{status}status',
 value: fv!row['recordType!{dc0053d9-f64e-4075-99f9-0f4948307dab}ABC_Exam.fields.{status}status']
 )
 },
 pageSize: 25,
 initialSorts: {
 a!sortInfo(
 field: 'recordType!{dc0053d9-f64e-4075-99f9-0f4948307dab}ABC_Exam.fields.{changeOrderNumber}changeOrderNumber',
 ascending: true
 )
 },
 selectable: false,
 validations: {},
 spacing: "STANDARD",
 rowHeader: null,
 refreshOnReferencedVarChange: true,
 refreshAfter: "RECORD_ACTION",
 showSearchBox: false,
 showRefreshButton: false,
 actionsDisplay: "LABEL"
 )
 }
)

Danny Verb · Answer

Using the 'applyWhen' parameter in queryFilter() https://docs.appian.com/suite/help/20.1/fnc_system_a_queryfilter.html 
 You can have the query only be applied when the value is not null 
 `not(isnull(local!date))`

Richard Michaelis · Answer

hi shamima, 
 you need to update the local!filters of your queryEntity via saveInto parameter of the sail form elements. 
 try to use an expresison rule with querEntity and ruleInput "any type".

Filter rows from read only grid using multichoice dropdown

Top Replies