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.
Dynamic Record List AFTER Searching Only
Re: Dynamic Record List AFTER Searching Only
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
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
Re: Dynamic Record List AFTER Searching Only
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..
Also posted on: http://forums.adobe.com/thread/676954?tstart=0
Will give your tip a try and get back..
Re: Dynamic Record List AFTER Searching Only
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.
Make use of Jquery and simply hide the list initially.
Then when a search is done you can show the results.