How to Restrict users for List collector?

[Mitra2]

Hi all,

In my catalog item i have 2 variables 

variable 1 - select matter: refers to u_matter table

variable 2 - folder permission (type-list collector)- refers to user table

i have a table(matter details)  in my instance with following details

My requirement is

1.If i select matter 12345 in variable 1 it should check if matter have timekeeper number in matter details table, if so  timekeeper number available for the selected matter those timekeepr users should be hidden in variable 2(list collector) when type is exclusion.

2.If i select matter 12345 in variable 1 it should check if matter have timekeeper number in matter details table, if so  timekeeper number available for the selected matter those timekeepr users should only visibile in variable 2(needed only inclusion users) when type is inclusion.

note : 1.we have time keeper number in user table.

         2.we have relation between u_matter table and matter details table.(matter)

         3.we have relation between matter details table and user table( timekeeper )

How can i achieve this via using onChange scripts

[Jan Cernocky]

Hi Mitra,
I need to clarify few things

1) What is the expected behaviour? When you change the matter(variable1), the users list (variable2_ should be automatically populated (=>onChange script) or you select users manually and the selection should be limited to inclusions only(=>Reference qualifier)?

2) You originally talked about 2 variables but your script works with 3 - matter, client and permission. Can you clarify? This just confused me completely.

3) Do you have more timekeepers in your matter_details table in a one record? From your screenshot it seems there is only one, but from the scrip I don't think so.

Anyway - your script include seems to have switched IF and WHILE - I believe you want tu use while(gr.next()) to go through all the findings and then use IF

I advise you to add some gs.log lines in your code to make sure you are getting correct values at certain stages.

[Mitra2]

Hi Jan,

1.There is no change in behaviour.When i selected any matter in variable 1 i need to select the users manually if the matter is inclusion then those users should only be visible in list or if matter is exclusion then those should not be visible in the list.

2. You can ignore client part in the code which is similar to matter.

3.in matter details table we can have multiple timkeepers for reference i have added only 1.

[Mitra2]

Hi Jan,

Can you please provide me the excat script based on my requirement this would be more helpful and thanks in advance.