Click HERE to see how Saviynt Intelligence is transforming the industry. |
09/23/2024 03:05 AM
Hi Team
Am trying to Update image of an application for ARS UI, hence writing below Enhanced Execution query but getting below error:
Here is the the query am using to update the image:
select 'app.svg' as ENDPOINTS__IMAGE_ID, ENDPOINTS.ENDPOINTKEY as ENDPOINTS__PRIMARYKEY from ENDPOINTS where ENDPOINTS.ENDPOINTKEY in (111)
Any idea where am i making mistake?
Regards
Sangita Ladi
09/23/2024 09:12 AM - edited 09/23/2024 10:49 AM
select 'app.svg' as ENDPOINTS__IMAGE_ID, ENDPOINTKEY as ENDPOINTS__PRIMARYKEY from ENDPOINTS where ENDPOINTKEY =111;
OR
SELECT ENDPOINTKEY AS ENDPOINTS__PRIMARYKEY,'app.svg' AS ENDPOINTS__IMAGE_ID FROM ENDPOINTS where endpointname='Rushi App' limit 1 |
09/23/2024 10:46 AM
@sangitaladi
select 'app.svg' as ENDPOINTS__IMAGE_ID, ENDPOINTKEY as ENDPOINTS__PRIMARYKEY from ENDPOINTS where ENDPOINTKEY =111;
or
select 'app.svg' as ENDPOINTS__IMAGE_ID, ENDPOINTS.ENDPOINTKEY as ENDPOINTS__PRIMARYKEY from ENDPOINTS where ENDPOINTS.ENDPOINTKEY in ('111')