NAB - Grid global search - on hidden colums

[ThierryC]

Hi Sean..

problem is solved..

i only see now what you mean ... When taking the screenshot, i only now notice that option is there to inlude the hidden columns in the search config..

wasn't aware of that ..i have always overlooked it...


This is the perfect solution !! & sorry for the question


great thx for the assistance



Image 19.png

[sean.lanktree]

Hi Thierry, can you confirm your search type: Starts With, Contains, or Exact. Also, can you provide the full version number of Valence?

[ThierryC]

Hi Sean, i think i'm doing that way .. but seems not be working in my case

i've taken some screenshots, maybe there is some misunderstanding from my side.

Image 003.pngImage 001.pngImage 002.png

[sean.lanktree]

Hi Thierry -

I just tested the hidden columns and searching on our system and did get it to work. Be sure to have the column selected AND the hidden feature selected.

This is a bit misleading as you should only need to check the hidden feature....we will add this to our internal list.

[ThierryC]

Hi Sean... that also what i had tried before sending my Post

i indeed also thought it could work by setting those cols hidden, . but i doesn't

But i have mixed opinion on this

on the one hand opening the search on hidden could confuse users that they see rows that at first sight do not match their search criteria
but in my current case, where the info from the 'hidden' columns are grouped into 1 single 'visible' grid column it would have been handy..

i also tried to group the columns in the SQL datasource, but especially when, as in my example, grouping 5 columns in there, it is much more cumbersome to do some testing or to add some formatting...

Thierry

[sean.lanktree]

Try including the columns that you use in the custom formatting but set them to hidden. Then check "Include Hidden Columns" under the Search section.

[ThierryC]

Hi.. i have an app in which for the sake of visibility i group 5 fields together in 1 column

(i used the custom formatting to put multiple values in 1 grid column)


one side effect though is that the global search is apparently only looking in columns on the grid that are visible.. which is some way, makes real sense

just would like to know if there is a way to circumvent this..
part of the code is below,

retval = '';
if (rec.get('LGKEY1') != '') {
retval += rec.get('LGKEY1');
}

if (rec.get('LGKEY2') != '') {
if (retval !='') {
retval+='</br>';
}
retval += rec.get('LGKEY2');
}
if (rec.get('LGKEY3') != '') {
if (retval !='') {
retval+='</br>';
}
retval += rec.get('LGKEY3');
}