hi, I'm just starting to learn suiteql and having an issue with adding a custom "Other Sublist Record" field of type "Bill of Materials Revision Component". I'm using the table BomRevisionComponent. Here's my query:
SELECT
BomRevisionComponent.bomRevision,
BomRevisionComponent.bomQuantity,
BomRevisionComponent.displayName,
BomRevisionComponent.id,
BomRevisionComponent.item,
BomRevisionComponent.itemSource,
BomRevisionComponent.quantity,
BomRevisionComponent.units,
BomRevisionComponent.custrecord_tst_buildableqty
FROM
BomRevisionComponent
WHERE BomRevisionComponent.bomRevision=1814
Here's the error message I'm getting.
Search error occurred: Field 'custrecord_tst_buildableqty' for record 'BomRevisionComponent' was not found. Reason: NOT_EXPOSED - Not available for channel SEARCH