Hi,
So I have implemented a Custom Data Provider for a Virtual Table and all is working up until I've started to implement filtering in the RetrieveMultiple plugin to handle quick find etc. On the virtual table I have created a lookup to a standard Dataverse table, the data provider stores this guid as a string so when I return records I simply populate the row and as an entity reference and it shows up in the standard grid as expected, all good. The problem comes when I add a subgrid on the standard entity to show the related records from the virtual table, the query that comes from the UI has a weird filter, it has the lookup field in the condition but it always comes through as "fieldname not null" rather that "{fieldname} eq {guid}"!
If I open the dev tools I can see the fetchxml in the network trace and it correctly has the filter, but in my plugin I output the query in the inputparameters and it's different, my understanding suggests the fetchxml I see is what would appear in stage 20, but then when the data provider runs in stage 30 (Core Operation) this is already converted so I should see that represented correctly in the QueryExpression.
I have made sure that all the search fields are correctly defined with in the quick find view which made no difference so I am stumped, I am sure it should work as I've used the provided SQL Data Provider for virtual tables previously and when doing the same thing that works just fine and correctly filters the subgrid based on the selected related record.
Any thoughts greatly appreciated.
