Database Query Results Format

[Greg_Ferran]

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

[Jordan_Polaniec]

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 

[Greg_Ferran]

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

[Jordan_Polaniec]

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

[Greg_Ferran]

Found it Jordan!

Thanks for your quick responses!