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
)

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.

Invalid Parameter warnings.

. 

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
        )
      )
    )
  )

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
        )
      )
    )
  )

I applied the code for the user filter expression  you provided above, which seems to be the exact code used to create the expression rule??? 

In any case... here's the error.

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
        )
      )
    )
  )

Ok. Things are getting clearer. 

This is my expression rule, to obtain distinct values from "OutcomeStatus" column:

Next, my user filter, which I see access the "alias" from my rule, but the rule output does not have an index.

So, the user filter is expecting an fv!index and there is none 

I get no errors, but the filter displays no values.