Dynamic Record List AFTER Searching Only

jlig
Posts: 34
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: 486
Joined: 2010-02-15 12:10
Location: Armagh, Northern Ireland
Contact:
Ireland

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
Fred
eXel content Management Systems (XMS Systems)

Please click the "Accept the Answer" icon if you are happy with the response.

jlig
Posts: 34
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: 486
Joined: 2010-02-15 12:10
Location: Armagh, Northern Ireland
Contact:
Ireland

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.
Fred
eXel content Management Systems (XMS Systems)

Please click the "Accept the Answer" icon if you are happy with the response.

Post Reply