Grouper Users - Open Discussion List

[Jeffrey Crawford <>]

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!

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