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?