How to Create user filter from expression rule

Hello Scott Fleming 

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

I already followed the instructions from the link, however I do not know how to write the a!recordFilterList() function to obtain the DISTINCT values of a field. 

The documentation does not display an example code to write.

I created an expression rule, that queries distinct values from "Outcome Status" field, and want it to be the options for the user filter. 

 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.

Here is the "manually entered" user filter list, which is pre-determined options and values. 

I want this to be dynamic, based on the DISTINCT values from the OutcomeStatus column. 

The reason? Because if the data changes, I don't have to go into the filter and make changes. 

Below is the working filter, but it's NOT dynamic. How do I query the DISTINCT values of the recordType in this expression?

=a!recordFilterList(
  name: "Status",
  options: {
    a!recordFilterListOption(
      id: 1,
      name: "In Production",
      filter: a!queryFilter(
        field: 'recordType!{793e655d-96f3-490d-9594-62845dbe1ad3}AP Health Application.fields.{8fcf0830-0ea7-4f5a-99a5-b57339b716f0}OutcomeStatus',
        operator: "=",
        value: "In Production"
      )
    ),
    a!recordFilterListOption(
      id: 2,
      name: "Decommissioned",
      filter: a!queryFilter(
        field: 'recordType!{793e655d-96f3-490d-9594-62845dbe1ad3}AP Health Application.fields.{8fcf0830-0ea7-4f5a-99a5-b57339b716f0}OutcomeStatus',
        operator: "=",
        value: "Decommissioned"
      )
    ),
    a!recordFilterListOption(
      id: 3,
      name: "Retired",
      filter: a!queryFilter(
        field: 'recordType!{793e655d-96f3-490d-9594-62845dbe1ad3}AP Health Application.fields.{8fcf0830-0ea7-4f5a-99a5-b57339b716f0}OutcomeStatus',
        operator: "=",
        value: "Retired"
      )
    ),
    a!recordFilterListOption(
      id: 3,
      name: "Under Evaluation",
      filter: a!queryFilter(
        field: 'recordType!{793e655d-96f3-490d-9594-62845dbe1ad3}AP Health Application.fields.{8fcf0830-0ea7-4f5a-99a5-b57339b716f0}OutcomeStatus',
        operator: "=",
        value: "Under Evaluation"
      )
    )
  },
  defaultOption: "",
  isVisible: true,
  allowMultipleSelections: true
)

Here is the "manually entered" user filter list, which is pre-determined options and values. 

I want this to be dynamic, based on the DISTINCT values from the OutcomeStatus column. 

The reason? Because if the data changes, I don't have to go into the filter and make changes. 

Below is the working filter, but it's NOT dynamic. How do I query the DISTINCT values of the recordType in this expression?

=a!recordFilterList(
  name: "Status",
  options: {
    a!recordFilterListOption(
      id: 1,
      name: "In Production",
      filter: a!queryFilter(
        field: 'recordType!{793e655d-96f3-490d-9594-62845dbe1ad3}AP Health Application.fields.{8fcf0830-0ea7-4f5a-99a5-b57339b716f0}OutcomeStatus',
        operator: "=",
        value: "In Production"
      )
    ),
    a!recordFilterListOption(
      id: 2,
      name: "Decommissioned",
      filter: a!queryFilter(
        field: 'recordType!{793e655d-96f3-490d-9594-62845dbe1ad3}AP Health Application.fields.{8fcf0830-0ea7-4f5a-99a5-b57339b716f0}OutcomeStatus',
        operator: "=",
        value: "Decommissioned"
      )
    ),
    a!recordFilterListOption(
      id: 3,
      name: "Retired",
      filter: a!queryFilter(
        field: 'recordType!{793e655d-96f3-490d-9594-62845dbe1ad3}AP Health Application.fields.{8fcf0830-0ea7-4f5a-99a5-b57339b716f0}OutcomeStatus',
        operator: "=",
        value: "Retired"
      )
    ),
    a!recordFilterListOption(
      id: 3,
      name: "Under Evaluation",
      filter: a!queryFilter(
        field: 'recordType!{793e655d-96f3-490d-9594-62845dbe1ad3}AP Health Application.fields.{8fcf0830-0ea7-4f5a-99a5-b57339b716f0}OutcomeStatus',
        operator: "=",
        value: "Under Evaluation"
      )
    )
  },
  defaultOption: "",
  isVisible: true,
  allowMultipleSelections: true
)

If you want distinct value of "OutcomeStatus" you can do grouping which you are already doing it here



I would highly recommend to follow steps from my screenshot.
If you still getting duplicate let me know.