Question How to substiture a table name during the execution

Hi,

I have a process with a SQL Operation which executes a query stored in a table :
The query executed with the sp_executesql :
My issue is that the %x{$RAPPROCHEMENT/tech:physicalPath()}x% is generated from metadata information during the build.

So when my process is executed, the %x{$RAPPROCHEMENT/tech:physicalPath()}x% is not replaced with metadata information.

Is there a synthax to do it?

Thanks

Hi
Yes you are right, the xpath expression is translated during compilation.

if it is not mandatory to user xpath, you can juste store you table name in the table without xpath like:

SELECT 1
FROM RAPPROCHEMENT

and once you configuration is changed, juste change the value in your table.

or:
declare the variables like TABLE_NAME in you process which will use xpath, and modify your query like this:

ELECT 1
FROM ${~/TABLE_NAME}$
WHERE 1 = 1 AND ....

during execution, value will be translated


wish can help you!

@letancel
What do you mean when you say that "%x{$RAPPROCHEMENT/tech:physicalPath()}x% is not replaced with metadata information" ? What is generated ?
Normally, in the built delivery you should get the table name. Is it not the case ?
It should work fine as long as you have a metadata link named RAPPROCHEMENT on your process or action...

Please provide more details as %x{$RAPPROCHEMENT/tech:physicalPath()}x% is really a good way to refer to table names in Sql operations and it should work fine, there must be something missing (a metadata link maybe). Can you share a screenshot of action and process ?

In fact, the %x{$RAPPROCHEMENT/tech:physicalPath()}x% is a xpath expression, once your transformation of your process to xml is done, the life of this expression is over. in your xml file, value of %x{$RAPPROCHEMENT/tech:physicalPath()}x% will be translated smthing like: RAPPROCHEMENT which is the physical name of your table. so nothing with your link your metadata.

Thanks Endy, you are right and I know this.
But the original poster wrote "%x{$RAPPROCHEMENT/tech:physicalPath()}x% is not replaced with metadata information".
=> My understanding is that his metadata's information is not being replaced at all, not even at build time.
@letancel can you please clarify?

@risson thank you for your reply.

If i have well understood the context, letancel has stored his xpath expression in the data base, and use sql parameter or operation to get this xpath, like there is no more transformation of xpath, so runtime can not run the query.