List Collector Dependency

[kambleneeta20]

Hi Experts,

In Catalog item there are 2 List collectors , first for - "In use" Asset and Other for -"Not in Use" ;both are pulling record from same class.

Here requirement is if record is selected in first List Collector then that record should not be visible in second List collector" .

What filter condition should add to achieve it ?

Thank you.

[palanikumar]

Hi,

Let me suggest you a better option without Client Script

Goto variable List collection_1

Inside variable definition select Type Specification tab

Set Reference qualifier with below text:

javascript:"sys_idNOT IN"+current.variables.list_collection_2;

Set Variable attributes with below text:

ref_qual_elements=list_collection_2

Note: Replace list_collection_2 with actual name of the variable. 

Repeat the same on another variable with variable names updated to refer variable 1.

I tested this in my instance. It is working fine

[kambleneeta20]

Hi,

Thanks for your reply.

However already one reference qualifier has been added where only "Assigned to me" asset should only visible .

When I am trying with your suggested steps , it is not working as expected.

I am trying with the below query - 

javascript:"sys_idNOT IN"+current.variables.asset^assigned_toDYNAMIC90d1921e5f510100a9ad2572f2b477fe;

 Could you please suggest ?

Thank you.

[-O-]

What is after keyword "javascript:" must be valid JavaScript. And what you have there, is not valid JavaScript. Would you have used the code tool:

it would have been immediately visible:

javascript:"sys_idNOT IN"+current.variables.asset^assigned_toDYNAMIC90d1921e5f510100a9ad2572f2b477fe;

vs.

javascript: "sys_idNOT IN" + current.variables.asset + "^assigned_toDYNAMIC90d1921e5f510100a9ad2572f2b477fe";

That should do it too. And you can copy it for the other list collector; just need to replace asset with the name of the "current" list collector.

[palanikumar · Accepted solution]

Your query has some issue. While writing query for this you should remember which is dynamic and write query accordingly. In your string current.variables.asset is a dynamic value rest are static string. So, in your condition you have to concate static string with dynamic value. So, your condition should be as below:

javascript:"sys_idNOT IN"+current.variables.asset + "^assigned_toDYNAMIC90d1921e5f510100a9ad2572f2b477fe";

You have to add variable attributes as well. Without variable attributes, other variable does not get refreshed.

Thank you,

Palani

[kambleneeta20]

Thanks a lot it is working.