07-27-2009 01:15 PM
Hi,
I am attempting to write a provider extension to Add a Join everytime the Contact table is hit.
I want this SQL:
Select a1.* from contact a1
To turn into:
Select a1.* from contact a1 left join cext_contact a2 on (a1.contactid = a2.contactid)
I see that the objects available to me have various methods, AddJoinFromString, and AddConditionfromString, but I cannot get the proper parameter format syntax for this to work.
Thanks
~ Henry
08-02-2009 03:14 PM
We are researching this one now, I'll get you an example soon.
John Perona
Director, Infor CRM DevelopmentInfor CRM
08-28-2009 12:29 PM
Friendly bump to see if there's any word on some sample code for this?
I'm also trying to add a Join using a provider extension and can't seem to get the syntax right. I can easily modify the Where clause, but the provider doesn't like it when I try to add a Join.
08-28-2009 12:40 PM
I should have added that I've tried a number of approches, including:
stmt.SQLFrom.SQLJoins.AddJoinFromString(String.Format("inner join CONTACT_EXTENSION ce ON {0}.CONTACTID=ce.CONTACTID", join.Alias))
...and...
stmt.SQLFrom.SQLJoins.AddJoinFromString(String.Format("CONTACT_EXTENSION ce ON {0}.CONTACTID=ce.CONTACTID", join.Alias))
Then I thought I'd try something like:
Dim j As New SQLJoin
j.Name = "CONTACT_EXTENSION"
j.Alias = "ce"
j.SQLOn = New SQLConditions()
I gave up on that approach, though, when I discovered that the SQLOn property is ReadOnly.
Thanks for any help anyone can provide.
09-02-2009 08:39 AM
A defect was found in using the AddJoinFromString API in the provider: 1-70419
This will be contained in 7.5.1 HF31
John Perona
Director, Infor CRM DevelopmentInfor CRM
09-02-2009 09:11 AM
Thanks John. Is there a release date for this HF?
Thanks!
~ Henry