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.
Best answer by Steve Miller
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]')))
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]')))
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.