Question

Look up filter expression code Advise NEEDED

  • 13 March 2023
  • 1 reply
  • 108 views
Z
Rank
Badge

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

 

1 reply

T
Rank
Userlevel 1
Badge +1

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'

Reply


Terms & ConditionsCookie settings