Peter WIRFS

Maximum rows returned from an SQL variable

Discussion created by Peter WIRFS on May 12, 2017
Latest reply on May 12, 2017 by Alexander_Trenker_120
I have a requirement to return more than 500 rows from a SQL VARIABLE object that is pulling information from an Oracle table.  Is this a site defined restriction?  How do I modify it?

I'm using it to return a list of active employees and matching it against my UC4 USER objects to determine which USER objects should be de-activated.

Outcomes