Edgewall Software

Ticket #6831 (closed enhancement: duplicate)

Opened 10 months ago

Last modified 10 months ago

can you add a date filter to query by in the custom query.

Reported by: edunne Owned by: jonas
Priority: normal Milestone:
Component: report system Version: 0.11b1
Severity: normal Keywords: query datetime
Cc:

Description

we can totally ditch the reports if we would be able to query by creation date or last modified date.

i know it's possible as the new timeline functionality is able to filter on these criteria.

Maybe the issue is that currently the custom query is only able to query against the ticket table.

In the short term, just having the ability to show last modified and creation date as columns would be great.

Attachments

Change History

  Changed 10 months ago by osimons

  • status changed from new to closed
  • resolution set to duplicate
  • component changed from search system to report system

Quite a popular request. Closing it as a duplicate of #2288, and adding the essence of this request to that ticket as a comment.

follow-up: ↓ 3   Changed 10 months ago by cboos

just having the ability to show last modified and creation date as columns would be great.

I thought that this was already possible in 0.11, but no, only when using TicketQuery. Well, let's add those in the Columns selector. I didn't find another ticket for that so OK to reopen?

in reply to: ↑ 2   Changed 10 months ago by osimons

  • status changed from closed to reopened
  • resolution duplicate deleted
  • milestone set to 0.11.1

Replying to cboos:

I didn't find another ticket for that so OK to reopen?

Of course. If you want a ticket closed against 0.11, it might as well be this one.

  Changed 10 months ago by cboos

  • status changed from reopened to closed
  • resolution set to duplicate

Ok, actually there were already tickets for the visualization part, #4966 and #5326. The filtering part is indeed covered by #2288.

  Changed 10 months ago by cboos

  • keywords query datetime added
  • milestone 0.11.1 deleted

Add/Change #6831 (can you add a date filter to query by in the custom query.)

Author



Change Properties
<Author field>
Action
as closed
Next status will be 'reopened'
to The owner will change from jonas. Next status will be 'closed'
 
Note: See TracTickets for help on using tickets.