Announcement

Collapse
No announcement yet.

Saved Queries

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Saved Queries

    Saved queries usually show in alphabetical order. Lately there have been time where they are out of order. Does anyone know of a way to control the order? I looked at SAVED_QUERY_SORT_ORDER, but that didn't seem to help. Any ideas are appreciated and welcome.

    Thank you

  • #2
    Re: Saved Queries

    Maybe you have leading spaces or other unprintable characters in your saved_query_gid affecting the sort order. A simple way to check would be to perform a CSV export of the table and view it in an editor to see if that is the case.

    -Alan

    Comment


    • #3
      Re: Saved Queries

      In additon to Alan's point, SAVED_QUERY_SORT_ORDER is storing data for sorting order of records in Result Screens.
      Last edited by josephliang; April 30, 2010, 15:06.
      --
      Joseph Liang
      MavenWire APAC
      http://www.mavenwire.com/

      Comment


      • #4
        Re: Saved Queries

        Hi,

        They are sorted by DOMAIN_NAME and/or QUERY_NAME name first. The QUERY_NAME will very depending on where you create the Saved query from (from within an agent, or power_data).

        Hope this helps.
        James Foran
        Toll Global Information Services
        http://www.tollgroup.com

        Comment


        • #5
          Re: Saved Queries

          Does sorting work the same way on the shipment search screen?

          Comment


          • #6
            Re: Saved Queries

            Yes, it should.
            Cheers,
            Murthy

            Comment

            Working...
            X