{REPORT TICKET DETAILS: on ticket from past period

V5 Question
1

Am I imagining things or is it correct that;

{REPORT TICKET TETAILS:TS.Comp Drinks Offer:T.Id=[:CommandValue]}

Given a ticket Id for a ticket in a past period would return null/blank?

Ive checked and it works as expected for tickets today but not past periods.

2

Reports are always by default last WP, but that can be changed in Report Explorer.

Since you obviously have this Report on a Custom Screen to be able to feed a Command Value in as a parameter, you can also change the Date Range using using Refresh Custom Report Widget using the Date Filter parameter.

You can also feed in the Command Value (or anything really) using the Report Parameters parameter, which accepts comma-separated values, and puts those values into $1, $2, $3, etc in your Report.

So your Report might look like this then:

{REPORT TICKET DETAILS:TS.Comp Drinks Offer:T.Id=$1}

Whatever you put in the Report Parameters field (comma-separated) will be sent to $1,$2,$3, etc.

The Date Filter accepts things like Today, Yesterday, etc. It also accepts a Range like below, AFAIK …

2016-01-01<>2017-01-01

EDIT: yes, here is the post from Emre showing you can use a Range like above …

1 Like
3

Sorry should have been more specific.
I’m using it in constraints…

4

Have you tried something like:

{REPORT TICKET DETAILS:TS.Comp Drinks Offer:T.Id="[:CommandValue]" and T.Date<"2016-01-01" and T.Date>"2017-01-01"}
5

Thanks, will try tomorrow :slight_smile: been a busy night and pint time now :wink:

6

Unfortunately doesn’t seem to work, even for a today ticket…