Question
Belvnesheconombank
BY
Last activity: 19 Feb 2018 2:13 EST
Referencing to pageList property from word document
Hi!
I need to reference to the PageList property from Word template. When I indicate property .MyPage(1).SomeProperty than system throwing an exception:
com.pega.pegarules.pub.clipboard.InvalidReferenceException: The reference .MyPage(1).Position is not valid. Reason: unexpected character '&' at position 9, expected end of name
When I use the correspondence rule in Word template I see extra carriage that I not needed so corr-rule useless for me.
Tell me please how I can reference to needed property in PageList?
Thanks in advance!
***Edited by moderator, Maryrita: moved to Product Support from Applications***
Accepted Solution
Pegasystems Inc.
IN
Referring a page list property in word template is not supported. Only top level properties can be referenced using pega reference tag.
PEG
IN
Hi,
We usually use below syntax to refer pagelist properties in excel. I believe it should work for word also.
{.pxResults().pxCreateOpName}
Please try with above mentioned syntax and update accordingly.
Belvnesheconombank
BY
Thanks for answer, but this answer are not working
I use reference as data field in Word with reference {pega:reference .Insurant(1).BirthDate}. But after executing wordMerge I see the exception.
You can see source reference and result in attached screenshots of word template.
Through executing Pega replace my brackets to URL-format and then try to use formatted URL-reference. So very clear that raference like .Insurant(1).BirthDate is not exist and not valid in current memory state instead .Insurant(1).BirthDate.
Pegasystems Inc.
US
I cannot recall if pagelist properties are supported for this feature or not. And in either case the issue may have more to do with the URL encoding/decoding rather than the Word merge feature itself.
Do any SMEs know if this type of property is supported?
Pegasystems Inc.
IN
Hi,
Please find the attached screenshot and it shows the reference fields used it in Pega sample Word merge feature. You can try similar reference fields. If your field is not in the similar format then it may not work properly.
Belvnesheconombank
BY
Hi! Thank you for answer, but what do you mean? Two spaces in start and finish of reference near brackets? You can see attached screenshot named "Reference.png" and you will see that all right. Problem in (1), not in formats. I work with merging data to word documents almost 3 years and I could not make a mistake with formats. I guarantee you this.
Accepted Solution
Pegasystems Inc.
IN
Referring a page list property in word template is not supported. Only top level properties can be referenced using pega reference tag.