Forum Discussion

TyroneGrey's avatar
Qrew Member
3 years ago

Formula Query Sorting

Does slist and option=sortorder work within formula queries?

In my formula query my items return the correct values but the sort does not work. Also does num-# work with the amount of records you want returned.

var text Query ="{27.EX." & [Order Type] & "} &slist=3&options=sortorder-D";

Tyrone Grey

6 Replies

  • Hi Tyrone;
    I don't think this would work.
    In your "Query" you don't have only query you have also sorting and sorting option
    GetRecords formula doesn't accept sorting parameters yet; if I know it correctly

    For the number of records you can use "Count" function. I wanted to see number of records so I have created a numeric formula field in my application to capture that.
    it is something like this:
    Count(ToText(GetFieldValues(GetRecords($myquery, "xxxxxxx"), 3)), ";")+1

    I hope this will help.

    Razi D.
    Desta Tech LLC
  • Sorting is not currently supported.  One assumes they are watching how Performance is going and being cautious before allowing more load on the system.

    Mark Shnier (YQC)
    • BlakeTaylor1's avatar
      Qrew Member

      Has sorting been an implimented mechanic?

      Blake Taylor
      • MarkShnier__You's avatar
        Icon for Qrew Legend rankQrew Legend

        .... no change on sorting as far as I'm aware.

        Mark Shnier (Your Quickbase Coach)