Dataset not working

[Jyoti1]

select distinct attribute2 as ID from dataset_values where datasetname='Blackline Entities and Teams' and attribute1=${dynzone}

I am getting error occurred when choosing zone attribute

Zone ->region Zone is the parent for region

[armaanzahir]

Hi @Jyoti1 ,

Can you provide the attribute definition of the "Zone" dynamic attribute.

The below query should work for the Region Dynamic Attribute:

select distinct attribute2 as ID from dataset_values where dataset_values.datasetname='Blackline Entities and Teams' and attribute1='${dynzone}'

Thanks,

Armaan

[Jyoti1]

select distinct attribute2 as ID from dataset_values where datasetname='Blackline Entities and Teams' and attribute1=${dynzone}

This query is working for other endpoint

[Jyoti1]

[Jyoti1]

error

{"log":"2023-07-03 17:26:26,004 [http-nio-8080-exec-44] DEBUG workflow.WorkflowmanagementController - processing attribute region\n","stream":"stdout","time":"2023-07-03T17:26:26.004541399Z"}
2023-07-03T22:56:26+05:30-ecm-{"log":"2023-07-03 17:26:26,004 [http-nio-8080-exec-44] DEBUG workflow.WorkflowmanagementController - attribute region need to be displayed\n","stream":"stdout","time":"2023-07-03T17:26:26.004555781Z"}
2023-07-03T22:56:26+05:30-ecm-{"log":"2023-07-03 17:26:26,031 [http-nio-8080-exec-44] ERROR errors.GrailsExceptionResolver - MissingMethodException occurred when processing request: [POST] /ECM/workflowmanagement/recreatedyna/527\n","stream":"stdout","time":"2023-07-03T17:26:26.03134099Z"}
2023-07-03T22:56:26+05:30-ecm-{"log":"No signature of method: [Ljava.lang.String;.split() is applicable for argument types: (java.lang.String) values: [,]\n","stream":"stdout","time":"2023-07-03T17:26:26.031371022Z"}
2023-07-03T22:56:26+05:30-ecm-{"log":"Possible solutions: split(groovy.lang.Closure), wait(), sort(), tail(), toList(), wait(long). Stacktrace follows:\n","stream":"stdout","time":"2023-07-03T17:26:26.031375475Z"}
2023-07-03T22:56:26+05:30-ecm-{"log":"groovy.lang.MissingMethodException: No signature of method: [Ljava.lang.String;.split() is applicable for argument types: (java.lang.String) values: [,]\n","stream":"stdout","time":"2023-07-03T17:26:26.031380044Z"}
2023-07-03T22:56:26+05:30-ecm-{"log":"Possible solutions: split(groovy.lang.Closure), wait(), sort(), tail(), toList(), wait(long)\n","stream":"stdout","time":"2023-07-03T17:26:26.031384631Z"}
2023-07-03T22:56:26+05:30-ecm-{"log":"\u0009at com.saviynt.ecm.workflow.WorkflowmanagementController$_getUnBindDAs_closure452.doCall(WorkflowmanagementController.groovy:17460)\n","stream":"stdout","time":"2023-07-03T17:26:26.031388301Z"}
2023-07-03T22:56:26+05:30-ecm-{"log":"\u0009at com.saviynt.ecm.workflow.WorkflowmanagementController.getUnBindDAs(WorkflowmanagementController.groovy:17445)\n","stream":"stdout","time":"2023-07-03T17:26:26.031392093Z"}
2023-07-03T22:56:26+05:30-ecm-{"log":"\u0009at com.saviynt.ecm.workflow.WorkflowmanagementController$_closure296_closure991.doCall(WorkflowmanagementController.groovy:17052)\n","stream":"stdout","time":"2023-07-03T17:26:26.031395841Z"}
2023-07-03T22:56:26+05:30-ecm-{"log":"\u0009at com.saviynt.ecm.workflow.WorkflowmanagementController$_closure296.doCall(WorkflowmanagementController.groovy:16879)\n","stream":"stdout","time":"2023-07-03T17:26:26.031398171Z"}

select distinct attribute2 as ID from dataset_values where dataset_values.datasetname ='Blackline Entities and Teams' and attribute1 = ${dynzone}

[Jyoti1]

same attributes working for other endpoint

logs-
og":"2023-07-03 18:16:50,277 [http-nio-8080-exec-49] DEBUG workflow.WorkflowmanagementController - attrToHide = []\n","stream":"stdout","time":"2023-07-03T18:16:50.277449076Z"}
2023-07-03T23:46:50+05:30-ecm-{"log":"2023-07-03 18:16:50,282 [http-nio-8080-exec-49] DEBUG workflow.WorkflowmanagementController - processing attribute dynregion\n","stream":"stdout","time":"2023-07-03T18:16:50.282837076Z"}
2023-07-03T23:46:50+05:30-ecm-{"log":"2023-07-03 18:16:50,282 [http-nio-8080-exec-49] DEBUG workflow.WorkflowmanagementController - attribute dynregion need to be displayed\n","stream":"stdout","time":"2023-07-03T18:16:50.282849038Z"}
2023-07-03T23:46:50+05:30-ecm-{"log":"2023-07-03 18:16:50,283 [http-nio-8080-exec-49] DEBUG workflow.WorkflowmanagementController - tempVal======'LATAM'\n","stream":"stdout","time":"2023-07-03T18:16:50.284042104Z"}
2023-07-03T23:46:50+05:30-ecm-{"log":"2023-07-03 18:16:50,284 [http-nio-8080-exec-49] DEBUG workflow.WorkflowmanagementController - bindingMap====before ==[VAL:'LATAM', DYNREGION_unquoted:, userkey:'148093', DYNZONE_unquoted:LATAM, ?1:'1', USERKEY:'148093', endpointattributetype:'1', dynzone:'LATAM', action:'recreatedyna', id:'526', ID:'526', val:'LATAM', controller:'workflowmanagement', ACCOUNTS:'0', REQUESTOR:163961, requestor:163961, dynregion:'', requestee:148093, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', ENDPOINTATTRIBUTETYPE:'1', dynregion_unquoted:, DYNZONE:'LATAM', DYNREGION:'', REQUESTEE:148093, accounts:'0', dynzone_unquoted:LATAM]\n","stream":"stdout","time":"2023-07-03T18:16:50.284051867Z"}
2023-07-03T23:46:50+05:30-ecm-{"log":"2023-07-03 18:16:50,284 [http-nio-8080-exec-49] DEBUG workflow.WorkflowmanagementController - binding map is [VAL:'LATAM', DYNREGION_unquoted:, userkey:'148093', DYNZONE_unquoted:LATAM, ?1:'1', USERKEY:'148093', endpointattributetype:'1', dynzone:'LATAM', action:'recreatedyna', id:'526', ID:'526', val:'LATAM', controller:'workflowmanagement', ACCOUNTS:'0', REQUESTOR:163961, requestor:163961, dynregion:'', requestee:148093, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', ENDPOINTATTRIBUTETYPE:'1', dynregion_unquoted:, DYNZONE:'LATAM', DYNREGION:'', REQUESTEE:148093, accounts:'0', dynzone_unquoted:LATAM]\n","stream":"stdout","time":"2023-07-03T18:16:50.284137253Z"}
2023-07-03T23:46:50+05:30-ecm-{"log":"2023-07-03 18:16:50,284 [http-nio-8080-exec-49] DEBUG workflow.WorkflowmanagementController - SQL query is select distinct attribute2 as ID from dataset_values where datasetname='Blackline Entities and Teams' and attribute1='LATAM'\n","stream":"stdout","time":"2023-07-03T18:16:50.284202932Z"}
2023-07-03T23:46:50+05:30-ecm-{"log":"2023-07-03 18:16:50,284 [http-nio-8080-exec-49] DEBUG workflow.WorkflowmanagementController - attribute dynregion need to be displayed done..\n","stream":"stdout","time":"2023-07-03T18:16:50.284559968Z"}
2023-07-03T23:46:50+05:30-ecm-{"log":"2023-07-03 18:16:50,284 [http-nio-8080-exec-49] DEBUG workflow.WorkflowmanagementController - exit recreatedyna attrid = 526\n","stream":"stdout","time":"2023-07-03T18:16:50.284568778Z"}

[rushikeshvartak]

Change order index and try