Click HERE to see how Saviynt Intelligence is transforming the industry. |
09/11/2024 07:38 AM
HI,
select concat(AT.provisioningcomments,'-Manually_Actioned_BAU') as arstasks__provisioningcomments, AT.taskkey as arstasks__PRIMARYKEY from arstasks AT where AT.taskkey in
()
we are getting error when we are passing more than 6 taskkey in this query.
it is working fine for 5 taskey. can someone help here? is there any limit in 24.3 version
Solved! Go to Solution.
09/11/2024 07:45 AM
one more issue:
we are trying to update provisioning comment of task whose corresponding account is suspended from import service.
Query:
select concat(AT.provisioningcomments,'-Manually_Actioned_BAU') as arstasks__provisioningcomments, AT.taskkey as arstasks__PRIMARYKEY from arstasks AT where AT.taskkey in
(1234567)
we are not able to do so. getting error: ARSTASKS : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'accountkey of Task' does not exist or one of its queried refer
09/11/2024 07:50 AM - edited 09/11/2024 10:01 AM
use below query
SELECT Concat(Ifnull(AT.provisioningcomments, ''), '-Manually_Actioned_BAU') AS
arstasks__provisioningcomments,
AT.taskkey AS
arstasks__PRIMARYKEY
FROM arstasks AT
WHERE AT.taskkey IN ( 1234567 );
09/11/2024 09:46 AM - edited 09/11/2024 09:47 AM
Use this : need to handle provisioningcomments being null
select concat(ifnull(AT.provisioningcomments,'Empty'),'-Manually_Actioned') as arstasks__provisioningcomments, AT.taskkey as arstasks__PRIMARYKEY from arstasks AT where AT.taskkey in (48508);
I have tested it with below and it works so shoud not be any limit on values inside "in"
select concat(ifnull(AT.provisioningcomments,'Empty'),'-Manually_Actioned') as arstasks__provisioningcomments, AT.taskkey as arstasks__PRIMARYKEY from arstasks AT where AT.taskkey in (48508,48609,48608,48607,48606,48605,48604,48505,48504);
09/11/2024 07:46 AM
You can add for multiple please share logs
09/12/2024 05:47 AM
want to set refrence key as null in EIC version:
select null as ACCOUNTS__referenced_accountkey, A.accountkey as ACCOUNTS__PRIMARYKEY from ACCOUNTS A where A.accountkey in (607897971)
but getting error: Error while updating table: ACCOUNTS : Incorrect integer value: 'null' for column 'REFERENCED_ACCOUNTKEY' at row 1
09/12/2024 08:19 AM
Does your original question resolved ? @WeAreVoid
You can't set null in REFERENCED_ACCOUNTKEY
09/12/2024 09:15 AM
can we add dummy integer value?
for ex- 0 or negative value
09/12/2024 09:24 AM
You can map to any suspended account
09/12/2024 11:40 AM
@rushikeshvartak Can't we set the REFERENCED_ACCOUNTKEY to null?
@WeAreVoid can you try this:
select '' as ACCOUNTS__referenced_accountkey, a.accountkey as ACCOUNTS__PRIMARYKEY from ACCOUNTS a where a.accountkey in (607897971)
09/12/2024 11:50 AM
we have tried tried below format . but it is not working
''
'NULL'
NULL
09/12/2024 12:37 PM
@WeAreVoid
We can't pass 0 or -1 it has to have the accountkey. Pass any dummy accountkey from accounts table.
09/12/2024 01:07 PM
Its foreign key hence it can’t be null
09/12/2024 01:43 PM
Hi, yes orginal question is resolved.
We can pass multiple taskkey in in () operator.