Grouper Users - Open Discussion List

["Bee-Lindgren, Bert" <>]

Grouper Loader always adds "order by group_name" to what you give it. If you wished to also define an order by (eg, to reuse a query that already had an order by), you'd have to tell grouper about that reused query as a subquery.

I think something like this would work:

select subject_id, subject_source_id, group_name from (select ... REUSED QUERY THAT INCLUDED ORDER BY).

Or create a simple view that wraps REUSED QUERY.

--Bert

---

From: <> on behalf of Zach Black <>
Sent: Wednesday, September 4, 2019 1:11 PM
To: <>
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

123.1 501 Building, Stadium Drive, 68588-0203

402-472-7650