Hello Lava users,
I'm trying to build a query to monitor all the test jobs done in a given period. Let's say all the jobs done in January, just to check the robustness of my setup (incomplete jobs rate). In the query interface, I can add a condition on start_time of a job, but only with a "greater than" operator, when I want to add also a condition on start_time "less than".
Do you have any hint to do this?
Best regards,
Denis
Hi Denis,
There's a limitation when building queries for date field operators to exclusively 'Greater then'. Now that I think about it, it sounds like a bug and should be expanded to at least 'Less then' and 'Equals'. Here's the line in the code which validates the date operators, if it helps: https://git.lavasoftware.org/lava/lava/blob/master/lava_results_app/models.p...
Cheers,
On 1/30/19 8:51 AM, Denis HUMEAU wrote:
Hello Lava users,
I’m trying to build a query to monitor all the test jobs done in a given period. Let’s say all the jobs done in January, just to check the robustness of my setup (incomplete jobs rate).
In the query interface, I can add a condition on start_time of a job, but only with a “greater than” operator, when I want to add also a condition on start_time “less than”.
Do you have any hint to do this?
Best regards,
Denis__
Lava-users mailing list Lava-users@lists.lavasoftware.org https://lists.lavasoftware.org/mailman/listinfo/lava-users
On Wed, 30 Jan 2019 at 08:18, Stevan Radakovic stevan.radakovic@linaro.org wrote:
Hi Denis,
There's a limitation when building queries for date field operators to exclusively 'Greater then'. Now that I think about it, it sounds like a bug and should be expanded to at least 'Less then' and 'Equals'. Here's the line in the code which validates the date operators, if it helps: https://git.lavasoftware.org/lava/lava/blob/master/lava_results_app/models.p...
https://git.lavasoftware.org/lava/lava/issues/207
In the meantime, there is a workaround. Proceed with Greater than and save the query. View the results and click "This query by URL". The URL creates a CustomQuery and the query string can be amended to use lt instead of gt. The URL can then be saved as a query too - with the limitation that the modified condition should not be edited (or the Less than option will not be available). Other conditions can be edited as normal.
Cheers,
On 1/30/19 8:51 AM, Denis HUMEAU wrote:
Hello Lava users,
I’m trying to build a query to monitor all the test jobs done in a given period. Let’s say all the jobs done in January, just to check the robustness of my setup (incomplete jobs rate).
In the query interface, I can add a condition on start_time of a job, but only with a “greater than” operator, when I want to add also a condition on start_time “less than”.
Do you have any hint to do this?
Best regards,
Denis
Lava-users mailing list Lava-users@lists.lavasoftware.org https://lists.lavasoftware.org/mailman/listinfo/lava-users
-- Stevan Radaković | LAVA Engineer Linaro.org <www.linaro.org> │ Open source software for ARM SoCs
Lava-users mailing list Lava-users@lists.lavasoftware.org https://lists.lavasoftware.org/mailman/listinfo/lava-users
The workaround works fine, thanks for this and the issue recording.
Denis
-----Original Message----- From: Lava-users lava-users-bounces@lists.lavasoftware.org On Behalf Of Neil Williams Sent: mercredi 30 janvier 2019 09:30 To: Stevan Radakovic stevan.radakovic@linaro.org Cc: lava-users lava-users@lists.lavasoftware.org Subject: Re: [Lava-users] Query to get jobs between two dates
On Wed, 30 Jan 2019 at 08:18, Stevan Radakovic stevan.radakovic@linaro.org wrote:
Hi Denis,
There's a limitation when building queries for date field operators to exclusively 'Greater then'. Now that I think about it, it sounds like a bug and should be expanded to at least 'Less then' and 'Equals'. Here's the line in the code which validates the date operators, if it helps: https://git.lavasoftware.org/lava/lava/blob/master/lava_results_app/mo dels.py#L1256
https://git.lavasoftware.org/lava/lava/issues/207
In the meantime, there is a workaround. Proceed with Greater than and save the query. View the results and click "This query by URL". The URL creates a CustomQuery and the query string can be amended to use lt instead of gt. The URL can then be saved as a query too - with the limitation that the modified condition should not be edited (or the Less than option will not be available). Other conditions can be edited as normal.
Cheers,
On 1/30/19 8:51 AM, Denis HUMEAU wrote:
Hello Lava users,
I’m trying to build a query to monitor all the test jobs done in a given period. Let’s say all the jobs done in January, just to check the robustness of my setup (incomplete jobs rate).
In the query interface, I can add a condition on start_time of a job, but only with a “greater than” operator, when I want to add also a condition on start_time “less than”.
Do you have any hint to do this?
Best regards,
Denis
Lava-users mailing list Lava-users@lists.lavasoftware.org https://lists.lavasoftware.org/mailman/listinfo/lava-users
-- Stevan Radaković | LAVA Engineer Linaro.org <www.linaro.org> │ Open source software for ARM SoCs
Lava-users mailing list Lava-users@lists.lavasoftware.org https://lists.lavasoftware.org/mailman/listinfo/lava-users
lava-users@lists.lavasoftware.org
-
Denis HUMEAU -
Neil Williams -
Stevan Radakovic