hi,i got a simple enum type in a mysql table.
in phpmaker, i add the user values and labels for each ones.
i activated the quick search on that field.when i search for a label, the results does not show the ones concerned !but when i search for a value, then it works !
Problem : the user does not have to know the values behind labels !Best regards
That is the limitation of Enum field type for Quick Search. You can only search based on its value, and not by its label.
However, you should include this field in Search Panel as Extended Search field if you want your end-users search based on its label.
thank you for the advice.in fact, i desable extended search because when you have 5 fields, there are now displayed “inline” but each search field under each . So the page became bigger and the list data is going to the bottom (need to scroll down).
it would be good if quick searc panel AND (i said AND) extended search panel can be by default “hidden unfoding” but it is not. Once you activate a extended field, the panel is always opened…Have a good day.
You may actually write jQuery code and put it in Startup Script of the current page, in order to collapse the Search Panel when the page is loaded for the first time.
hi,to complete my original message, i just discover that lookup table label (display-field) is not “quick-searchable” either !
it is a shame because both radio label and lookup table labels are present on the html page. so i will use CTRL+F web page browser feature to search about them…Ok, i activate the SORT feature which do a part of the search job too.Thank you.
amiens80 wrote:
you have 5 fields, there are now displayed “inline” but each search field under each
You may set the setting “Fields per row (Extended)”, see the topic Table Setup in the help file.