Question

Look up filter expression advise request

  • 1 March 2023
  • 1 reply
  • 53 views

Badge

Hi,

Is there an expression, logic or way on how to exclude a single item from a look up filter expression within a custom form via the customizer in Assyst ?

assyst Version: assyst10 SP7.5

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

 

Please advise.


1 reply

Userlevel 4
Badge +12

We are running with 11.5 but this might work for you.

select item.id from item as item where item.product.productClass.shortCode = '[Item Product Class]' and item.shortCode !='[Item Shortcode]'

Reply