Thanks! I tried your first option on concatenating 2 different queries.
On Jan 22, 12:40 am, Ana Nelson <[email protected]> wrote: > Hi, Charlotte, > > Can you run two separate queries, and then add the results together? > That way the first query can give you just those with dates, sorted by > the date in ascending order. The second query can be for results with > NULL date. If you add the two collections together, you will get an > array. If this works, it's probably the simplest way to do it. > > Otherwise, you might need to sort on a function like COALESCE, which > will turn the NULL into a value that's after the highest value in your > database, for example: > Task.find_by_sql("Select * from tasks order by COALESCE(completed_at, > '2020-01-01')") > > COALESCE is specific to MySQL so you need to check out the > documentation for whatever database you are using. > > -Ana > > On Jan 21, 3:01 pm, Charlotte <[email protected]> wrote: > > > I have a query, that sorts the date in an ascending order. > > The date is optional, so there are NULL values. > > The NULL values are the ones on the top, rather than the results > > containing dates. > > How can I show the results in an ascending order, and the NULL values > > will be on the end of the list? > > > Please do help, since I'm quite new in this. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DataMapper" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/datamapper?hl=en -~----------~----~----~----~------~----~------~--~---
