Searchable Filtered List (PLEASE HELP)

[BCJack]

I need to have a text box with a look-up or a drop-down based off a field that pulls an ID from a table to filter a UX list control. This filter will happen immediately when the user loads the page or when they select an option form the drop-down or text box. That list must then have a search box (preferably a keyword search, AKA onmibox) that further filters the records. This search will probably be triggered with a button, but the clear on this search field will be done from an in-control button.

In the future the drop-down box will have a default value of the location that is associated with the user who logged in, in case that helps you help me.

I have tried everything I can think of, but I must admit that there was quite a bit of combinations that I had to try so I may have missed that few things.

[Davidk]

Re: Searchable Filtered List (PLEASE HELP)

Hey Jack,

I've read the post but I don't really understand it. Could you try explaining it again? Maybe include a screenshot of the UX with notes about what you're trying to do.

[BCJack]

Re: Searchable Filtered List (PLEASE HELP)

Absolutely. Please take a look at the attached picture and then the following explanation should make sense.

When they pull up that screen, I want it to automatically tell what "Branch" they are an employee of and filter the list underneath appropriately. This first part will be done somehow by linking an employees table to the registerdusers table, and I'll figure that out later. The second part, the filter, is what I am asking about. That drop-down (or lookup) will have a list of locations that it pulls from the Branches table. Now, the other filter would come from an optional (but almost-always used) search box, the one that currently has "jack" in it. Ideally, that box would be a a keyword search that looks for the inputted value in every field except Branch, that way a contact can be found by using a company name, phone number, last name, etc...

This should be easy, but I just cant figure it out.

2015-01-02 14_05_51-Alpha Anywhere.png

[Davidk]

Re: Searchable Filtered List (PLEASE HELP)

The way this is accomplished depends, so some degree, on how many records are in your List... and... if this is a mobile app.

You don't want to load thousands of records in your list if you're just going to go filter that list when rendered.

In your List Properties, set up an Argument that points to a session variable you've created when you log in. Then you create a filter in the List Properties that uses that argument.

Now your list is rendered with a filter already applied. The only records in the list are those for the user.

For the searches I wasn't sure if you want to search on Branches and text. Here's how to search for text.

On your search button put something like this...

var searchValue = {dialog.Object}.getValue('txtSearch');
var lObj = {dialog.object}.getControl('list1');
lObj.filterListClientSide(searchValue);

This code gets the value of your txtSearch textbox control, then gets the List control Object, and then performs a .filterListClientSide filter on the list.

This method searches all the columns in your List... even columns that are not displayed.

To have more control over which columns get filtered have a look at the list object .setFilter method.

Hope that helps a bit.

[BCJack]

Re: Searchable Filtered List (PLEASE HELP)

It does help a lot. Thanks so much.

To clarify on the Branches, that will be the alternative to the session variable. For example, the session variable notices that I am listed as an OKC employee so it renders the list pre-filtered for only OKC Branches when I load the page, but upon me clicking the drop-down and selecting "Tulsa", it would then instead filter the list for all Tulsa Branches. not sure if this manual Branch filter should be executed from the text's search button or from an onSelect event within the drop-down itself. I am thinking that it should be on the onSelect event and on the text button, and both of them uses both the text box search and the drop-down as the filter. Should probably use the session variable as the default value in the dropdown box to simplify things, but doing this is a whole different story because I am new to coding.

[Davidk]

Re: Searchable Filtered List (PLEASE HELP)

How many rows, in total, might be in the list... if the list were not filtered?

[BCJack]

Re: Searchable Filtered List (PLEASE HELP)

currently about 500, but in the future, thousands to tens of thousands. We are talking about a complete contact list for a construction company with multiple locations.

[Davidk]

Re: Searchable Filtered List (PLEASE HELP)

With that number of row I would use an Ajax Callback, selecting the rows needed, and then loading the list through code.

[BCJack]

Re: Searchable Filtered List (PLEASE HELP)

Yeah, I was just wondering that as well. I was initially making this application with the mindset of minimizing the load on the server any way possible, but after watching load times on mobile devices grow and grow, I am starting to question that.

Thank you again for all of your help. I especially appreciate the insight that is going to save me headaches in the future.