Enhanced Query to update Security System details

[harishyara]

Hi Team,

How to update security system details using enhanced query in v23.2 ?

Please help with the syntax to convert below update query to select query of Enhanced Query?

update securitysystems set SYSTEMNAME='Security System Name', DISPLAYNAME='Security System Display Name' where SYSTEMKEY=1

Regards,

Harish

[rushikeshvartak · Accepted solution]

SELECT systemkey as securitysystems__primarykey,
'rushi' securitysystems__displayname,
'Rushi' securitysystems__systemname
FROM securitysystems WHERE SYSTEMKEY = 1;

[harishyara]

thanks @rushikeshvartak it worked, could you please give me documentation link of it where I can look into it in brief ?

[rushikeshvartak]

https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter10-Job-Control-Panel/Job-Cat...