hello there. I'm trying to write a query to outpu...
# suiteql
s
hello there. I'm trying to write a query to output some Item Fulfillments, and as you may know when joining to Transaction Lines we get multiple lines that don't represent actual lines on the fulfillment. (I believe these are cogs, shippinglines, taxline etc.) I've found a fulfillable column which can be used to filter out those not covered by fields like isCogs, taxLine etc., but would anyone have a recommendation for building a query with the same amount of lines as found on the fulfillment record?