Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-2324

order by in loader queries causes an issue

    XMLWordPrintable

Details

    Description

      Sent: Wednesday, September 04, 2019 1:11 PM
      To: grouper-users@internet2.edu
      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!

      Zach Black

      Manager Identity & Access Management

      University of Nebraska ITS | Cybersecurity & Identity

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist