How do I query for all inquiries opened 3 months ago, by area or exported to an excel sheet?
|
1
|
"3 months ago" can be read a few ways. I'll give you a few of them and let me know if they're not close enough... If you want to see all of the inquiries opened in November, use this: opened:"November 2009" category:inquiry If you want to see all of the inquiries opened from three months ago until today, use this: opened:"11-1-2009..today" category:inquiry If you want cases opened exactly three months ago today, use this: opened:"11-12-2009" category:inquiry If you want to add "area" to the query, add it on like so (I'll just grab one of the other queries as an example)... opened:"11-12-2009" category:inquiry area:"name of area you want to see" If you don't want closed cases returned, don't forget to add: status:open I don't know any way of querying based on what was exported to Excel unless you've tagged it with something or entered something into the case. If I don't seem to understand your question, let me know what I'm missing and I'll do my best to get you what you're looking for. |
|||
|
|
