I'm trying to convert an Inventory Number search into a SuiteQL but I am having problem implementing the filter isonhand = 'T'. I even tried converting a query but the filter below seems being skipped when converted to SuiteQL.

inventoryNumberQuery.condition = inventoryNumberQuery.createCondition({
                    fieldId: 'isonhand',
                    operator: <http://query.Operator.IS|query.Operator.IS>,
                    values: [true]
                });

Is there an alternative way on how can I filter serial numbers that is on hand?

How about

where inventorynumber.id in (select inventorynumber from inventorynumberlocation where inventorynumberlocation.quantityonhand > 0)