Empty string sort

Khan aqib

I have a last name which is empty sometimes how can i sort last name i want empty last name in end but it will comes first when I am sorting please help

Inayet Hadi

Hey , recording a loom and/or sharing your function stack code will help others to help you. 

Fyi, Xano has weekly office hours depending upon your membership, plus Xano also provides a program called PRO headed by   which has been phenomenal in my ability to move forward and when I get stuck I worry no more because I can attend the next office hours with Ray, and most of the time get solutions, but even better is learning how to do things better with broad guidance so I can confidently go and explore knowing that a great team is behind me. I truly believe that without the PRO group I would probably be at 11% or maybe 12% of where I am now. 

Khan aqib

Do you have any solution for that question if yes please help me

Michael Udinski

 - are they empty strings or null?

Khan aqib

Empty string

Khan aqib

I follow the video step but it not work on empty string

Michael Udinski

 Which video are you referring to?

Khan aqib

 sort timestamp with null values

Michael Udinski

 got it. The coalesce filter in that video is from postgresql that gives null values an alternate value, which is why it wouldn't work with an empty text string

Khan aqib

 yes

Khan aqib

is there any other solution for this issue

Michael Udinski

 here's a simple solution you can implement to accomplish this:


Khan aqib

 thank you so much 😊