[sims] Command Reporter odd issues with date range

[ChrisH]

I'm not having a good SIMS day Last year I created a powershell script to do some scheduled reports using command reporter, for processing external to SIMS. When I came back after Christmas I noticed even though the report was running every week day, there were no entries from January. I reopened the report and changed the saved value in the filter for the date range and it started running again. Today I have noticed no entries for February! As an experiment I tried setting the saved date in the report to Monday and sure enough on the next run I got all the entries, including todays!

 

I am supplying the parameters to commandreporter as part of the command line and this seems to work fine. I didn't want to do it as a file as that adds more complexity to script and parsing xml.

 

Here is the kind of filter I mean:

 

 

Is there another way I should be doing this or is this a new bug?

[Esteban_Child_of_the_Sun]

Have you got the correct external ID for the report filter when passing the value in? (If not then run the report from the command line with the /PARAMDEF switch to get the correct ID)

[ChrisH]

That was the one! The ID was correct when I first set it up, under what situations will that ID change?

[bfelton]

That was the one! The ID was correct when I first set it up, under what situations will that ID change?

 

It seems to change any time the report is edited and saved.

[ChrisH]

It seems to change any time the report is edited and saved.

 

Thanks, I will look out for this in the future then.