Dynamic Record List AFTER Searching Only

jlig
Posts: 35
Joined: 2010-07-09 16:17

Dynamic Record List AFTER Searching Only

Post by jlig » 2010-07-09 16:31

Does anyone know how to force my Nextensio List to just initially display the Search boxes only, and not bring up any records at all?
- I'm using the List Page and Filter Boxes as a "Global Search" of the database
- I only want the page to load with everything except the actual data
- Then when I type something into a filter box, I want the query to run & display the results. (Like a google search page)

My list page works as-is, set to display only 10 records, with the Filter boxes set to display by default.. but since the query is running to display the recordset, there is a delay before the page loads.. I would like to stop the initial query from running/displaying and only run "after" I have typed in a value, and hit the "Filter" button.

User avatar
Fred
Site Admin
Posts: 491
Joined: 2010-02-15 12:10
Location: Armagh, Northern Ireland
Contact:

Re: Dynamic Record List AFTER Searching Only

Post by Fred » 2010-07-11 15:50

Try to edit the recordset from the normal nextentio record set...

SELECT name.log_file, choice.ch_name AS log_use, banners.log_id
FROM log_file LEFT JOIN choice ON banners.log_use = choice.ch_id
WHERE NXTFilter
ORDER BY NXTSort

To

SELECT name.log_file, choice.ch_name AS log_use, banners.log_id
FROM log_file LEFT JOIN choice ON banners.log_use = choice.ch_id
WHERE name.log_file = '' OR NXTFilter
ORDER BY NXTSort

I never tried it but I would think the resulting recordset would be any record with a `name.log_file` = nothing OR the NXTFilter.

Obviously you need to initially filter on a field that is guaranteed to not be empty

jlig
Posts: 35
Joined: 2010-07-09 16:17

Re: Dynamic Record List AFTER Searching Only

Post by jlig » 2011-01-20 22:54

Fred, Thanks for the reply..

Also posted on: http://forums.adobe.com/thread/676954?tstart=0

Will give your tip a try and get back..

User avatar
Fred
Site Admin
Posts: 491
Joined: 2010-02-15 12:10
Location: Armagh, Northern Ireland
Contact:

Re: Dynamic Record List AFTER Searching Only

Post by Fred » 2011-01-21 09:46

Had another though on this last night.
Make use of Jquery and simply hide the list initially.
Then when a search is done you can show the results.

Post Reply