Skip to main content
Question

Look up filter expression code Advise NEEDED

  • March 12, 2023
  • 1 reply
  • 139 views
Z
Do Gooder (Customer)
Forum|alt.badge.img

I want to be able to hide this ITEM/ELEMENT “Item.product.shortCode = PIMS” in my look up via my look up filter expression box in my look up field on my form . Every expression I've tried had broken the look up search completely and wont return any results. All im trying to do is hide 1 item from my lookup without having to create a whole separate look up without that item in it. 

Can anyone please advise how this can be done ? 

I'm using 

assyst Version: assyst10 SP7.5

Build:  12183 Date built: 04 August 2020 09:40:59

assyst Version: assyst10 SP7.5

Build:  12183 Date built: 04 August 2020 09:40:59

 

T
Do Gooder (Employee)
Forum|alt.badge.img+1
  • tnicoll
  • Do Gooder (Employee)
  • March 30, 2023

The following lookup filter expression should work:

from item as Item where Item.product.shortCode != 'PIMS'

Although you’ve said you’re trying to hide 1 item. The above expression will actually hide all items with a product shortcode of ‘PIMS’. You may only have one item that qualifies for that in which case you’re fine, but in the event you actually want to hide a single item called ‘PIMS’ then the expression for that would be:

from item as Item where Item.shortCode != 'PIMS'

C
S
2 people like this
  • C
    Caroline Schaffner
  • S
    Steve Miller

Reply


Terms & ConditionsCookie settings

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