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.

0 Comments   [ + ] Show comments

Answers (0)

Be the first to answer this question

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ