auto approve request when resource owner is requester or requestee

[NM]

Hi Team,

As per the use case we have to approve the request if it is submitted by endpoint resource owner or submitted for endpoint resource owner

Tried these, didn't work, any other variable which can be used?

endpoints.resourceowner eq requestedby.username

endpoints.requestowner eq requestedby.id

endpoints.requestowner eq user.id

Thanks

[Kaustubh]

IF ELSE Component

Condition: (com.saviynt.ecm.identitywarehouse.domain.Usergroup_users.executeQuery("select ugu.id from Usergroup_users ugu where ugu.user_groupkey = '${endpoints?.requestowner}' AND ugu.userkey= '${requestedby?.id}'")?.size() != 0) Expression Language: groovy

Please try above when you are mapping resource owner.

[NM]

Hi @Kaustubh , I tried this 

(com.saviynt.ecm.identitywarehouse.domain.Endpoints.executeQuery("select e.requestowner from endpoints e where e.endpointname = '${endpoints.endpointname}' AND e.requestowner= '${requestedby?.id}'")?.size() != 0)

i am getting an error "Cannot get property endpointname on null object"

[rushikeshvartak]

(com.saviynt.ecm.identitywarehouse.domain.Endpoints.executeQuery("select e.requestowner from endpoints e where e.endpointkey= '${endpoint}' AND e.requestowner= '${requestedby?.id}'")?.size() != 0)

[NM]

@rushikeshvartak @Kaustubh , I hardcoded the endpoint key but received script evaluation error

script evaluation error: javax.script.ScriptException: org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: ( near line 1, column 41 [select e.requestowner from endpoints.get(requestaccesskey) e where e.endpointkey= 5 AND e.requestowner= 336 ]

[Kaustubh]

Please share WF screenshot and make sure to map resource owner under endpoint.

[NM]

Hi @Kaustubh @rushikeshvartak 

Here is the workflow screenshot.. quite basic

Type - Parallel

[Kaustubh]

Working for me.

selected Resource owner group at endpoint.

[NM]

Hi @Kaustubh , we have a single user instead of user group that is where it is not working.

@Kaustubh , it is bit urgent for us.. if you can help out with only single user.

[Kaustubh]

Trying... Couldn't figure out for single user as of now. As it is urgent, create a user group and follow the steps for now.

If solution works, accept as solution.

[rushikeshvartak]

Share query

[Kaustubh]

I tried the query shared by you. I get result in data analyzer but cannot submit the access request.

(com.saviynt.ecm.identitywarehouse.domain.Endpoints.executeQuery("select e.requestowner from endpoints e where e.endpointkey= 1167 AND e.requestowner= '${requestedby?.id}'")?.size() != 0)

(com.saviynt.ecm.identitywarehouse.domain.Endpoints.executeQuery("select e.requestowner from endpoints e where e.endpointkey= '${endpoint}' AND e.requestowner= '${requestedby?.id}'")?.size() != 0)

[rushikeshvartak]

Did you validated logs ?

[Kaustubh]

What should I look for in the logs?
Here's what I thought might be helpful:

[rushikeshvartak]

This are unwanted error. Logs when request id raised or where you added block

[Kaustubh]

Using query in if-else block:

(com.saviynt.ecm.identitywarehouse.domain.Endpoints.executeQuery("select e.requestowner from endpoints e where e.endpointkey= '${endpoints}' AND e.requestowner= '${requestedby?.id}'")?.size() != 0)

It is fetching endpoint name and trying to match with endpoint key.

2024-07-24T03:11:50.552273732Z stdout F org.jbpm.api.JbpmException: script evaluation error: javax.script.ScriptException: org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: ( near line 1, column 41 [select e.requestowner from endpoints.get(requestaccesskey) e where e.endpointkey= 'Matillion' AND e.requestowner= '977']; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: ( near line 1, column 41 [select e.requestowner from endpoints.get(requestaccesskey) e where e.endpointkey= 'Matillion' AND e.requestowner= '977']

[rushikeshvartak]

Use below logic

(com.saviynt.ecm.identitywarehouse.domain.Endpoints.executeQuery("select e.requestowner from Endpoints e where e.endpointname= '${endpoints}' AND e.requestowner= '${requestedby?.id}'")?.size() != 0)

[rushikeshvartak]

@NM  Is this issue resolved ?

[NM · Accepted solution]

Hi @rushikeshvartak , I tried with endpoints in groovy language it wasn't working .. so went ahead with custom assignment

[rushikeshvartak]

Please share query

[Dave]

Hello @NM - Sharing the actual solution here will help others who are experiencing a similar situation. 

Thank you,
Dave

[rushikeshvartak]

@NM  Can you please share SQL query used to help other facing same issue in future

[NM]

Hi @rushikeshvartak , after developing the solution half way.. our requirement was changed entirely .. I am working on the approval process ... I will share once it is completed.

[NM]

Hi @rushikeshvartak , got the same error

i am getting an error "Cannot get property endpoint on null object"

[naveenss]

Hi @NM use the below Query. This is working for me in 24.4 if the request is raised by the resource owner or if its requested for resource owner. Let me know the outcome!

(com.saviynt.ecm.identitywarehouse.domain.Endpoints.executeQuery("select e.requestowner from Endpoints e where e.endpointname = '${endpoints.endpointname}' AND (e.requestowner= '${requestedby?.id}' OR e.requestowner='${user.id}')")?.size() != 0)