This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
There could be quite a few things happening here, but let's look at the immediate.
You are replacing -9999 and 7777 in your query, but those are numeric values and you are placing dates in their stead, which act as strings. Your query has no single quotes around the queried value, but in SQL, you will need those.
So it needs to look like: cast(Field as date) = '2018-01-01'
It currently looks like: cast(Field as date) = 2018-01-01 <-- This will fail
I simplified the workflow and kept only the date inputs.
I also input some dates and asked for my update tool to replace the 2018-01-01 and 2018-01-31 so that the quotations still remain.
I chose the dates 2018-06-11 and 2018-06-15 in the interface
However, the final output file gave data from 1/1/2018 to 1/31/2018 and not the dates selected. This makes me feel that the replace a string is not happening.
I went back to using 9999 and 8888 in the query and kept the quotations.
However, this time the excel file produced no rows of data. This makes sense if the query ran as it original was as there are no dates 9999 and 8888 and thus no rows returned. It appears the main issue is with the Action Tool not actually updating and replacing any strings.
I am looking at your setup and it seems that you have selected the action tool to adjust where "@fileformat - value = "23"". There is no 9999 in that so it doesn't have anything to replace. Check to make sure the action tool is looking at the correct thing to do the work on. it should be the option 'File - option: (your query)'
Can you please show me with screenshots where I can adjust the Action Tool configuration? The only two places I have options are at the top drop down and the bottom replace a string field box. I am not able to click on the area where it says @FileFormat - value="23" to adjust it.
You are going to kick yourself but if you look at that setup you have the field above selected in grey. The action tool is looking at the cachecosmeticname instead of the query. You gotta be careful here with clicking around. It should be better about that stuff really.
Another tip I would offer is to use the calendar interface tool instead. Less room for user error