Drop Down in Search part of List Control?

[Keith Hubert]

Hi Guys,

Trying to build a List Control with a Search part.

Would like the Search fields to be with dropdown data.

Also the data is to be filtered so that, data in the search dropdown, must match the records that could be shown in the list because of list filter criteria.

eg list to show records with Invoice_Paid= True.

Please advise Documentation or even better, a Video.

TIA

[iRadiate]

Re: Drop Down in Search part of List Control?

Keith, I put search controls in the UX then use the action javascript 'Filter Records in a List Control'
Looks something like this:

List Search.jpg

[Keith Hubert]

Re: Drop Down in Search part of List Control?

Hi Stephen,

Many thanks for showing what can be done, is it possible to show how to do it. Is there a video you could point me to?

We had done this before using cascading dropdown search box with a grid, each dropdown was a child of the previous dropdown. We are trying to upgrade our site to SQL and use UX in place of all the grids.

[iRadiate]

Re: Drop Down in Search part of List Control?

Not sure about a video ... I'm sure there is one somewhere, suggest searching the Alpha video library.

It is simple to setup in a UX. Just add your List control (I'm assuming you know how to load this based on a SQL query).
There are basically two types of search: Quick Search for multiple field searches and Detail Search for specific single field searches.

For a Quick Search, add a textbox field to the UX and a button for Search.
On the button onClick event, I place javascript text to call some action javascript. Something like {dialog.object}.runAction('Quick Search Repairs');
Define the runAction using 'Filter Records In A List Control'
In the properties, you can define this as a Keyword search and select all the fields in the list you wish to search. Looks like this:
Quick Search.jpg

For a Detail Search, put whatever controls you need to search individual fields in the list (can be character, dropdowns, booleans, dates, etc.) and a button for Search.
The onClick of the button is again defined with action javascript 'Filter Records In A List Control'
This time, do not select keyword search but define the search fields individually. Looks like this:
Detail Search.jpg

For clearing the search results, in the button to clear the filter place the following in the onclick event.
{dialog.object}.getControl('LISTNAME').clearSearchList({searchMode : 'auto'});

Hope this gets you started ...

[iRadiate]

Re: Drop Down in Search part of List Control?

I should add that in the List properties, for the Quick Search, you may also have to check 'Has Search Part'.
ListProperty.jpg

And in the SearchPart, check the fields you want to be searched.
SearchPart.jpg

I've forgotten now why this was done in the list and on the UX.

[Keith Hubert]

Re: Drop Down in Search part of List Control?

Hi Stephen,

These all look very interesting. Is it possible to keep the final filtered list hidden until the search criteria has been entered and the search button clicked?

[iRadiate]

Re: Drop Down in Search part of List Control?

Not sure if you mean hide the actual list, but the results of the filtered list won't be displayed until you click the search button.

Here's an example of my application ... https://www.screencast.com/t/vtt2o3lzFObP

[Jay Talbott]

Re: Drop Down in Search part of List Control?

Keith,
Is this what you are asking about?
Screen Shot 2017-08-09 at 8.55.20 AM.png

Jay