Dynamic parameter in a Data Template
Hi,
I've built a data template with a parameter section that includes the following:
.. as all the reading I've found thus far refers to this as the correct syntax to use to include the current date / time as a parameter. I don't want to use a parameter passed as runtime from Oracle because if the user copies an existing request it doesn't update the value (unless there is a way to do this), and I don't want to include it in the select statement, as the value is not returned if there is no data found for the entire query.
I've built a data template with a parameter section that includes the following:
<parameter name="p_test2" dataType="date" defaultValue="{$SYSDATE()$}" />
.. as all the reading I've found thus far refers to this as the correct syntax to use to include the current date / time as a parameter. I don't want to use a parameter passed as runtime from Oracle because if the user copies an existing request it doesn't update the value (unless there is a way to do this), and I don't want to include it in the select statement, as the value is not returned if there is no data found for the entire query.
0