Using sn-record-picker on table "sys_user_grmember" but filtering on current user wi {{user.sys_id}}

[CKJ-BeOS]

Hi I try to use an sn-record-picker  on a widget an d want to get the group from the current logged user

i do this :

<sn-record-picker field="group_list" sn-disabled="!data.canWrite" table="'sys_user_grmember'" display-field="'group'" search-fields="'user'" value-field="'sys_id'" default-query="'{{user.sys_id}}'" page-size="10" multiple="true"></sn-record-picker>

but not work i get all group from sys_user_grmember.

Regards,

Cédric

[Saurabh Gupta · Accepted solution]

Hi @CKJ-BeOS 

Can you please try below

<sn-record-picker field="group_list" sn-disabled="!data.canWrite" table="'sys_user_grmember'" display-field="'group'" search-fields="'user'" value-field="'sys_id'" default-query="'user=javascript&colon;gs.getUserID()'" page-size="10" multiple="true"></sn-record-picker>

[CKJ-BeOS]

Thanks Gupta, it's work nice.

Very best regards,

Cédric