Jaspersoft Studio query

Hello,

I´m not savvy on SQL querys and I´m having difficulties trying to get data from an attribute with a lookup type. I searched around and cant find a clear answer.

I have a “Switch” class where I maintain a switch devices inventory, each switch card has a field called “Status” which is actually a lookup type, If I do a jasper studio report and query on the status field I get unrelated values instead the defined ones (Active, Decommissioned).

Does anyone know how should I be writing my query? doing “Select Status from Switches” is not pulling the lookup type value.

Thanks in advanced.