Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] Grouper Loader SQL Order by

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] Grouper Loader SQL Order by


Chronological Thread 
  • From: "Bee-Lindgren, Bert" <>
  • To: "" <>, Zach Black <>
  • Subject: Re: [grouper-users] Grouper Loader SQL Order by
  • Date: Thu, 5 Sep 2019 19:32:44 +0000
  • Arc-authentication-results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=oit.gatech.edu; dmarc=pass action=none header.from=oit.gatech.edu; dkim=pass header.d=oit.gatech.edu; arc=none
  • Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=AZhb7qUo61lv7ejWre3uwUg/Vou8USuJpNj/AmTihaI=; b=KEj2R8GThbqwgy6BajnxvlgePoBLvXkoR2JXfNm8QQT/1FtdQHT+CQ0dvfSY9/dSrrAwDxuw9bgr+FWDsw5PG0PMaO+OWU0jCLLndhwWIlNjU3PMO+mD0ZHxIlMu1jSpQHM6SRWv+aR+SDiSWs7gghYxc6OeMZB3mRjZFln4k8aPTFlQhHImWakw0NQmkA7KM3NnU36K4n4vhtunC3RbfqD5uz09m9YhmcRDROKeShN65FzwqASW/LKGKHs/2rIdMUMnet9t/TzTszhljAkHjaAyjPVlzx1/ie0JoBQIkFgE/Pi7Kzvwh4LIhuxD/qFn5kwU01ySBLPHE9stB2wzOA==
  • Arc-seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=MslO7r+mcrkkxUd9umdlx4rFVHLyH9oaemtIDpBYGEtNWpZC9lheBSQbg+8KvwmxI9bOrCZrepy4qXbLrzsCSNto8lItZod/CiUfo1YiSzScJZGfW7BEAXZ94HkQR4miFpVEVSBLUrdv68qOjqa7/uqNm979OEN6Jn+O4QKsYXaBFMfzq7ffG9tai+NHv7BR/3252noQVl/TURdfBEhbmg+GXBN57PUfx2q0/j3vgdQxKAMbxSBkQ2kbcUxj0bpk6+HCKhpy0WoVuRE+B89o3FzdHXFsN+1/tIyYBNdTArYoI/eJg9D9PPvHxCWgSJaZm/sY4K6tu11UCR2kD911AQ==

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 (167x250)
Zach Black
Manager Identity & Access Management
University of Nebraska ITS | Cybersecurity & Identity
123.1 501 Building, Stadium Drive, 68588-0203
402-472-7650




Archive powered by MHonArc 2.6.19.

Top of Page