How to add unfiltered content option on a filtered Repeater?

Ask the community
,
1

Hello,

I filtered a Repeater using a database over other database as explained on this tutorial:

Everything works nicely until I stumbled on a problem to display all products unfiltered.
Now I have 2 questions:

  1. Since the displayed menus are based on database, how to add an option in the table named “ALL” that display all items unfiltered?

1328×451 191 KB

  1. Sort of displayed item is based on database sorting set. I want to sort an option named: “ALL” on the top of the list, followed by “INDONESIA” on the second, and then the rest sort by alphabetic.
    How can I do a manual sorting?

Thank you for your kind support.