1 Reply Latest reply on May 12, 2014 1:30 PM by wollardj

    Using the REST API to find tickets for an asset.

    wollardj

      Finding the asset.id with the serial number or asset number is easy enough, but now I'd like to do a query to find out what tickets might be open for a given asset.id. It seems like I should be able to do something like qualifier=(assets.id %3d 1234), but that returns the following error:

       

      sqlStringForKeyValueQualifier: attempt to generate SQL for com.webobjects.eocontrol.EOKeyValueQualifier (asset.id = 1234) failed because attribute identified by key 'asset.id' was not reachable from from entity 'JobTicket'.

       

      I suspect the error is referring to the fact that assets within a ticket is an array, not an object. However, I don't see how to access those fields in an array. In a document based database, "assets.id" would work for an array of objects, so it makes sense to me that it would work here. Since it doesn't, what should I be using? Is this type of query even supported right now?