Role status change

[Ekata_bharati]

Hi Team,

I am trying to change the role status from Inactive to active via custom query job, however it is throwing error.

Below is the Query :

update roles set statuskey=1 where ROLEKEY=101;

Error:

can you please advise on the issue here.

Thank you,

Ekata

[indra_hema_95]

Hi @Ekata_bharati use the query like below as I am assuming you are using enhance query

SELECT 1 AS statuskey FROM roles WHERE ROLEKEY=101;

Regards,

Indra

[SumathiSomala]

@Ekata_bharati Try below

SELECT 1 AS ROLES__STATUS,ROLEKEY AS ROLES__PRIMARYKEY FROM ROLES R WHERE R.ROLE_NAME LIKE '%ABC%'

SELECT 1 AS ROLES__STATUS,ROLEKEY AS ROLES__PRIMARYKEY FROM ROLES R WHERE R.ROLEKEY=101

[Amit_Malik]

Hi @Ekata_bharati , Please follow this doc as custom queries are now called enhanced queries and format has changed significantly. - https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter10-Job-Control-Panel/Job-Cat...

SELECT rolekey as ROLES_PRIMARYKEY, 1 as ROLES __status from ROLES where rolekey=101;

[rushikeshvartak]

• Custom Query Job is deprecetad from 23.6 hence please use enhanced query job 
• Please use below query 

SELECT 
    rolekey AS roles__primarykey,
    0 AS roles__status
FROM 
    roles r
WHERE 
    r.rolekey = 101
LIMIT 1;

• Role Status Values 
  • 0: INACTIVE
  • 1: ACTIVE
  • 2: COMPOSING
  • 3: SENTFORAPPROVAL
  • 4: DECOMMISION
  • 5: MINING

Refer