Skip to main content
devarnenis2638
devarnenis2638
April 15, 2024
Question

User Filters

  • April 15, 2024
  • 8 replies
  • 0 views

I have two user filters in record, is to possible to hide and show second user filter based on value selected in 1st user filter.

For example in the below image I have two filters named 1) FEEDBACK and 2) APPOINTMENT DATE, 

FEEDBACK filter had 2 values Good and Neutral, Is it possible to display the Second filter(APPOINTMENT DATE) only when we choose Good in the FEEDBACK filter?

8 replies

karumurua531442
karumurua531442
April 15, 2024

AFAIK, Subject to correction I don't think show you can hide second filter based on the result of the first filter. for record type. you need built using dropdowns outside the grid. 

shubhama926776
shubhama926776
Brainy
April 15, 2024

AFAIK Appian's built-in record list functionality doesn't offer an option to directly show or hide filters based on selections from other filters.

Instead of relying on the default record list, create a custom interface with a grid built using the a!gridField function.
This grid will display the records based on your logic.

https://docs.appian.com/suite/help/24.1/fnc_system_recorddata.html
.
https://docs.appian.com/suite/help/24.1/fnc_system_queryrecordtype.html

शुभम्
konduruc733182
konduruc733182
April 15, 2024

Hello [mention:54dbd0c9e16846aba7aa0ad377e6fba0:e9ed411860ed4f2ba0265705b8793d05] 

No, You cannot have this functionality in record filters. The only work around is to have your filters built using dropdowns outside the grid. 

konduruc733182
konduruc733182
April 15, 2024
reate a custom interface with a grid built using the a!gridField function.
This grid will display the records based on your logic.

I guess the problem is not about the data. Its about the filters.

shubhama926776
shubhama926776
Brainy
April 15, 2024

If you use a!queryRecordType() as data in gridField() you can show and hide filters on value selection.

शुभम्
M
manishs0028
April 15, 2024

[mention:54dbd0c9e16846aba7aa0ad377e6fba0:e9ed411860ed4f2ba0265705b8793d05] : As per my understanding you cannot have this functionality in record filters. You can use interface rules and expressions to conditionally show or hide the second user filter based on the value selected in the first user filter.

for example : 

local!showAppointmentDate: IF(
local!feedbackFilter= "Good",
true,
false
)

konduruc733182
konduruc733182
April 15, 2024

Not sure how you would save the value to local variable from the first record user filter?

conditionally show or hide the second user filter based on the value selected in the first user filter
M
manishs0028
April 15, 2024

[mention:2df2892a4df7486f9775b4d2f0e405fd:e9ed411860ed4f2ba0265705b8793d05] : Let me correct my sentence here:  

As per my understanding you cannot have this functionality in record filters. You can use interface rules and expressions to conditionally show or hide the second filter based on the value selected in the first filter.

for example : 

local!showAppointmentDate: IF(
local!feedbackFilter= "Good",
true,
false
)

All I am saying is instead of going with record userfilter approach , We can go with interface rule/expression/local variable approach

Terms & ConditionsAccessibility statement