how to make a catalog item with a category and subcategory dependent dynamic

flsn2 · ‎09-08-2023

Hello,

I need help to make a catalog item with 1 select box for category and 1 for subcategory. They should get their values from already exsiting variable on the universal request table.

The issue i'm facing is that on the universal request my subcategory variables are dependent from the variable you choose on the category.

I need to make the same logic on my catalog item.

Anyone as done it before ?

Brad Bowman · ‎09-08-2023

OK. I still don't have the table or Create New to see that form directly, but you can see what needs changed in this example. Both variables will be the type of Lookup Select Box. I'll use the names v_category and v_subcategory to try to prevent confusion with similarly named table fields. Both variables will be setup like this:

v_category will have a Reference qualifier that looks like this (change the name or element values if they don't match your choice list records).

v_subcategory will have a Reference qualifier and Variable attributes that look like this:

The Reference qualifier includes the dependency, and the Variable attribute ensures that the list of choices is updated when the Category variable changes.

View solution in original post

Brad Bowman · ‎09-08-2023

I'm not following what the 'universal request' table is - is this a custom table? If so, do you have a dependent_value or similar column to define the dependency? I have done dependent variables using the sys_choice table, so this would be similar. Is your category variable a select box that you are populating with a choice list, or choice table and field, or script, or are you using a lookup select box?

flsn2 · ‎09-08-2023

Hi sorry,

Let me try to be clear.

on this picture

I got category and subcategory. When you choose a value in the category the subcategory will show only the ones related to the specific value from the category. This is on universal_request.

I need to make the samething but on a catalog item that would create a UR request.

Tell me if you need additional infos thx

Brad Bowman · ‎09-08-2023

I'm not familiar with Universal Request, but it's likely the same architecture as incident, hr case,... I installed the plug-in in my PDI, but am not seeing any demo data, so I'm not sure how to create a Universal Request. When you are viewing the record as shown in your screenshot, what table is showing in the URL - incident.do, sn_hr_core_case... or something else? If you right-click on the Subcategory field label and choose Configure Dictionary, what Table is shown? Are there a list of Choices in a Related List that show all of the possible Subcategories and their Dependent value?

I'm thinking you will likely use a lookup select box for each variable with a certain reference qualifier on each to display the correct choices and enforce the dependency

flsn2 · ‎09-08-2023

universal_request.do