I have a long list of users and I want the page to display only the users whose name begins with "L" for example -- when I click on a text link (I'll have a list of text links A thur Z so that someone can search for each letter).
The default view of the page will be ALL the users, paginated in groups of 10.
At the top of the page will be the letters A, B, C, etc that someone could click on and the view will change to just those users.

Figured it out. Set the database to filter user name with Starts With, Form Variable and Letter (the name of the form field). Create a null link for each letter, A, B, C, etc. Add a behavior to Control Bindings, send the value of the letter to the database. This may not be a perfect solution, but it seems to work.

Spoke too soon. Solution doesn't work all the time.

Hi Joe,
Unfortunately there is no way to directly filter the results using a button/link and behaviors.
What i can recommend is - create a hidden field and use its value as a filter for your data source. Write some custom code that changes its value, when a letter is clicked.
OR use a dropdown menu with the letters inside to filter the results.

I got this far: hudsonchildrensbookfestival.com/DEV/testdata.php

But the only problem is if someone hits Next page, the sorting only takes place on the names that appear on the next batch. For example, if you page forward to where no names with A begin and then press the A link, no results are shown. Somehow I need to refresh the database before each time a letter link is pressed?

I think I might have it working. Not sure how I did it though.

ugh. no still have the issue if you page to any of the pages, the A link doesn't bring up sorting -- it doesn't see the entire database, is sees just what is shown.