0

How to sort by descending

Good morning everybody
I need to sort table descending or assending. I try to use Order By, but I can’t choose the direction of order because DESC and ASC don’t seem exist.

select Projets order by DESC or ASC ‘Tâches“

Some one know how to do it ?

2 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    Maybe with rsort() or sort() ?

    Haven“t try though.

    • Ninox developper
    • Jacques_TUR
    • 3 yrs ago
    • Reported - view

    sort() and rsort() create nid odered by Id. 

    sort(select Projets) = nid([“K1”,“K2”,“K3”,“K4”,“K5”,“K6”,“K7”,“K8”,“K9”,“K10”,“K11”,“K12”,“K13”,“K14”,“K15”,“K16”,“K17”,“K18”])

     

    Or return array of string

    sort(select Projets.“Tâches”) = string([“BaseDeDonnées”,“Cascade de défense”,“Démo filmée”,“Fiche de synthèse IR”,“Fiche SNA/TPV”,“Gestion”,“Gestion des Pauses TPV2”,“Gouvernance STF”,“Interviews”,“Logiciel Montage Vidéo”,“Modélisation IR”,“Organisation”,“Présentation IR”,“Présentations animées”,“Site Internet”,“Support de formation”,“Vidéo IR”,“zAchats”])

Login to reply

Content aside

  • 3 yrs agoLast active
  • 2Replies
  • 647Views