Dynamic input not working correctly
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I apologize for this lengthy (and probably simple) request but I cannot figure out how to configure my dynamic input.
The beginning of my workflow has two textbox tools and two action tools that connect to my data input.
The text box tools and actions tools are configured as shown (with the dates changed to 3/31/2019 and 2019-03-31 for the other two tools).
And the SQL for the strings that are being replaced is as follows.
So the workflow initially prompts the user to enter two dates (a begin date and an end date) when the workflow is run in our non-production gallery as shown below.
But when use the date format shown above I get an error "Error: ORA-01843: not a valid month."
So I tried entering the format "01-JAN-19" in the text boxes but then I don't get any data as I believe it is replacing string 2019-01-01 with 01-JAN-19 and there is not data in this specific format.
Could someone assist?
Solved! Go to Solution.
- Labels:
- Dynamic Processing
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @crtakacs
Have you tried to use the Date Interface Tool, instead of making the user to type the date in a free format?
Cheers,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @crtakacs you need to select the string you want to replace as shown below. You might want to use the Date interface tool. Have attached a sample workflow.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @crtakacs another way you could do this is use a dynamic input to update a where clause and replace the dates in your sql from the user inputs. Would suggest you feed in a text input with the dates entered from the user that then feeds into the dyanmic input so you can use Replacement field.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This worked perfect - thanks!