Hello, everyone!
I would appreciate any help.
Is there a way to enhance the default-query on <sn-record-picker>? I tried insert a javascript function, but no success.
We are using a widget on Portal, querying the table "cmn_department". The field is to choose one or more users shown on the field "dept_head" of cmn_department table. But if a user is dept_head of more than one group, its name shows duplicated. So, I´m looking for a better way to query, removing any duplicated users.
Thanks in advance.
<sn-record-picker field="c.data.selectedAlternate" table="'cmn_department'" multiple="true" display-field="'dept_head'"
default-query="'nameSTARTSWITHadm^dept_headISNOTEMPTY'" value-field="'dept_head.sys_id'" search-fields="'dept_head'"
page-size="1000">
</sn-record-picker>
