how to customize a Record type User Filter

I want to use record type User FIlter. However when I use the filter has around 50 options for the labels and options even if the actual grid only 2 or 3 options. Is there anyway to to limit the option of Label and Values according to Record Value.

a!recordFilterList(
name: "Assignee",
allowMultipleSelections: true,
options: a!localVariables(
local!assignees:a!queryRecordType(
recordType: 'recordType!{4390cf3b-8f80-4bfd-adfa-b06cb2562f7d}Job Corps Response',
fields: {
a!aggregationFields(
groupings: a!grouping(
field: 'recordType!{4390cf3b-8f80-4bfd-adfa-b06cb2562f7d}Job Corps Response.fields.{assignee}assignee',
alias: "assignee"
)
)
},
pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
).data,
local!assigneesList:property(local!assignees,"assignee",null),
a!forEach(
items: local!assigneesList,
expression: a!recordFilterListOption(
id: fv!index,
name: fv!item,
filter: a!queryFilter(
field: 'recordType!{4390cf3b-8f80-4bfd-adfa-b06cb2562f7d}Job Corps Response.fields.{assignee}assignee',
operator: "=",
value: fv!item
)
)
)
)
)

My Grid only has 3 items on them ad hence it shouldn't have more than 3 options of the User Filter options. However the options are more than 100 because on the database there are several options for the dropdown but not for this specif record

  Discussion posts and replies are publicly visible

Parents Reply Children