Filter on nested resource


#1

Hi guys !

I seek to get the vms that will be available soon thank the schedule time.

So I search with

manageiq/api/provision_requests?expand=resources,options&attributes=schedule_time&filter[]=approval_state=approved

This don’t list me schedule_time but all provision_requests resources properties.

So, I’ve tried

manageiq/api/provision_requests?expand=resources,options&attributes=options.schedule_time&filter[]=approval_state=approved&filter[]=options.schedule_time%3C2016-02-02T15:23:16+01:00

It’s also fail with

{
    "error": 
    {
        "kind": "bad_request",
        "message": "attribute options.schedule_time does not exist",
        "klass": "ApiController::BadRequestError"
    }
}

Someone have an idea how I can get provision_requests where options[schedule_time] < 2016-02-02T15:23:16+01:00?

Thank you a lot !


#2

@gmccullough can you assist @alex-lairan with this question, or forward to a SME.


#3

Hello guys,

Did you had a chance to investigate ?

Let me know if there is something I can do to help you guys.

Thanks a lot.