Forum Discussion

TyroneGrey's avatar
TyroneGrey
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
------------------------------
formula queries

6 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    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)
    mark.shnier@gmail.com
    ------------------------------
    • BlakeTaylor1's avatar
      BlakeTaylor1
      Qrew Member
      5 months ago

      Has sorting been an implimented mechanic?



      ------------------------------
      Blake Taylor
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 months ago

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



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------
  • RaziD_'s avatar
    RaziD_
    Qrew Cadet
    3 years ago
    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
    razi@destatechs.com
    ------------------------------