I want to add dynamic input to my sql where condition to support reloads if required.
filter condition would be based on the date.
This will help us not to change the sql in prod environments in case of relaods
Gnaneshwar Muthaluri -- can you provide an example of what you'd like the SQL to look like ideally? That will help us make suggestions that the platform would support.
Consider history TableA .
Expected Query :
select * from TABLEA where snapshotdate = ( CASE WHEN '@datevariable' IS NULL THEN '@SYSDATE' ELSE '@datevariable' END )
'@datevariable' = This will be a dynamic/user input if the table needs to be reloaded for a previous date.
© Incorta, Inc. All Rights Reserved.