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

From: Zach Black <>
To: "Bee-Lindgren, Bert" <>, "" <>
Subject: Re: [grouper-users] Grouper Loader SQL Order by
Date: Thu, 5 Sep 2019 20:07:28 +0000
Arc-authentication-results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=nebraska.edu; dmarc=pass action=none header.from=nebraska.edu; dkim=pass header.d=nebraska.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=VUeT2++WTVU3PFyBhJxxnwRQjhQtsCStxG3sUS/9TRk=; b=H9aLziZSHypKL+R4rrjjzWIvJUoiA6JCkvMS1OXhSf4OscNQKvTZfIkIjwUlJeqosnZ0etJbBbWuGOMJvX4kLYNxKZ8M43lhI6edfl+BeZxQ9I0GuNWd7UqgYLOUNIz2A6SkX/J177y30OqdyEf5qiLwqNeoqiJvcDHoypY6QR+0MolEYJ9zazGFJrevzHkCNXZwVPkpvYT68wyA3kTWcd04d98daW70H26M5gTvJ9bF/eQXWWgAPy+ZYf8JmnpXnvuBXI+V3WgvlCig4uRWF3FHc1WOzeFKso7O9LcEm2yNlUmq1DzDSU/GgsgeHfvSBZQIjI+akZd/xxaOslgb4g==
Arc-seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=N53gqRd3ciai6di5Xm0+eoh9IMXtOjWOJQ8aVkAETz45lzPbovcPs3hUDkQX4ExllQwIIXfJkhNU6ZVFvDFEfYjJekwyCezcic5TKDVqlZ/TrIqAF2kXNFAnavhfs/dhm7AGOe9WgdWc9AgcUnFwahGz8lAFStm+ArJLUpatBQTPTEmy5TIdH1FTzUYbdW37JMwzXe8WAb+reE3t7s3s9lILUyoUd5RgMtIF+i6bFcGQxzxSV0N4E55pwIiCLodF5+oKY2M5DvmkezmfQFvbu3fPDn/CRW9vIBl2PJUSZEQOL9CI2MzMqGNyPvwG1BeqZz7RcsiOkabnHUCyqlwHWA==

Thank you all for your inputs! I will continue to experiment. We've since resolved what was causing me to look in this direction, but I will put this in my pocket for cases that might come up in the future.

Zach Black

Manager Identity & Access Management

University of Nebraska ITS | Cybersecurity & Identity

123.1 501 Building, Stadium Drive, 68588-0203

402-472-7650

From: Bee-Lindgren, Bert <>
Sent: Thursday, September 5, 2019 2:32 PM
To: <>; Zach Black <>
Subject: Re: Grouper Loader SQL Order by

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!