order by in loader queries causes an issue

Sent: Wednesday, September 04, 2019 1:11 PM
To: grouper-users@internet2.edu
Subject: [grouper-users] Grouper Loader SQL Order by

Hello Grouper users list, 

I'm wondering if anyone has put together a loader that includes an Order by clause in their SQL query? I'm attempting to run one and when the diagnostic returns in error, it shows that there is an 'Order by group_name' appended to the query in addition to the one I included, and does not show up when I omit my 'order by'. Is Grouper just always ordering by group name when it runs a query, or does anyone have a suggestion for how I might be able to include mine in the mix?

Thanks!

Zach Black

Manager Identity & Access Management

University of Nebraska ITS | Cybersecurity & Identity