Hi All, I was trying to use the Advanced Document Templating to gene

lins over 9 years ago

Hi All,

I was trying to use the Advanced Document Templating to generate a word document for the data queried from Query Database. This is my query:
SELECT

projectname
,activitycategory
,activitydescription
,activitytype
,type
,updatedate

FROM ptcprojectupdate
INNER JOIN ptcupdate on ptcprojectupdate.ptcupdate_projectupdates_a_id = ptcupdate.a_id

Where ptcprojectupdate.projectname = ac!project

After running this query, I put everything into a grid in an email using the "ncolumntable" function (see attachment AppianQ18).

Now, I want to put the data into a word document instead of putting into the grid in an email.

However, I have some trouble defining the structure of my template and mapping my pv (s) into the grid. I have attached my template and Xml data input data part (I just tried one variable "project").

Can someone take a look and let me know where I did wrong? Any help would be much appreciated....

ADT Question.zip

Discussion posts and replies are publicly visible

Parents

0 venkats533 over 9 years ago

sorry, I misunderstood the question. so you are already using this smart service. as per documentation the XML Data Model is a string like
="<project>
<name>This is a simple placeholder</name>
<developer name='John' lastEmail='Smith' mail='smith@email' day='10-10-2014' />
<developer name='Frank' lastEmail='Brown' mail='frank@email' day='10-10-2014' />
</project>"
first of all your PV assignment does not look right. second, make sure the pv value is correct XML structure.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 venkats533 over 9 years ago

sorry, I misunderstood the question. so you are already using this smart service. as per documentation the XML Data Model is a string like
="<project>
<name>This is a simple placeholder</name>
<developer name='John' lastEmail='Smith' mail='smith@email' day='10-10-2014' />
<developer name='Frank' lastEmail='Brown' mail='frank@email' day='10-10-2014' />
</project>"
first of all your PV assignment does not look right. second, make sure the pv value is correct XML structure.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data