Notes/Domino XPages Development Forum - Combining Notes and External Data then sorting by External in XPages

This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

~Helga Desweman

Mar 29, 2011, 2:38 PM

10 Posts

Combining Notes and External Data then sorting by External in XPages

Category: Other
Platform: Windows
Release: 8.5.2
Role: Developer
Tags: View Control,External RDBMS,Sorting
Replies: 2

Looking for some ideas on how to best solve this.

First some background:

I currently have a set of documents in a Notes database, on those documents is a key to some information in a RDBMS.
I used a View Control and computed some columns to lookup info in the RDBMS based on the key (in another column). That works fine and the view displays all the data I need.
This is about 3000 documents and is looking up into RDBMS table that has about 50,000 records.

The trick is I would like to sort the View by one of the columns of data from the RDBMS.

I already assume I will need to change from the View Control to a Repeat. How best to get the output sorted by the column of external data?

Thanks,

Steve

~Vera Opfreechekakol

Mar 29, 2011, 5:27 PM

14 Posts

Re: Combining Notes and External Data then sorting by External in XPages

I suggest to store sort value inside Notes document.

~Helga Desweman

Mar 29, 2011, 8:16 PM

10 Posts

Re: Combining Notes and External Data then sorting by External in XPages

That is what we are trying to avoid.

The key never changes but this value in the RDBMS does change and creates in a maintenance issue of getting these changes into the Notes system.