5.97: lookup custom query HTML not displayed in lookup, but base field
Posted: 2021-08-26 05:21
Hi,
I am saving some HTML in a field (rich text html in that specific table) to use formating etc.
In my custom sql for the lookup in another table I am pulling the ID and the HTML. The custom SQL is quite simple:
The values returned (in phpmyadmin) look like this:
As we can see: The data is nicely stiched together.
Not I want to show the field Loading (which exists in my custom lookup) in the lookup - which works, but when the lookup is closed, the value from the field of the child table is shown - instead of the one with the matching ID from the custom query (with the same column name)
In the current 5.97 version of AG the lookup fails to show the html, it looks like this:
Setting in AG:
A bug - or am I doing something wrong. I am pretty sure, it worked before 5.97
Olaf
I am saving some HTML in a field (rich text html in that specific table) to use formating etc.
In my custom sql for the lookup in another table I am pulling the ID and the HTML. The custom SQL is quite simple:
Code: Select all
SELECT el.ID, Concat(el.loadcode, ': ', el.treepath) AS Loading FROM el ORDER BY el.treepath, loadcodeCode: Select all
ID_containerladung Loading
316 101: <a href="/e_c_view.php?SelectedID=3222">P77777</a> > <a href="/e_l_view.php?SelectedID=316">101</a>
317 102: <a href="/e_c_view.php?SelectedID=3222">P77777</a> > <a href="/e_l_view.php?SelectedID=316">101</a> > <a href="/e_l_view.php?SelectedID=317">102</a>
318 103: <a href="/e_c_view.php?SelectedID=3222">P77777</a> > <a href="/e_l_view.php?SelectedID=316">101</a> > <a href="/e_l_view.php?SelectedID=317">102</a> > <a href="/e_l_view.php?SelectedID=318">103</a>Not I want to show the field Loading (which exists in my custom lookup) in the lookup - which works, but when the lookup is closed, the value from the field of the child table is shown - instead of the one with the matching ID from the custom query (with the same column name)
In the current 5.97 version of AG the lookup fails to show the html, it looks like this:
- lookup_data.png (21.52 KiB) Viewed 1900 times
- lookup_settings.png (31.9 KiB) Viewed 1900 times
Olaf