04-16-2013 10:37 AM
We have a database query that works as it is supposed to as seen below.
The result set is added as a place holder and appends rows as it should.
Name | Address | Phone | |
Customer 1 | 123 Any Street | 333-333-3333 | |
Customer 2 | 456 Any Street | 444-444-4444 | |
Customer 3 | 789 Any Street | 555-555-5555 |
My question:
Is it possible to add the result set vertically?
Name1: Customer 1
Address1: 123 Any Street
Phone1: 333-333-3333
Name2: Customer 2
Address2: 456 Any Street
Phone2: 444-444-4444
Name3: Customer 3
Address3: 789 Any Street
Phone3: 555-555-5555
If this is not possible, is it possible to run the query from an eform and then pass the result set to the template from the eform?
I know that eform keywords are not recognized by Document Compostion and Unity Forms cannot be used with Document Compostion.
Any help is greatly appreciated.
We are on OnBase 12.02.609 SP2
Thanks,
Greg
04-17-2013 09:35 AM
Hi Greg,
Unfortunately Document Composition does not currently have the capability to add the result set to the Table vertically. Is there a business requirement that you need to meet by prepending the Column name and having the items on a separate line? If so, we can look into how we can best meet this need with a future enhancement to the product.
Thank you,
Jordan Polaniec
04-23-2013 09:47 AM
Thank you for the response Jordan.
We were able to accomplish this on the sql side.
Can I ask another question about Doc Comp?
In the OnBase 12 mrg, I see an option that is not available from the version of Document Composition we have installed.
The Keygroup Mapping dialog box.
We have Hyland Document Composition v2.0 [12.0.2.173] installed.
Is there a new version of doc comp that has this?
Thanks,
Greg
04-23-2013 10:11 AM
Hi Greg,
When you select the 'Insert the results as a table' radio button option for your XPath, have you entered any values in the Column Names text field in the External Data Source wizard? After entering a column name the 'Continue' button should become enabled. Clicking this button should take you to the Keygroup Mapping panel.
Thank you,
Jordan Polaniec
04-23-2013 10:14 AM
Found it Jordan!
Thanks for your quick responses!
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.