Search for issues

[Lady Audrey Benipayo]

Hi,

How can I limit a search using a specific time frame? For example, I am searching for issues with a Final Distribution Due date from January 1, 2018 through June 30, 2018.

Thanks,

Audrey 

[Kian Stack Mumo Systems · Accepted solution]

Use whatever your custom field name is inside of the quotes. For example:

"Final Distribution Due" >= "2018/01/01" and "Final Distribution Due" <= "2018/06/30"

[Kian Stack Mumo Systems]

It's a little hard to know what you want to search for. 

I think that you aren't quite understanding how the "OR" statements work. In the query you showed below, you will find the following sets of tickets

1) Project = BRM and assignee in (membersOf("BRM - SSF Fluid Sample Handling") and "Distribution Request Type" = "Internal Customer Transfer"

2) "Distribution Request Type" = "BRM Transfer"

3) Distribution Request Type" = "Domestic Shipment"

4) "Distribution Request Type" = "International Shipment" 

5) "Distribution Request Type" = Other AND "Final Distribution Due Date"  >= "2018/01/01" and "Final Distribution Due Date"  <= "2018/06/30"

In the query you provided, you are only restricting the dates of the tickets that have the "Distribution Request type" = "Other". 

I suspect that what you wanted was the following singular group:

1) Project = BRM and assignee in (membersOf("BRM - SSF Fluid Sample Handling") and ("Distribution Request Type" in ("Internal Customer Transfer", "BRM Transfer", "Domestic Shipment","International Shipment",Other)) AND "Final Distribution Due Date"  >= "2018/01/01" and "Final Distribution Due Date"  <= "2018/06/30"

I'd try the query I provided. Let me know if it works.

[Kian Stack Mumo Systems]

@Lady Audrey Benipayo was this query helpful to you at all?

[Lady Audrey Benipayo]

Yes, it worked! Thank you!

[Kian Stack Mumo Systems]

Good to hear! Please accept the answer if it helped you!

[Lady Audrey Benipayo]

I get the following error:

I updated it to Final Distribution Due Date and I still get other dates. Here is my entire query: project = BRM AND assignee in (membersOf("BRM - SSF Fluid Sample Handling")) AND "Distribution Request Type" = "Internal Customer Transfer" OR "Distribution Request Type" = "BRM Transfer" OR "Distribution Request Type" = "Domestic Shipment" OR "Distribution Request Type" = "International Shipment" OR "Distribution Request Type" = Other AND "Final Distribution Due Date"  >= "2018/01/01" and "Final Distribution Due Date"  <= "2018/06/30"