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?
Never mind, I found a work around through the use of assets.assetNumber instead of assets.id.