User Filter to select a list of companies, list of departments etc

I feel this is a really easy one, but Ive been struggling for hours now.  I want a drop down list to filter on the company, and another for the department etc.  I know there is a free text search field but they want three different searches.

I have tried two different expression based queries.

I have tried using a expression rule - rule!DMR_V2_UserFilter( array: rule!DMR_V2_AllCompanies().company, field: "company" )

 
DMR_V2_UserFilter is:
 
a!recordFilterList(
  name: proper(ri!field),
  options: a!forEach(
    items: ri!array,
    expression: a!recordFilterListOption(
      id: fv!index,
      name: fv!item,
      filter: a!queryFilter(
        field: ri!field,
        operator: "=",
        value: fv!item
      )
    )
  )
)
Also another from 
Both give me the error:
The Requested Record Type Is Not Available The User Filter expression failed to evaluate. Details: [Expression evaluation error at function a!queryFilter: The field [“company”] used in “filters” was invalid. A record type field reference must be used when filtering record data.]. (APNX-1-4205-021)

Have also tried using the wizard with a expression that groups the company name = record.company 

David

  Discussion posts and replies are publicly visible