AppGini Community Forums

I believe there is a bug in the SPM plugin when managing simple SPM filter searches for lookup fields.

I have a Contacts table with a Lookup field (Associated Mentor) whose ID values are drawn from a MySQL View that references the mentor's ID, and shows their Name in the field itself in Table/Detail view when displayed.

When adding/editing a record, the lookup dropdown displays the list of mentors concatenated with the number of mentorees they are currently managing. All works fine in Table/Detail/Advanced search if I select that field and do a "Like" against the mentor's surname, the associated records are found, but if I setup a SPM simple filter for that table and simply select a dropdown value for that field of "John Doe (Mentorees: 1)" which should just do a simple ID comparison for all records matching the underlying ID, no records are displayed.

Feedback appreciated and/or timescale or workaround to fix.

Hello and sorry for the long delay. To make sure I understand correctly, you have a lookup field in your SPM-generated search page, and when you try to select an item from the drop-down, the search results don't return any matches, but in advanced search mode, matches are returned without issues, correct?

I tried to reproduce this but was unable to ... So, if possible, kindly send me the AXP project file stored in plugins/projects (this one contains the SPM config, the original project file won't have SPM config saved into it). And also kindly send me a sample data dump to check this issue.