Re: List Changes Pushed in Last 24 hours (yesterday)

[Luciano Carvalho]

Add this in the query box:

NOT age:1d

On Dec 17, 2012 9:54 AM, "VarunD" <varu...@gmail.com> wrote:

Hi All

I have a need to list down all the changes pushed to Gerrit server in last 24 Hours (yesterday). The Status of those changes can be anything "Open" or "Merged"

So, I need a Gerrit query which shows me all the Changes Pushed to gerrit server in last 24 hours in any state.

Thanks in advance

Regards,
Varun

--
To unsubscribe, email repo-discuss...@googlegroups.com
More info at http://groups.google.com/group/repo-discuss?hl=en

[VarunD]

This Doesnt Work... I am not able to see any results of the query, though i am able to see those when i query based on the status.

As per my understanding Age is to find the Changes which are not updated for last specific, hours or days, etc.

But I want to find out the list of changes which are pushed to gerrit server in last 24 hours in any state, any project & May be or may not be updated.

Thanks and regards,
Varun

[Shawn Pearce]

On Tue, Dec 18, 2012 at 12:06 AM, VarunD <varu...@gmail.com> wrote:
> This Doesnt Work... I am not able to see any results of the query, though i
> am able to see those when i query based on the status.
>
> As per my understanding Age is to find the Changes which are not updated for
> last specific, hours or days, etc.
>
> But I want to find out the list of changes which are pushed to gerrit server
> in last 24 hours in any state, any project & May be or may not be updated.

I think the problem is "NOT age:1d" is an unindexed table scan, so the
server rewrites the query as "status:open NOT age:1d" in order to get
an index. Have you tried using a longer version like:

(status:open NOT age:1d) OR (status:closed NOT age:1d)

Both sides of the OR operator should be indexed expressions, and the
OR operator should just interleave results.

[Marcelo Avila de Oliveira]

I think that the "(indexed_query operator unindexed_query) operator (indexed_query operator unindexed_query)" structure doesn't work anymore, it fails with "500 Internal server error" message.

Anyway, this wouldn't solve Varun's issue because "Age" counts time "since the change was last updated with a review comment or new patch set" (documentation) and he's interested only in the time the change was pushed to Gerrit (don't matter if it was updated or not).

--

Marcelo Ávila de Oliveira

CPqD - Information Technology Enginner

Tel.: +55 19 3705-4125

mav...@cpqd.com.br

www.cpqd.com.br

[VarunD]

HI Marcelo

Yes You are right... This doesnt help as I am just interested in list of all the push happened in last 24 hours