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, loadcode
Code: 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: Setting in AG: A bug - or am I doing something wrong. I am pretty sure, it worked before 5.97
Olaf