Reference Qualifier- List to List

[TD8]

I have a List Field, users can select 1 or more categories. From there, users select 1 or more sub categories from another List Field, based on the categories selected in the first field. 

After selecting something from the category field, I go to sub category and I get all items from all categories instead of items just from the selected categories.  

Tried adding a Reference Qual similar to the following but nothing works. It does return values but it only seems to filter using the last item selected in the category list.

javascript:"parentIN="+current.category.toString()

Anyone have an idea? 

Thanks

[James Chun]

Hey @TD8 ,

I am assuming that there is a 'parent' field in the subcategory record. If so, try the following:

javascript: "parent.sys_idIN" + current.category.toString();

Thanks

[TD8]

Same issue. It filters the sub categories for the last of the items select in category. 

If I select several categories in list field:

Fruit

Vegetable

The subcategory comes back with these options:

Carrot

Lettuce

Bell Pepper

No fruit items are listed. If I reverse the category selections so fruit is the last item I get fruits but no vegetables.

The subcategory should show:

Banana

Apple

Grapes

Carrot

Lettuce

Bell Pepper

[James Chun · Accepted solution]

@TD8 

I tried something similar in my PDI and it seems to be working.

1. Created 2 'List' type fields referencing RITM and SCTASK
2. In SCTASK List field, used the following Reference qualifier
3. Select two RITM records n the RITM List and can see the SCTASK List is filtered accordingly

Can you please share screenshots of your fields?

Thanks

[TD8]

Same issue:

When I select several items in category field I get only the last item selected.

Example:

Category List:

Fruit

Vegetable

Sub Category List:                                

Cabbage

Lettuce

Carrot

Sub category should show:

Banana

Grapes

Apple

Cabbage

Lettuce

Carrot