mikefactorial
Getting an Invalid Argument Error when i Added a lookup field to my Virtual entity view
The trace log confims that query run succesfully against TDS for lookups but crm throws an "invalid argument error". The filtering by lookup field works perfectly fine, displaying non-lookup fields also ok.
@marcusdede-acg looks like this is a duplicate of #8. Can you turn on Plugin Tracing and see if there's any specific error message in the trace logs that would help pinpoint the issue?
@mikefactorial I've checked the traces , i can see the logs regarding the query and returned records . I also confirm that the query in SQL works perfectly fine.
i've read the following on the microsoft guideline; would that be the reason since i am creating a relationship between dataverse entity-contact- and my virtual table ?
"We recommend that you target a single data source when you use virtual entities in Advanced Finds. For example, creating an Advanced Find that ultimately creates a join between the Dataverse native data and the virtual entity external data isn't supported. "