Which version of MySQL is used in Saviynt 5.5Sp3.12.15

[AJ23494]

Hi Experts ,

I am trying to run the below query but it's giving me error . I suspect that this is due to Mysql version not supporting CTE . Could you please confirm which version of Mysql is being used in Saviynt 5.5Sp3.12.15

with recursive emp_hierarchy as
(
select employeeid ,firstname , lastname from users where jobcodedesc='Xyz'
union
select u.employeeid ,u.firstname , u.lastname
from emp_hierarchy H
join users u on H.manager=u.userkey

)
select * from emp_hierarchy ;

[AJ23494]

@rushikeshvartak@sahajranajee: Please suggest

[Paul_Meyer]

Create a New Analytics Configuration, enter "SELECT VERSION()" as Analytics Query and click on Preview.

[rushikeshvartak]

What are you trying to achieve using query.

for Version you can check using data analyzer

[AJ23494]

Hi Ruskikesh ,

i want to run a recursive query CTE in order to get hieraichical user data under VP . While trying to run the query it says that only select query allowed .

Query given below for your reference .

with recursive emp_hierarchy as
(
select employeeid ,firstname , lastname from users where jobcodedesc='EVP Global Operations'
union
select u.employeeid ,u.firstname , u.lastname
from emp_hierarchy H
join users u on H.manager=u.userkey

)
select * from emp_hierarchy ;

Thanks
Ankit Jindal

[SunithaK]

Hi,

I am also facing the same issue while trying to use recursive CTE for the same purpose ( trying to retrieve hierarchical manager details) , and not able to get the version even from both Data Analyzer as well as from analytics.

Any suggestions.

[rushikeshvartak]

Please raise freshdesk ticket to get required information

[AJ23494]

Hi Sunita ,

Looks like it's related to the MySQL version being used by SSM i.e. 5.7.x . CTE is supported in later versions of MySQL



Please refer this link for more details :
https://stackoverflow.com/questions/20215744/how-to-create-a-mysql-hierarchical-recursive-query

Thanks & Regards ,
Ankit Jindal

[SunithaK]

Hi Ankit,

The above link helped.

Thanks
Sunitha K