Missing fields when I try to add a relationship on a data source

(0) Share

Report

Posted on by AstridMalanka

Hello,

I need to add the vendor name to my purchase order line entity.

So I extended the entity and added the vendor table.

I am trying to add the DirPartyTable to get the vendor name, but when I go to do the relationship, the vendtable fields are empty.

I will add pictures

I am not sure why is not letting me add the field to join,

From what understand I need to do: vendtable.party = dirpartytable.recid

thanks

I have the same question (0)

All responses (14)

Answers (2)

GirishS 27,825 Moderator on at

Like (0)

Report

RE: Missing fields when I try to add a relationship on a data source

Hi AstridMalanka,

Does your custom model refer to "Directory" model. Because DirPartyTable belongs to Directory model.

Thanks,

Girish S.

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report

RE: Missing fields when I try to add a relationship on a data source

I just checked and yes it does.

Was this reply helpful? Yes No
Verified answer

GirishS 27,825 Moderator on at

Like (0)

Report

RE: Missing fields when I try to add a relationship on a data source

Hi AstridMalanka,

It seems VendTable doesn't have relation with DirPartyTable. That's the reason why you are not getting related fields on the lookup.

VendTable has a relation with DirPartyTable using DirPartyView.

So you can either add the DirPartyView as the datasource and set the the Join relation name to DirPartyView.

But if you add view as a datasource it will be used only for viewing purpose not for CRUD operations.

I think this is the only workaround you have.

Thanks,

Girish S.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 236,822 Most Valuable Professional on at

Like (0)

Report

RE: Missing fields when I try to add a relationship on a data source

What if you simply type in the field name? It seems to compile without any error (but I didn't test it further).

Maybe the only problem is with the field lookup.

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report

RE: Missing fields when I try to add a relationship on a data source

I tried DirPartyView and still the field is empty. I also check the vendor entity and I see it uses DirPartyBaseEntity but it is not letting me choose the field. what is the difference between data source and derived data source?

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report

RE: Missing fields when I try to add a relationship on a data source

i tried adding the field manually, but it doesnt let me

Was this reply helpful? Yes No
Martin Dráb 236,822 Most Valuable Professional on at

Like (0)

Report

RE: Missing fields when I try to add a relationship on a data source

Can you please elaborate what you mean by "it doesnt let me"? I did it successfully.

Was this reply helpful? Yes No
GirishS 27,825 Moderator on at

Like (0)

Report

RE: Missing fields when I try to add a relationship on a data source

After adding DirPartyView as datasource you need to give "Join relation name" property.

Thanks,

Girish S.

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report

RE: Missing fields when I try to add a relationship on a data source

I have the same issue, I add the view, but the field view is empty, and when I try to add it manually it doesnt let me.

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report

RE: Missing fields when I try to add a relationship on a data source

Maybe is case sencitive? I need to try that. I just copy the relationship from the vend entity, I am trying that, like copy paste.

Was this reply helpful? Yes No