Grouper Users - Open Discussion List

["Crawford, Jeffrey" <>]

Sorry for the delayed response, This particular one is Oracle, but we use a lot of MS SQL and MySQL as well. There is no rush on this by the way.

 

Thanks

Jeffrey

 

From: "Hyzer, Chris" <>
Date: Friday, September 28, 2018 at 1:08 PM
To: "Crawford, Jeffrey" <>, " Mailing List" <>
Cc: "Zhang, Xiaoling" <>
Subject: RE: Grouper Loader SQL query size limit

 

Sure.  What database type are they using?

 

From: Crawford, Jeffrey <>
Sent: Friday, September 28, 2018 12:40 PM
To: Hyzer, Chris <>; Mailing List <>
Cc: Zhang, Xiaoling <>
Subject: Re: Grouper Loader SQL query size limit

 

Thanks Chris,

 

Even though in this particular instance we are able to get the department who runs the DB to create a view for us. There are other dept, that may not be as open to doing custom work like that. We would therefore like to make a feature request if we can increase the limit of the DB query field for loader jobs. Not sure what number would be good, but let’s just say 5000 chars or have it be a CLOB/TEXT/BLOB or something like that? We have to come up with some creative queries sometimes.

 

Thanks

Jeffrey Crawford.

 

From: "Hyzer, Chris" <>
Date: Sunday, September 23, 2018 at 6:52 PM
To: "Crawford, Jeffrey" <>, "" <>
Cc: "Zhang, Xiaoling" <>
Subject: RE: Grouper Loader SQL query size limit

 

Its possible, and probable if you just proved it, but yes you should use a view 😊

 

From: <> On Behalf Of Crawford, Jeffrey
Sent: Friday, September 21, 2018 5:51 PM
To: Mailing List <>
Cc: Zhang, Xiaoling <>
Subject: [grouper-users] Grouper Loader SQL query size limit

 

Hi Grouper Team,

 

We seem to be hitting an upper character limit when trying to add a SQL loader query on our older Grouper install (2.1). Was there any expansion in the number of characters allowed in the grouper query field in the later versions of Grouper? Although a view might help we are stuck in the short term.

 

Thanks

Jeffrey Crawford