Dynamic SQL statement in mapping

[Former Member]

I need to pass on a SQL statement with dynamic fields (taking the values from an input and map these values in the SQL statement. Is there a way to construct this SQL statement in XI ?

The SQL statement is then passed on to a 3rd party webservice to conduct a DB search

Example SQL:

The SQL construct to search for the document is:

SELECT [d.Id] …

FROM Document d

WHERE d.PathwayObjectId = businessObjectPrimaryKey

AND WHERE d.isCurrentVersion=TRUE

AND WHERE d.DocumentFormType=formType

ORDER BY DateCreated

Thanks in advance..

Edited by: Eric Deijkers on May 7, 2008 4:18 AM

[Former Member · Accepted solution]

hi

It is possible

SenderSystem <=> XI (Map the request to SQL statement) <=> Call WebService (Execute Query)

I understand the Query should come in a single element in the webservice. So using a User defined fn or Java mapping you can create the dynamic query or std fns if it's simple

<Query>[ dynamic query]</Query>

rgds,

Arun

[Former Member]

Thanks. A UDF with input string and hardcoded return statement did the trick.