:waving_white_flag: Is there not a column I can ad...
# suiteql
d
🏳️ Is there not a column I can add to my query that can be passed through as the type for
record.load
or
record.submitFields
? For example with an item I have "itemtype" as a query column, which results in "_InvtPart_". However the corresponding type is actually "_serializedinventoryitem_" (from
record.Type.SERIALIZED_INVENTORY_ITEM
) Looking at the record, "baserecordtype" has what I want ("_serializedinventoryitem_"), but isn't a field in the records catalogue.
question answered 1
t
@David B There's a "IsSerialItem" boolean column that you can use to determine if the item is serialized. I think you'd have to use that to determine the enumerated recordtype value.
d
That helps, thank you. Using something like this now:
Copy code
const prefix = islotitem ? 'lotnumbered'
             : isserialitem ? 'serialized'
             : '';
const type = prefix + itemType;