How can I present a modified list of members in a Child Ticket that excludes the members that were already selected in the Parent Ticket?
My requirement is to remove the members from the original list when re-presenting the modified list in the child ticket.
Original List in Parent Ticket: Adobe, Excel, MineSweeper, Solitaire, WarCraft
In the Parent Ticket the user selected MineSweeper and Warcraft. The value in the custom_field_value4 capturing this information is recorded as MineSweeper,Warcraft
select custom_field_value4 from HD_TICKET where ID=98
In the Child Ticket I would like for the new list to be presented to EXCLUDE the values that were selected in the Parent ticket, i.e. the NEW list in the Child Ticket should include ONLY Adobe, Excel, Solitaire.
I tried this:
select distinct NAME from ORG1.ASSET where ASSET_TYPE_ID = 10210 and NAME NOT IN (select custom_field_value4 from HD_TICKET where ID=98)
The SQL works fine as long as there is only one item being excluded (i.e. MineSweeper) but when the EXCLUSION contains more than one value *i.e. MineSweeper,Warcraft) then nothing is excluded.
Be the first to answer this question