We have a JDBC driver connected to our Peoplesoft Database, user has
multiple records in the table, currently we just have the schema mapping
rule that mapping each column from the table into eDirectory attribute.
I guess the JDBC driver just doing the select query and get whatever the
first result back and processing it.

We would like to sort the records based on certain columns before the
driver processing the records, so the first result got fetched in by
JDBC driver is always desired record. Is there a way to do something in
SQL such as select * from table where id=? order by column



yiqian's Profile: https://forums.netiq.com/member.php?userid=9901
View this thread: https://forums.netiq.com/showthread.php?t=54012