Unable to dot walk to Device Type field of Product model table from AlM Hardware table

[Ajay37]

I am trying to filter the records based on Device Type field of the Product Model table. For this I am trying to dot walk from alm_hardware>cmdb_hardware_product_model>device type field. But I am unable to see that field in Model related fields. How to achieve this?

[NeoOndaro]

I know this is late, but it's because the field you are looking for doesn't live on the cmdb_model table. The fields you see there are the fields that live there. the core model fields.. The field you are looking for actually lives on the cmdb_hardware_product_model table which is a table extended from the model field. If you are are a list view you can
1) Add the field to your default list view.
Configure List view.
Click Model field to expand. Then scroll down until you are past the model fields and in to the table/fields that are extended from Model (they will be in red). You should be able to find your field down there.
2) if you are in a list view and adding conditions, you can add the condition by (going to the bottom and select Related fields (if you havn't already) then re open dropdown and selectModel->Product Model. Then reopen the drop down again and scroll down past the standard fields to the extended tables (they will be entires that will look like "Hardware Model [+]" . Pick that then select your dropdown again and you should be able to find your custom field.