Condition builder deletes catalog item value while selecting variables from variable set. - Known Error

Condition builder deletes catalog item value while selecting variables from variable set. Description This article details an issue regarding the behavior of the condition builder specifically on the sc_task table where the Catalog Item values are deleted out when querying catalog items associated with variable sets. This behavior can be seen from any Condition Builder and is also present across all versions. Here is an example screenshot of the behavior.

Ex: In this example, there is a query for the catalog item SNC Test , we are also querying where the test variable starts with. When the query is executed the condition builder displays the catalog item as empty. Additionally, the result set retrieves all catalog items which use the variable set specified, which is also another issue since we have specified only to return catalog tasks associated with our catalog item 'SNC test.'

Steps to Reproduce

Phase 1: Create 2 new catalog items Log in to an affected instance (See Seen in section of this article) Navigate to Service Catalog > Maintain Items > Create a New record (You will need to create 2 catalog items) Phase 2: Create a variable set Navigate to Service Catalog > Variable Sets > New > Select the 'Single-Row Variable Set' Populate record what anything Save the record Scroll down to the 'Variables' related list and click New Create a variable populate question with anything you want Submit the record Phase 3: Link variable set to catalog items In the related list for 'Included in' click Edit Select the two catalog items which you created from step 2 above Phase 4: Create a workflow for creating a catalog task Navigate to Workflow > Workflow editor > New Table for workflow should be Requested Item > Submit Add activity to the workflow > Select the Core tab > Tasks > Catalog Task > drag this to the workflow editor panel Populate short description as this is mandatory Scroll down to Add Variables and add the variable (question) that was created from step 7 Phase 5: Link workflow to Catalog items Navigate to both created catalog items Click on the Process Engine tab Populate the workflow reference with the name of the workflow created from Phase 4 Save the Record Steps to reproduce after setting up the configuration Open each catalog item Click on Try it Populate the variable with a value (this needs to be the same value for both catalog items you order) 4. Order the item now Once this is submitted a sc_task record should be created for both catalog items

Behavior 1: Catalog item value is removed from condition builder for anything that uses a condition builder (report, list, etc)

Go to sc_task.list Create a filter in the condition builder Variables select item should be your catalog item and select variable will be your variable that was created Run the query Notice that the variable value stays intact but the catalog item value is removed.

Behavior 2: Also, notice that any catalog task for a catalog item that uses the same variable set also displays a catalog task record even though we have specifically chosen a single catalog item. This should not be the case.

Workaround To work around this issue the user/admin can do the following:

Add another filter where the user/admin queries the Requested Item. The item which is a Dot walked field to select the catalog item of variable which user/admin wants to display. This will ensure that only catalog tasks associated with the specific catalog item are displayed.

Also, the condition builder display will now properly show what catalog item is being queried. Here is an example