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
-
Maybe with rsort() or sort() ?
Haven“t try though.
-
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”])
Content aside
- 4 yrs agoLast active
- 2Replies
- 660Views