Hi all,
I’ve got a query that returns a list of pages. Some of the pages have names that are in title case, others are lower case. The order of pages has the capital letter pages first A-Z, THEN the lower case pages A-Z.
How do I make the order ignore the case of the page name?
I think that string.lower(s) can be a solution:
Example:
${query[[from index.tag "page"
where string.startsWith(name, "Inbox")
select {
name = name,
order = string.lower(name)
}
order by string.lower(name)
limit 50
]]}
Yeah that makes sense, ta!