Lookup Advanced: Search in Lookup fails

Please report bugs and any annoyances here. Kindly include all possible details: steps to reproduce, expected result, actual result, screenshots, ... etc.
Post Reply
User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts: 1156
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Lookup Advanced: Search in Lookup fails

Post by onoehring » 2019-06-04 15:30

Hi,

I created an advanced look up (similar see viewtopic.php?f=2&t=3034&p=10078#p10078 ).
I notice, that when I try to search some contents - it does actually NOT work on my field.
The "clock" is rotating, but my list is not being adjusted (as one would expect and as would be useful is the list is long)

11-1-3 is the old value, I am typing 11-2 in the "search" field but all instead of only one (11-2-1 (1)) stay.
ec_search_fails.png
ec_search_fails.png (13.79 KiB) Viewed 1526 times
Olaf


User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: Lookup Advanced: Search in Lookup fails

Post by jsetzer » 2019-06-05 07:43

Hallo Olaf,

this should definately work.

Can you please open the developer tools in your browser (usually F12 key) and, on the console-tab, check if there are javascript errors. If there are, please post them.

Maybe the problem is somewhere else and the search-box behaviour is only a "Folgefehler" (aftereffect) :shock:

Regards,
Jan
Kind regards,
<js />

My AppGini Blog:
https://appgini.bizzworxx.de/blog

You can help us helping you:
Please always put code fragments inside [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts: 1156
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Re: Lookup Advanced: Search in Lookup fails

Post by onoehring » 2019-06-05 07:47

Hi Jan,

pbötcher posted another version of SQL string for the query - and actually it does work now.
I have no idea, why my original SQL worked for the drop down, but not for the Ajax search.

Solution here: viewtopic.php?f=2&t=3034&p=10105#p10105

Olaf

Post Reply