hi,
i use phpmaker 2020.14.
i have a basic table with a lookupTable field.
i checked the search field option on quick search colum.
i activated the quicksearch option in the table setting.
i generated the project and use F5 to refresh the browser.
but, when i test the quick search, the result are empty. the query did not search on the label field of the lookupTable field !
what did i miss ?
do you have clue or tips to solve the problem ?
By advance, thank you for your time.
Best regards.
i noticed when i quicksearch the id instead the label, then it runs !
i’m confused because in another view with another different looktable field, the search runs fine (searching with label).
when it runs, i use a lookupTable field with full data to fill .
when it bugs, i use a lookupTable field with a criteria lookup table filter (sql statement). in Edit,add mode; the list is fine, not problem there.
So it looks that the quickearch process is failing on the filter…
i will replace my table with filter by a sql view to avoid the filter feature, and test…
i’ll be back !
i thought the sort/search option there was a feature aimed to the inside combo list UI component (by example if you have a list of 500 items you want to search/sort before selecting a item in it) , not for the quick search feature of the main list view !
So, i check the option and it runs now !
Thank you a lot for this light !
Have a great day, mine begin well due to your help !