Posts

Showing posts from April, 2024

Update Login JSON

  {   "actions": {     "Update Login": {       "call": [         {           "name": "updateuserdisplayname",           "connection": "userAuth",           "url": "https://rushi.saviyntcloud.com/ECM/api/v5/updateUser",           "httpMethod": "POST",           "httpContentType": "application/json",           "httpParams": "{\"username\":\"${user?.username}\",\"displayname\":\"${(user?.employeeType == 'Permanent Employee' && user?.entity==null) ? user?.firstname + ' ' + user?.lastname : (user?.employeeType!='Permanent Employee' && user?.customproperty3=='89' && user?.entity==null) ? user?.firstname+' '+user?.lastname+'External':(user?.employeeType!='Permanent Employee' && user?.entity==null) ? user?.firstname+...

SQL - Get Request assigned to Admin and Reassigned

  SELECT   DISTINCT   Substring_index ( Substring_index ( ar . comments ,   '<br>' ,   - 1 ) ,                  '</span>' ,   1 )   AS                  reassigned ,                  Substr ( jbpmprocessinstanceid ,   Instr ( jbpmprocessinstanceid ,   '.' )                                                +   1 ,   Length (                  jbpmprocessinstanceid ) )    ...