Skip to Content.
Sympa Menu

grouper-users - RE: [grouper-users] CTE Queries and loader groups.

Subject: Grouper Users - Open Discussion List

List archive

RE: [grouper-users] CTE Queries and loader groups.


Chronological Thread 
  • From: "Hyzer, Chris" <>
  • To: Jeffrey Crawford <>
  • Cc: Gouper Users List <>
  • Subject: RE: [grouper-users] CTE Queries and loader groups.
  • Date: Wed, 16 Mar 2016 20:33:35 +0000
  • Accept-language: en-US
  • Authentication-results: ucsc.edu; dkim=none (message not signed) header.d=none;ucsc.edu; dmarc=none action=none header.from=isc.upenn.edu;
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:23

One more plea… I make a view for each loader job and select from the VIEW.  This separates the config in gropuer from the data people at Penn who make the views, and allows for changes to the loader data without going into Grouper.  Is that something you can do?  Yes, I would prefer not to fix this if possible J

 

From: Jeffrey Crawford [mailto:]
Sent: Wednesday, March 16, 2016 4:14 PM
To: Hyzer, Chris <>
Cc: Gouper Users List <>
Subject: Re: [grouper-users] CTE Queries and loader groups.

 

Yes I have done that, but it's just hard to read now. I guess this is a request that I could understand if someone said "WontFix" :)


Jeffrey

C.

 

 

Both pilots and IT professionals require training and currency before charging into clouds!

---------------------------------------

 

On Mon, Mar 14, 2016 at 1:46 PM, Hyzer, Chris <> wrote:

Can you just select from the “with” query (as subquery), know what I mean? 

 

Thanks

Chris

 

From: [mailto:] On Behalf Of Jeffrey Crawford
Sent: Monday, March 14, 2016 3:12 PM
To: Gouper Users List <>
Subject: [grouper-users] CTE Queries and loader groups.

 

I think there some sort of safety check when trying to run queries against a SQL type server.

CTE queries start with the keyword 'WITH' and the loader seems to check that a query starts with 'SELECT' Although I could re-write the query CTE queries can really make SQL much nicer and easier to read.

Could a future version allow CTE queries?

Thanks


Jeffre

y C.

 

 

Both pilots and IT professionals require training and currency before charging into clouds!

---------------------------------------

 




Archive powered by MHonArc 2.6.16.

Top of Page