How to Create user filter from expression rule

Question

I am trying to create a user filter with the results from an expression rule which displays distinct options from my table. 
 
 I have researched the documentation, and was unable to find any answers with an example. 
 
 How do I call the expression rule to populate the options for this user filter based on the results from the expression rule I have created?

Many thanks in advance for your assistance.

Shubham Aware · Accepted Answer

You have to replace record from line no. 9 to a!recordFilterList(
 name: "OutcomeStatus",
 options: a!forEach(
 items: rule!AP_Outcome_Status(),
 expression: a!recordFilterListOption(
 id: fv!index,
 name: fv!item.OutcomeStatus_grouping1,
 filter: a!queryFilter(
 field: /*"Replace record here"*/,
 operator: "=",
 value: fv!item.OutcomeStatus_grouping1
 )
 )
 )
 )

Shubham Aware · Answer

Hello Scott Fleming You have to use a!recordFilterList() . This documentation explain with example.

Shubham Aware · Answer

Scott Fleming I have attach my sample code for your reference. Try to replicate my code for your requirement. Keep me posted if you have any questions.

Shubham Aware · Answer

Your AP_Outcome_Status rule is correct only you have to remove .data and I have replicate your code. Try this and let me know. 
 a!recordFilterList(
 name: "OutcomeStatus",
 options: a!forEach(
 items: rule!AP_Outcome_Status(),
 expression: a!recordFilterListOption(
 id: fv!index,
 name: fv!item.OutcomeStatus,
 filter: a!queryFilter(
 field:'recordType!{793e655d-96f3-490d-9594-62845dbe1ad3}.fields.{8fcf0830-0ea7-4f5a-99a5-b57339b716f0}',
 operator: "=",
 value: fv!item.OutcomeStatus
 )
 )
 )
 )

How to Create user filter from expression rule

Top Replies