SLX 7.5 Web - Provider Extension

[henrycohen29]

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

[jperona]

We are researching this one now, I'll get you an example soon.

[clyle]

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.

[clyle]

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.

[jperona]

A defect was found in using the AddJoinFromString API in the provider: 1-70419

This will be contained in 7.5.1 HF31

[henrycohen29]

Thanks John. Is there a release date for this HF?

Thanks!

~ Henry