Re: Search question: after a specific date
Alex Hall <[email protected]> Wed, 1 Feb 2017 12:48:12 -0500
| Newsgroups | gmane.comp.bug-tracking.request-tracker.user |
|---|---|
| Message-ID | <CA+Q8_JcvSKtVjrpTXKP99fzDBFZaXYYoi+PTPasJP-d-C+ThSA@mail.gmail.com> |
--001a113ef06a0f80d105477ba7ff Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable On Wed, Feb 1, 2017 at 11:24 AM, Barrett, Brian < [email protected]> wrote: > Dear RT, > > I have a question regarding the searching for =E2=80=9Cafter=E2=80=9D a s= pecific date on 2 > consecutive months. The results for the current month include tickets fr= om > the previous. See below > > When I do a search for > > Status =3D =E2=80=98resolved=E2=80=99 > > AND Owner =3D =E2=80=9Cuser=E2=80=99 > > AND Resolved > =E2=80=982016-12-31=E2=80=99 > > I get a specific total of 38 > > When I do a search for > > Status =3D =E2=80=98resolved=E2=80=99 > > AND Owner =3D =E2=80=9Cuser=E2=80=99 > > AND Resolved > =E2=80=98201-01-31=E2=80=99 > Assuming this is 2017, not just 201 I get a specific total of 6 > > The 6 tickets showing for Feb are also in the report for Jan? Why? > Because you spcified > 2016-12-31, which encompasses everything up to today. Essentially, your two searches are identical, but one starts earlier than the other. You'd need to limit your date with something like Resolved < 2017-02-01 to eliminate anything past Jan 31. At least that's how I'm reading it; sorry if I'm mistaken. > I=E2=80=99m using RT v4.1.11 > > > --=20 Alex Hall Automatic Distributors, IT department [email protected] --001a113ef06a0f80d105477ba7ff Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr"><br><div class=3D"gmail_extra"><br><div class=3D"gmail_quo= te">On Wed, Feb 1, 2017 at 11:24 AM, Barrett, Brian <span dir=3D"ltr"><<= a href=3D"mailto:[email protected]" target=3D"_blank">Brian_= [email protected]</a>></span> wrote:<br><blockquote class=3D"gm= ail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-le= ft:1ex"> <div link=3D"#0563C1" vlink=3D"#954F72" lang=3D"EN-US"> <div class=3D"m_4929986689674513638WordSection1"> <p class=3D"MsoNormal" style=3D"margin-right:0in;margin-bottom:2.0pt;margin= -left:0in;line-height:normal;text-autospace:none"> <span style=3D"font-size:12.0pt;font-family:"Times New Roman",ser= if">Dear RT,</span><u></u><u></u></p> <p class=3D"MsoNormal" style=3D"margin-right:0in;margin-bottom:2.0pt;margin= -left:0in;line-height:normal;text-autospace:none"> <span style=3D"font-size:12.0pt;font-family:"Times New Roman",ser= if">I have a question regarding the searching for =E2=80=9Cafter=E2=80=9D a= specific date on 2 consecutive months.=C2=A0=C2=A0The results for the curr= ent month include tickets from the previous.=C2=A0=C2=A0See below</span><u>= </u><u></u></p> <p class=3D"MsoNormal" style=3D"margin-right:0in;margin-bottom:2.0pt;margin= -left:0in;line-height:normal;text-autospace:none"> <span style=3D"font-size:12.0pt;font-family:"Times New Roman",ser= if">When I do a search for=C2=A0</span><u></u><u></u></p> <p class=3D"MsoNormal" style=3D"margin-right:0in;margin-bottom:2.0pt;margin= -left:0in;line-height:normal;text-autospace:none"> <span style=3D"font-size:12.0pt;font-family:"Times New Roman",ser= if">Status =3D =E2=80=98resolved=E2=80=99</span><u></u><u></u></p> <p class=3D"MsoNormal" style=3D"margin-right:0in;margin-bottom:2.0pt;margin= -left:0in;line-height:normal;text-autospace:none"> <span style=3D"font-size:12.0pt;font-family:"Times New Roman",ser= if">AND Owner =3D =E2=80=9Cuser=E2=80=99</span><u></u><u></u></p> <p class=3D"MsoNormal" style=3D"margin-right:0in;margin-bottom:2.0pt;margin= -left:0in;line-height:normal;text-autospace:none"> <span style=3D"font-size:12.0pt;font-family:"Times New Roman",ser= if">AND Resolved > =E2=80=982016-12-31=E2=80=99=C2=A0=C2=A0</span><u></u= ><u></u></p> <p class=3D"MsoNormal" style=3D"margin-right:0in;margin-bottom:2.0pt;margin= -left:0in;line-height:normal;text-autospace:none"> <span style=3D"font-size:12.0pt;font-family:"Times New Roman",ser= if">I get a specific total of 38</span><u></u><u></u></p> <p class=3D"MsoNormal" style=3D"margin-right:0in;margin-bottom:2.0pt;margin= -left:0in;line-height:normal;text-autospace:none"> <span style=3D"font-size:12.0pt;font-family:"Times New Roman",ser= if">When I do a search for=C2=A0</span><u></u><u></u></p> <p class=3D"MsoNormal" style=3D"margin-right:0in;margin-bottom:2.0pt;margin= -left:0in;line-height:normal;text-autospace:none"> <span style=3D"font-size:12.0pt;font-family:"Times New Roman",ser= if">Status =3D =E2=80=98resolved=E2=80=99</span><u></u><u></u></p> <p class=3D"MsoNormal" style=3D"margin-right:0in;margin-bottom:2.0pt;margin= -left:0in;line-height:normal;text-autospace:none"> <span style=3D"font-size:12.0pt;font-family:"Times New Roman",ser= if">AND Owner =3D =E2=80=9Cuser=E2=80=99</span><u></u><u></u></p> <p class=3D"MsoNormal" style=3D"margin-right:0in;margin-bottom:2.0pt;margin= -left:0in;line-height:normal;text-autospace:none"> <span style=3D"font-size:12.0pt;font-family:"Times New Roman",ser= if">AND Resolved > =E2=80=98201-01-31=E2=80=99=C2=A0=C2=A0</span><u></u>= <u></u></p></div></div></blockquote><div>Assuming this is 2017, not just 20= 1 <br><br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8e= x;border-left:1px #ccc solid;padding-left:1ex"><div link=3D"#0563C1" vlink= =3D"#954F72" lang=3D"EN-US"><div class=3D"m_4929986689674513638WordSection1= "><p class=3D"MsoNormal" style=3D"margin-right:0in;margin-bottom:2.0pt;marg= in-left:0in;line-height:normal;text-autospace:none"></p> <p class=3D"MsoNormal" style=3D"margin-right:0in;margin-bottom:2.0pt;margin= -left:0in;line-height:normal;text-autospace:none"> <span style=3D"font-size:12.0pt;font-family:"Times New Roman",ser= if">I get a specific total of 6</span><u></u><u></u></p> <p class=3D"MsoNormal" style=3D"margin-right:0in;margin-bottom:2.0pt;margin= -left:0in;line-height:normal;text-autospace:none"> <span style=3D"font-size:12.0pt;font-family:"Times New Roman",ser= if">The 6 tickets showing for Feb are also in the report for Jan?=C2=A0=C2= =A0Why?</span><u></u><u></u></p></div></div></blockquote><div>Because you s= pcified > 2016-12-31, which encompasses everything up to today. Essentia= lly, your two searches are identical, but one starts earlier than the other= . You'd need to limit your date with something like<br></div><div>Resol= ved < 2017-02-01<br></div><div>to eliminate anything past Jan 31. At lea= st that's how I'm reading it; sorry if I'm mistaken. <br></div>= <blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p= x #ccc solid;padding-left:1ex"><div link=3D"#0563C1" vlink=3D"#954F72" lang= =3D"EN-US"><div class=3D"m_4929986689674513638WordSection1"><p class=3D"Mso= Normal" style=3D"margin-right:0in;margin-bottom:2.0pt;margin-left:0in;line-= height:normal;text-autospace:none"></p> <p class=3D"MsoNormal" style=3D"margin-right:0in;margin-bottom:2.0pt;margin= -left:0in;line-height:normal;text-autospace:none"> <span style=3D"font-size:12.0pt;font-family:"Times New Roman",ser= if">I=E2=80=99m using RT v4.1.11</span><span style=3D"font-size:10.0pt;font= -family:"Segoe UI",sans-serif;color:black"> </span><u></u><u></u></p> <p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p> </div> </div> </blockquote></div><br><br clear=3D"all"><br>-- <br><div class=3D"gmail_sig= nature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><div><div>Alex = Hall<br></div>Automatic Distributors, IT department<br></div><a href=3D"mai= lto:[email protected]" target=3D"_blank">[email protected]</a><br></div><= /div> </div></div> --001a113ef06a0f80d105477ba7ff--