Microsoft Dynamics CRM (Archived)

Virtual Entities - 1:N Relationship

(0) Share

Report

Posted on by Rizwan Aarif

480

Hi Everyone,

I have two virtual entities in my Solution named as

Project
Issue

Data source is an Odata V4 API I built to retrieve Projects and Issues from JIRA. The issue is I want to have a 1:N relationship between Project and Issue as they are in JIRA. I am trying to add a lookup field of"Project" on my issue entity providing the field having guid of project (projectid) as external name. I save and publish the entity but when I try to access related Issues through Project or Advanced Find I get error as below:

If I remove the lookup field, I can access them but I need to show them as related i.e. one project has many issues.

Below is how I created a Lookup field on "N" side of record i.e. Issue

Below is my Odata API Meta Data showing both records metadata.

Any suggestions would be greatly appreciated. Thanks in Advance.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

Hi Rizwan,

Check this article -

community.dynamics.com/.../dynamics-365-working-with-the-virtual-entities

Was this reply helpful? Yes No
Rizwan Aarif 480 on at

Like (0)

Report

Hi Goutam,

I have already gone through the only (2 articles) including this but it does not seem to work. I don't have issue surfacing data through virtual entities but what I am trying to LINK two virtual entities using 1:N relationship.

Thanks for you suggestion.

Was this reply helpful? Yes No
TomSmelser 1,570 on at

Like (0)

Report

Looks like the field is required in the XML, Nullable="false". In the field definition it is optional. Try making that Business required. I believe that have to be same. Worth a try. Good Luck! Tom.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello,

I am facing the same issues. Please help me to get through it.

I have a CRM Custom Entity "Entity A" and virtual Entity "Advertisement". I have to create a lookup on Advertisement Entity(Virtual Entity) to relate my Custom Entity.

1. Is it possible?

Thanks,

Venkata Pradeep Tumuluri

Was this reply helpful? Yes No
vstonape 6 on at

Like (0)

Report

Please check below URL

https://blogs.technet.microsoft.com/lystavlen/2017/11/10/virtual-entities-relationships/

Was this reply helpful? Yes No
TomSmelser 1,570 on at

Like (0)

Report
Hello,

After some additional trial an error with similar issue I have 2 things to recommend. This may be a timeout issue, or a bad field name. The problem is the view just errors with no helpful info.

1.If the view loads when you exclude the lookup column, then try opening a record in the form. Exclude the lookup from the form. But it seems that even when the lookup is off the form the query will attempt to pull the field. In my case an error occurred but the form produced and XML error that was helpful. There was a misspelling of fields. All External field names have to be exact, down to the case.

2.There could be a timeout issue. If you edit your oData datasource there are 2 fields.

Timeout: 30

Return Inline Count: True

You can try adjusting the timeout. But the easy test is to adjust the "Return Inline Count" and set it to false. In this case I believe it will only return the Top 50 records. So you may get results but you will lose paging counter in CRM. If you get results then you likely have a db performance issue.

Let me know if you have success.

Best regards,
Tom

Was this reply helpful? Yes No
vishal bagadia_crm 490 on at

Like (0)

Report

Hello Rizwan,

We have the similar requirement that needs to be implemented and we are kind of stuck. Any help from you would be very appreciated.

Was this reply helpful? Yes No