Section Access AND Initial Selection

[Anonymous]

Is it possible to use Section Access in the script and also set an Initial Selection. Normally I would simply set an Initial Selection for all users by just saving the QVD with the selection active, but Section Access just removes it on opening. It would be useful to have different Initial Selections for different users but at this point I'd settle for all getting the same.

Thanks,

[Gysbert_Wassenaar · Accepted solution]

You could create a table with the username (use the same field name as in the section access table) , field and the selections. The selections should be separated by pipe symbols '|'.

User  Field  Selections

----  -----  ----------

John  DimA   a|b|d

John  DimB   1|5

Pete  DimA   c|d|f

Pete  DimB   2|,5

You can add Select in Field actions to the OnOpen document trigger to set the selections. For example for field DimA the search string would be ='(' & only({<Field={'DimA'}>} Selections) & ')'. 

[Anonymous]

Yep that worked perfectly, thanks.