Skip to main content
Question

Lookup Filter against Custom Field on ContactUser

  • December 14, 2023
  • 1 reply
  • 159 views

Forum|alt.badge.img+1

We created a custom Single-Select field on our contact user forms.
We want to use the values in a Lookup Filter expression on our forms to restrict the results of our Single-Select Contact User field but cannot find the correct syntax to include:

We’ve tried multiple variations like below:
FROM usr as contactUser WHERE contactUser.$W(‘RAD’).shortCode = ‘ADULT REPRESENTATION SERVICES’

FROM usr as contactUser WHERE contactUser.$new.W(‘RAD’).shortCode = ‘ADULT REPRESENTATION SERVICES’

Currently on version 11.6.3 of assyst.

Any ideas?

Forum|alt.badge.img

From my understanding you cannot base visibility expression on the system single select field. If you try using the custom version it should work.

https://wiki.axiossystems.com/assyst11-7Wiki/index.php/Expressions_and_Filters_in_assyst#The_Scope_of_Expressions


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings