Hi
Thanks for your reply.
Yes, I need the logical OR operation here.
Seems the simple query is not either doing logical "AND" operation also.
Because, if so, the output should be empty list in my example. However, the
output is list of meters with the project_id value as d41cd...*. If I
interchange the project_id field values in my query, the resulting output is
list of meters with the project_id value as f28d2...*. i.e. the API is using
the last q.field value for filtering for the "project_id" field.
I have seen the complex query format supporting these additional operations
like logical "OR", but my understanding from the documentation was that these
complex queries are supported only for Samples, Alarms and Alarms History, but
not for "Meters". Nevertheless I still tried this complex query with /v2/meters
by following /v2/query/samples example and it was returning 404 Not found. Plz
correct me if I am doing something wrong here.
curl -X POST -H 'X-Auth-Token:eed134b917914fd987e50d8ec1651213' -H
'Content-Type: application/json' -d '{"filter" : "{\"or\":[{\"=\":
{\"project_id\": \"f28d2e522e1f466a95194c10869acd0c\"}},{\"=\":
{\"project_id\": \"d41cdd2ade394e599b40b9b50d9cd623\"}}]}}'
"http://10.11.10.1:8777/v2/query/meters";
Thanks
Srikanth
-----Original Message-----
From: Eoghan Glynn [mailto:[email protected]]
Sent: Monday, October 12, 2015 4:38 AM
To: OpenStack Development Mailing List (not for usage questions)
Subject: Re: [openstack-dev] [Ceilometer] Meter-list with multiple filters in
simple query is not working
> Hi
>
> Can anyone plz help me on how to specify a simple query with multiple
> values for a query field in a Ceilometer meter-list request? I need to
> fetch meters that belongs to more than one project id. I have tried
> the following query format, but only the last query value (in this
> case, project_id=
> d41cdd2ade394e599b40b9b50d9cd623) is used for filtering. Any help is
> appreciated here.
>
> curl -H 'X-Auth-Token:<token>'
> http://localhost:8777/v2/meters?q.field=project_id&q.op=eq&q.value=f28
> d2e522e1f466a95194c10869acd0c&q.field=project_id&q.op=eq&q.value=d41cd
> d2ade394e599b40b9b50d9cd623
>
> Thanks
> Srikanth
By "not working" you mean "not doing what you (incorrectly) expect it to do"
Your query asks for samples with aproject_id set to *both* f28d.. *and* d41c..
The result is empty, as a sample can't be associated with two project_ids.
The ceilometer simple query API combines all filters using logical AND.
Seems like you want logical OR here, which is possible to express via complex
queries:
http://docs.openstack.org/developer/ceilometer/webapi/v2.html#complex-query
Cheers,
Eoghan
__________________________________________________________________________
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: [email protected]?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
__________________________________________________________________________
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: [email protected]?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
