open browse empty

[marc]

Hello,

How can I make a browse form not show any records when it is opened?
Records should only be displayed after entering a search string (at least three characters long) and starting the search action.

[admin]

marc,

nuBuilder only works the opposite way.


Steven

[toms]

Hi,

You can use Hash Cookies in your Browse SQL like this:

Code: Select all

SELECT * FROM YOUR_TABLE WHERE LENGTH('#SEARCH_FIELD#' ) > 2 AND LOCATE('#','#SEARCH_FIELD#') = 0

Explanation: The Hash Cookie is unknown (empty value) when the form is initially opened. Therefore the SQL returns 0 rows ( => empty Browse Table)

And then you need to add some Custom Code -> JS:

Code: Select all

if (nuFormType() == 'browse') {
   $('#nuSearchField').on('change keydown paste input propertychange click keyup blur', function() {
       nuSetProperty('SEARCH_FIELD', this.value );   
  })
}

Explanation: Whenever the text in the Search Field is changed, the Hash Cookie is assigned the value of the search field.
The next time a Search Action is peformed, the Hash Cookie is not empty anymore and the query outputs records, given that the length of the search string is at least 2 characters.

[marc]

toms,

Thank you so much - works as expected!

[admin]

.