Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Copper Elite Contributor
Posts: 70
Registered: ‎04-30-2009

SLX 7.5 Web - Provider Extension

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

Moderator
Posts: 440
Registered: ‎05-07-2008

Re: SLX 7.5 Web - Provider Extension

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

John Perona

Director, Infor CRM Development

Infor CRM

Infor CRM

New Member
Posts: 2
Registered: ‎08-28-2009

Re: SLX 7.5 Web - Provider Extension

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.

New Member
Posts: 2
Registered: ‎08-28-2009

Re: SLX 7.5 Web - Provider Extension

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. Smiley Indifferent

 

Thanks for any help anyone can provide.

 

Moderator
Posts: 440
Registered: ‎05-07-2008

Re: SLX 7.5 Web - Provider Extension

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 Development

Infor CRM

Infor CRM

Highlighted
Copper Elite Contributor
Posts: 70
Registered: ‎04-30-2009

Re: SLX 7.5 Web - Provider Extension

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

 

Thanks!

~ Henry