sort by date range

Like (0) Share

Report

Posted on 9 Apr 2021 05:34:30 by Matt383

395

Hi, Just added a sort icon into the gallery to filter by recent date. The Onselect of the icon has UpdateContext({SortDescending1:true})

and in the items of the gallery i currently have,

Filter(KBLCollection,StartsWith(Title,Srchbox.Text) && (Dropdown1.Selected.Value = "all" || If( Dropdown1.Selected.Value="Submitted",Submitted,!Submitted)))

I thought i could put in something like this,

Filter(KBLCollection,StartsWith(Title,Srchbox.Text) && (Dropdown1.Selected.Value = "all" || If( Dropdown1.Selected.Value="Submitted",Submitted,!Submitted))),"Date" , If(SortDescending1, Descending, Ascending))

but no luck, can you please assist

Categories:

General Questions

All responses (7)

Answers (1)

Matt383 395 on 09 Apr 2021 at 21:57:13

Like (0)

Report

Re: sort by date range

Thanks Warren, thats the one. All sorted now. Cheers
Verified answer

WarrenBelz 146,508 Most Valuable Professional on 09 Apr 2021 at 21:46:07

Like (1)

Report

Re: sort by date range

@Matt383 ,

Also forgot to take the quotes off "Date" - now fixed.
Matt383 395 on 09 Apr 2021 at 21:42:49

Like (0)

Report

Re: sort by date range

Thanks Warren, Gallery showing up now, no errors. however when i select the sort icon, nothing changes. The date fields in the gallery remain randomly throughout. I checked the onselect of the icon
UpdateContext({SortDescending1:true})
and the onselect of the gallery is
Sort( Filter( KBLCollection, StartsWith( Title, Srchbox.Text ) && ( Dropdown1.Selected.Value = "all" || If( Dropdown1.Selected.Value="Submitted", Submitted, !Submitted ))), "Date", If(SortDescending1, Descending, Ascending ))
Also when i select the sort icon, the blue box stays there (image below)
WarrenBelz 146,508 Most Valuable Professional on 09 Apr 2021 at 07:35:24

Like (0)

Report
Re: sort by date range

Hi @Matt383 ,

Dangers of free-typing - you left out Sort

Sort( Filter( KBLCollection, StartsWith( Title, Srchbox.Text ) && ( Dropdown1.Selected.Value = "all" || If( Dropdown1.Selected.Value="Submitted", Submitted, !Submitted ) ) ), Date, If( SortDescending1, Descending, Ascending ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Matt383 395 on 09 Apr 2021 at 06:19:00

Like (0)

Report

Re: sort by date range

before and after
Matt383 395 on 09 Apr 2021 at 06:15:00

Like (0)

Report

Re: sort by date range

Hi Warren, thanks for your reply. It no longer brings any errors, however now nothing shows in the gallery
WarrenBelz 146,508 Most Valuable Professional on 09 Apr 2021 at 06:05:27

Like (0)

Report
Re: sort by date range

Hi @Matt383 ,

You had an extra closing bracket in there

Filter( KBLCollection, StartsWith( Title, Srchbox.Text ) && ( Dropdown1.Selected.Value = "all" || If( Dropdown1.Selected.Value="Submitted", Submitted, !Submitted ) ), "Date", If( SortDescending1, Descending, Ascending ) )

You could also toggle the sort with

UpdateContext({SortDescending1:!SortDescending1})

I am assuming here Submitted is a Boolean (yes/no) field.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.