MxLoader

Are you using the REST based approach or the default OS (which uses the SOAP API)? You can see that on the Config tab. It changes how the data is retrieved which is why I'm asking.

Also, are you trying to just return the specific spec mentioned (in this case MANUFACTURER) or the assets that have that specification? If it's the latter and you're using the OS (SOAP), when you provide the query (in the D1 column) it's executing a SQL query. So for your example, to query the assetspec you would want to add something like this to your query:

exists(SELECT 1 FROM assetspec WHERE asset.assetnum=assetspec.assetnum and asset.siteid=assetspec.siteid and assetspec.assetattrid='MANUFACTURER')

If you're using the REST based approach, you need to use the oslc.where format which would look like this:

assetspec.assetattrid="MANUFACTURER"

Both of those would return all assets (and all their specs) if it has that specification. With the REST API it's possible to apply a filter on the child object (to reduce the data displayed to just the spec you want for example) but I'm not sure if that works with MXLoader today. 

Are you using the REST based approach or the default OS (which uses the SOAP API)? You can see that on the Config tab. It changes how the data is retrieved which is why I'm asking.

Also, are you trying to just return the specific spec mentioned (in this case MANUFACTURER) or the assets that have that specification? If it's the latter and you're using the OS (SOAP), when you provide the query (in the D1 column) it's executing a SQL query. So for your example, to query the assetspec you would want to add something like this to your query:

exists(SELECT 1 FROM assetspec WHERE asset.assetnum=assetspec.assetnum and asset.siteid=assetspec.siteid and assetspec.assetattrid='MANUFACTURER')

If you're using the REST based approach, you need to use the oslc.where format which would look like this:

assetspec.assetattrid="MANUFACTURER"

Both of those would return all assets (and all their specs) if it has that specification. With the REST API it's possible to apply a filter on the child object (to reduce the data displayed to just the spec you want for example) but I'm not sure if that works with MXLoader today.