Help with script for advanced reference qualifier

[Lon Landry4]

Hi Community,

The last current.variables works fine. (+'assigned_to=' + current.variables.tb_submitted_for;) no issues

But, 'sys_idNOT LIKEcurrent.variables.first_list_of_assets^' is not working. - no errors

javascript&colon'install_statusNOT IN7,8,17,^'+'model_categoryNOT LIKEServer^'+'sys_idNOT LIKEcurrent.variables.first_list_of_assets^'+'assigned_to=' + current.variables.tb_submitted_for;

The value in the first_list_of_assets field is a list of Sys IDs separated by a comma.

[AshishKM]

Hi @Lon Landry4 , 

Please use the updated one as below.

'sys_idNOT LIKE'+current.variables.first_list_of_assets^

avascript&colon'install_statusNOT IN7,8,17,^'+'model_categoryNOT LIKEServer^'+'sys_idNOT LIKE'+current.variables.first_list_of_assets^'+'assigned_to=' + current.variables.tb_submitted_for;

-Thanks,

AshishKM

[Lon Landry4]

I tried that syntax earlier -'sys_idNOT LIKE'+current.variables.first_list_of_assets^
but the filter stops working completely.

[Lon Landry4]

please see attachment further down in chain for code example

[Sagar Pagar]

Hi @Lon Landry4,

Try this -

javascript: 'install_statusNOT IN7,8,17^model_categoryNOT LIKEServer^sys_idNOT IN' + current.variables.first_list_of_assets + '^assigned_to=' + current.variables.tb_submitted_for;

Thanks,

Sagar Pagar