Issue with "List Reference ID" navsearch in jqadm list view

[Paulus-Ragnarr]

Hey Aimeos,

I’ve set up a new manager called "Workshop" and created its lists and list type managers, using reference from https://github.com/aimeos/aimeos-core/t ... ger/Lists.. Everything works fine when I use createListItem() and addListItem() to add list items to the database. However, when I created a custom jqadm list view, while using the navsearch specifically searching for List Reference ID it doesn't seem to work. It returns an error in the log panel.

Code: Select all

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'mworli.siteid' in 'where clause':

I’ve also tested the Product list view navsearch, and the issue seems to be the same on my end.

Any ideas?

Code: Select all

PHP version: 8.2
Aimeos version: Aimeos Headless 2024.10.
Environment: Mac

[aimeos]

We are moving towards a document oriented structure so it works with all kind of storages. Therefore, searching for lists related values like "product.lists.refid" isn't supported any more. Instead, you have to use the "product:has" search function but that doesn't work in the navbar search of the list views (doesn't make much sense from an UX point of view because editors have to know the ID if the referenced item).

[Paulus-Ragnarr]

Hello, thanks for the quick reply!

In our case, we have only one domain linked to the "Workshop," which is the "Workshop services" domain. For this, we’ve fetched the IDs from the Workshop services and used them as values in a dropdown selection for our search. Since it’s an M-to-N relationship, we needed to use lists to store this data. We now want to search for Workshop items based on the selected Workshop services.

Is there another way we can filter the Workshop items using the List Referenced ID in the listing view?

[aimeos]

You can add a search attribute "workshop:serviceid" your your manager that joins the list table like in the Lists manager decorator (code can be simplified in you case):
https://github.com/aimeos/aimeos-core/b ... p#L97-L121