search

mikefactorial / SqlVirtualEntityDataProvider

A Virtual Entity Provider using a direct SQL Connection to Azure SQL / SQL On-Prem
MIT License
22 stars 10 forks source link

Getting an Invalid Argument Error when i Added a lookup field to my Virtual entity view #10

Open marcusdede-acg opened 3 years ago

marcusdede-acg commented 3 years ago

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.

mikefactorial commented 3 years ago

@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?

marcusdede-acg commented 3 years ago

@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. "