Solved

Filter Expression by Configuration Characteristic

  • 23 February 2023
  • 1 reply
  • 98 views
S
Rank
Userlevel 4
Badge +12

Has anyone tried filtering an item field on a custom form to include all items with a specific configuration characteristic? I’ve been working my way through it myself with the help of the Wiki and Javadocs but seem to be missing something.

My use case is to apply a configChar of ‘’Single sign-on’ to all applications that are set up for it, to present our user base with an incident relating to troubles logging in, and limiting the item selection to only relevant applications.

Thanks in advance.

icon

Best answer by Steve Miller 8 March 2023, 09:54

View original

1 reply

S
Rank
Userlevel 4
Badge +12

Credit going to Lukasz on the service desk for this one. Thanks muchly. This was a real head scratcher for us.

from item as Item where Item.id in (select itemConfigA.item.id from item_config as itemConfigA where itemConfigA.configChar.id in (select itemConfigB.configChar.id from item_config as itemConfigB where itemConfigB.configChar.id = (select configChar.id from config_char as configChar where configChar.shortCode = '[Insert Characteristic Shortcode]')))

 

Reply


Terms & ConditionsCookie settings