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: Jeffrey Crawford <>
  • To: "Hyzer, Chris" <>
  • Cc: Gouper Users List <>
  • Subject: Re: [grouper-users] CTE Queries and loader groups.
  • Date: Wed, 16 Mar 2016 13:13:39 -0700

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