Comment 12 for bug 1796945

tji@sitka.bclibraries.ca (tji) wrote :

I encountered an issue when adding a displayed or filter field from a linked table, I got the missing FROM clause error.

Example 1: starting from In-house Use, right join Item to list items with total circ count and in-house use count. The cloned template works. But I got the error when cloning it again from the cloned template to add Active Date from Item table. I got the same error when adding the field during the initial cloning from the XUL template, too.

Example 2: template start from Item to list items by circ library. I got the error when I added a filter on item's shelving location (on location id in shelving location table (use the default inner join)).

I also tested creating the templates from scratch on Webby, then clone to add the fields. No error.