Filter Results using Dynamic Items List
I am attempting to upgrade my site to Tiki 18 and I am running into an issue with searching Tiki tracker results with fields that are using Dynamic Items List types.
Here is the example.
I have an employee tracker setup that lists ID, First Name, Last Name
In a different tracker, I am referencing the employee tracker.
I have an Item Link field that links to the employee tracker ID column, I think have a Dynamic Items List type setup for First Name and Last Name that links to the ID and then displays the either the First or Last Name for the appropriate field.
So everything displays fine in the tracker, but when you filter on First Name or Last Name it is not showing up in the results.
So the tracker will show John Smith but if I search for the last name of Smith in the results, it comes up empty.
However, in reviewing the database entries for this tracker, it looks like it's listing the value as the value for the ID rather than the actual name. So if I filter and search by last name for 150724 it returns the result I was looking for.
Am I setting up the Dynamic Items List type incorrectly?