You are viewing limited content. For full access, please sign in.

Question

Question

Empty fields in Merged Field Table in Update a Word Document Activity

asked on February 24, 2016

I am using Laserfiche 10. Word 2007 document

I have a simple invoice example - One transaction Name and Address and multi-value fields for ItemNo, Description, Amount held in one Metadata Template

I want to use Update a Word Document Activity.

For simple merge I can insert any Token.

For Multi Line using a <<TableStart:mytable>> <<Merged Field>><<Merged Field>> TableEnd:mytable - you have to use a Data Source containing a list.

Search Repository returns only the first entry element in the multi value field and I am able to insert the fields in the table Update Word Activity and produce a pdf.

I created a SQL table and normalised the multi value fields into rows. I used Query Data search on the key and it returned a multi value fields. When I ran  Update Word Activity and it produced a pdf. The Table was expand by the number of elements in the query return but the fields  are blank.

Update Word Document Activity is a very important function as it is bases for report writing.

Can the Search Repository return more than the first element of a multi value field eg ItemNo_All  instead of ItemNo_1?

Why do I get blank entries in the table when I use Query Data activity?

 

  

0 0

Replies

replied on February 24, 2016

Search Repository can't return multiple field values at this time.

We'd have to see how you set up the Update Word Doc activity and the data returned by Query Data to answer your other question.

0 0
replied on February 25, 2016

Thank you I got it to work. I revisited the word document and check all the merged fields in the table. There was a strange character in one of the fields which obviously stop the activity.  yes

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.