8000 DirectQuerySender · frankframework/frankframework Wiki · GitHub
[go: up one dir, main page]
Skip to content

DirectQuerySender

Jump to bottom Edit New page
LEEERRoooYYY JJJEENNKINNSSS edited this page Sep 30, 2022 · 4 revisions 
                       <pipe name="getIntervalRange">
				<sender name="getIntervalRange"
					queryType="select"
					scalar="true"
					className="nl.nn.adapterframework.jdbc.FixedQuerySender"
					query="SELECT min(EAD) FROM
								(
						 			SELECT MIN(AANMAAKDATUM) + ?{maxDaysToArchive} as EAD FROM RECORDSETS WHERE TYPE = ?{Type}
						 			UNION
						 			SELECT SYSDATE-?{Retention} AS EAD FROM DUAL
					 			) order by EAD"
					useNamedParams="true"/>
				<param name="maxDaysToArchive" sessionKey="maxDaysToArchive"/>
				<param name="Retention" sessionKey="retention"/>
				<param name="Type" sessionKey="type"/>
				<forward name="success" path="EXIT"/>
			</pipe>
`
Add a custom footer

Clone this wiki locally
0