Campaign Management Tool Advanced Topics

While looking into the schema, I saw in some places we are referring to an element of a different schema instead of declaring it again and again. But in some places, it is done using template attribute and other places use aggregate attribute. So to test, I though of using the element "auditTrail" declared inside the library xtk:common The element is as as below   <element name="auditTrail">     <element defOnDuplicate="true" name="createdBy" template="xtk:common:createdBy"/>     <element defOnDuplicate="true" name="modifiedBy" template="xtk:common:modifiedBy"/>     <attribute defOnDuplicate="true" default="GetDate()" desc="Creation date" label="Creation date"                name="created" type="datetime"/>     <attribute defOnDuplicate="true" default="GetDate()" desc="Modification date...

I had a scenario where I need to show some questions depending on the answers of a previous question. For example, the below test scenario So I created the Archive field for all the questions including the Radio button and Drop down one which will be used for the dynamic criteria. I had setup the visibility of the field using the Archive Field. But while previewing I realized that the questions are getting shown or hidden depending on selection (example below). So I created two new variables for the survey with names as How_was_your_last_hopital_visit and Was_your_out_of_pocket_expenses_over_budget_. Then changed the visibility criteria to use the variables. Now it is working perfectly. But when I saved the survey, it doesn't save the data of those variables. But I need those selections as well. So I added a javascript task before the Storage activity and set the tables fields from the variables so that when it is in the storage activity, it column value is populate...

I came across a scenario where I need to do some custom auditing when some fields are  changed via an input form. So for that I had to call javascript functions from an input form. I have custom schema as cus:Preference with 1:1 join with nms:Recipient. And audit was required to capture who is making change to the preference page if any. Step 1: Create an entry in the input form for the soapCall.  <form>   <container > <!--Enter the form fields here-->   </container>   <leave> <!--servi = "name of the schema where the method is declared"-->     <soapCall name=" auditPreference " service=" cus:Preference ">       <param exprIn="[@id]" type="int"/>       <param exprIn="[@recipientId]" type="int"/>       <param exprIn="[@prefAllCommunications]" type="boolean"/>       <param exprIn="[@prefAllCommunicationsModifiedDat...

I had a requirement to run the DBMS Stats on Oracle table after the table is truncated and loaded via snapshot process boxes. without new stats the tables were not returning the data. So I added a new dummy select process box "Select_Run_Stats" after the snapshots (connected with dotted lines) Then Enable the Raw SQL for the select box and enter a dummy SQL which produces the output matching the Audience. Here in the example, the audience was numeric, so I used "select 1 from dual". Now add the statement like below tin the Pre-Processing or Post-Processing section of the configuration. Now as this is a dummy select box, it doesn't matter whether you put it in pre or post section. But remember, pre-processing statements are run before the actual select statement you entered in the select process box (here "select 1 from dual") and post-processing runs after the actual select statement. BEGIN dbms_stats.gather_table_stats('schema_name...