SPM Search Bug for Lookup Fields

Topics related to AppGini plugins/add-ons go here.
Post Reply
sclifton
Posts: 7
Joined: 2020-10-21 10:31

SPM Search Bug for Lookup Fields

Post by sclifton » 2020-11-21 13:15

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.

Post Reply