[rt-users] Find the first day of this month

[Chris Herrmann]

Hi all,

This has been kicked around a few times over the years if google & the list
archives are anything to go on, but I haven't actually seen a solution that
meets what any of the requestors (and me) want.

Which is... to run a search using a date like:

Queue = 'myqueue' and (  ( Status = 'open' or Status = 'new' ) OR (
Resolved > 'first dow after last month' ) )


or "last month + 1" or "first dom" or really anything that will
programmatically always return the first day of this month. I have a shell
script that does this by constructing a date in bash, and then passing the
date to the query as a variable, but I can't do this within the "save
search" function.


The reason I'm after "save search" is that the HTML reports are easier for
humans to read than the TSV extracts that the bash scripts generate.


things like "last month" get close - but it simply works out "now - 30
days". And I can't see a way in Time::ParseDate to extract the month and
year in the same way I would in bash using something like `date +%b`


MIT have a nice page that has better examples than the Time::Parse doco
http://kb.mit.edu/confluence/pages/viewpage.action?pageId=4269222  but I
can't work out how to construct the thing I want using what's available.


Please tell me I'm wrong!


Regards,


Chris

Re: [rt-users] Find the first day of this month

[Chris Herrmann]

I also looked at the Attributes table, but the actual SavedSearch is stored
as a binary blob AFAICT? I was going to head down the path of updating the
contents of the field with a programmatically generated string once a day
or something like that:

queue = "myqueue" and Created > "2015-12-01"

i.e. just change the date in question every day so that the Dashboards and
scheduled email reports always have the desired dates. But... I can't see
how to do it with what's there... (a BLOB). And it looks really blobby too
- proper blob... not just a bunch of TEXT that happens to be stored as a
BLOB?

On 8 December 2015 at 21:55, Chris Herrmann 
wrote:

> Hi all,
>
> This has been kicked around a few times over the years if google & the
> list archives are anything to go on, but I haven't actually seen a solution
> that meets what any of the requestors (and me) want.
>
> Which is... to run a search using a date like:
>
> Queue = 'myqueue' and (  ( Status = 'open' or Status = 'new' ) OR (
> Resolved > 'first dow after last month' ) )
>
>
> or "last month + 1" or "first dom" or really anything that will
> programmatically always return the first day of this month. I have a shell
> script that does this by constructing a date in bash, and then passing the
> date to the query as a variable, but I can't do this within the "save
> search" function.
>
>
> The reason I'm after "save search" is that the HTML reports are easier for
> humans to read than the TSV extracts that the bash scripts generate.
>
>
> things like "last month" get close - but it simply works out "now - 30
> days". And I can't see a way in Time::ParseDate to extract the month and
> year in the same way I would in bash using something like `date +%b`
>
>
> MIT have a nice page that has better examples than the Time::Parse doco
> http://kb.mit.edu/confluence/pages/viewpage.action?pageId=4269222  but I
> can't work out how to construct the thing I want using what's available.
>
>
> Please tell me I'm wrong!
>
>
> Regards,
>
>
> Chris
>

Re: [rt-users] Find the first day of this month

[Christian Loos]

Hi Chris,

won't help you now but RT 4.4.0 will support this if you set
$PreferDateTimeFormatNatural to 1:
https://github.com/bestpractical/rt/commit/4836a20

If you really need this in RT 4.2 you can try applying these commits:
https://github.com/bestpractical/rt/commit/f446755
https://github.com/bestpractical/rt/commit/e527517
https://github.com/bestpractical/rt/commit/4836a20

Maybe this will work, but I didn't checked it.

Chris

Am 08.12.2015 um 11:55 schrieb Chris Herrmann:
> Hi all,
> 
> This has been kicked around a few times over the years if google & the
> list archives are anything to go on, but I haven't actually seen a
> solution that meets what any of the requestors (and me) want.
> 
> Which is... to run a search using a date like:
> 
> Queue = 'myqueue' and (  ( Status = 'open' or Status = 'new' ) OR ( 
> Resolved > 'first dow after last month' ) )
> 
> 
> or "last month + 1" or "first dom" or really anything that will
> programmatically always return the first day of this month. I have a
> shell script that does this by constructing a date in bash, and then
> passing the date to the query as a variable, but I can't do this within
> the "save search" function.
> 
> 
> The reason I'm after "save search" is that the HTML reports are easier
> for humans to read than the TSV extracts that the bash scripts generate.
> 
> 
> things like "last month" get close - but it simply works out "now - 30
> days". And I can't see a way in Time::ParseDate to extract the month and
> year in the same way I would in bash using something like `date +%b`
> 
> 
> MIT have a nice page that has better examples than the Time::Parse doco
> http://kb.mit.edu/confluence/pages/viewpage.action?pageId=4269222  but I
> can't work out how to construct the thing I want using what's available.
> 
> 
> Please tell me I'm wrong!
> 
> 
> Regards,
> 
> 
> Chris
>