Thanks Adhiyan and Amit for the inputs.The template was deleted accidentally deleted from the system and was not even present in the deleted deliveries folder.. seems it was deleted 7 days before I checked. Also, importing the same template from higher env was causing issues even by renaming the int...

Accidentally, few out of the box delivery templates have been deleted from the system and while trying to import the package of same template from the other environment, its giving error. Can anyone suggest the way to restore ?3:19:42 - PGS-220000 PostgreSQL error: ERROR:  duplicate key value violat...

Can someone advice me the way/commands to stop the workflow using the program/inbuilt API?

A basic one -Is there any way I can provide the read/write/delete privileges of a schema only to one Operator Group?And for the rest Operator groups it should be hidden/non accessible/readonly.Can I do this with sys filter?

Thanks Jean,Tried extracting from the extract activity, but not getting any result.Pasted is the screenshot below, where I want to extract the event XML column data which is in the ctx format. And what if I want to extract some specific field inside that XML. is there any syntax you can share?

Hello all,I need to extract the data from eventXML (ctx type) from the eventHistory schema, but as this column is in the xml format, I am unable to read in the queryDef or query activity.I need to read some of the fields from this column dynamically and further export them. Unsure the way to extract...

Thanks Jean for your inputs.Its helpful !I was also trying to create an expression (CASE WHEN/IF) in the query activity(Just before the Page activity) while fetching this field, However, on doing so, the column is completely coming blank in the report.Unsure, why!Can you name some standard factory r...

Thanks Adhiyan for the quick response.There ain't any option for the Label. Pasted is the screenshot for your reference.Note : If I use text, it shows me 0,1,2 only.

Hello friends,A very basic question:I am building a report in AC and in Page activity I am trying to get the data of a column which is of type enumeration.Instead of getting the label of the enumeration, I am getting its value.For example : I am getting values like 0,1,2 instead of getting Approved,...

Many Thanks Jean.The portion I was missing - Declaring of the variable in Delivery.Also, the syntax I used to read the variable was incorrect. Instead of <%= vars.fileXyz %> it should be <%= variables.fileXyz %>.Its working now. Thanks a lot..