Can anyone spot what might be wrong with this quer...
# suiteqla
Aaron Lozier
06/18/2021, 3:20 PMCan anyone spot what might be wrong with this query? I am getting the helpful
Invalid or unsupported search Copy code
SELECT Transaction.ID, TrackingNumber.trackingnumber
FROM Transaction
INNER JOIN TransactionLine ON TransactionLine.Transaction = Transaction.ID
INNER JOIN TrackingNumber ON TrackingNumber.ID = Transaction.trackingnumberlist
WHERE TransactionLine.CreatedFrom = '4048581' AND Transaction.Type = 'ItemShip'Aaron Lozier
06/18/2021, 4:21 PMAgain, answered my own question, sort of. The
BUILTIN.DF Copy code
SELECT Transaction.ID, BUILTIN.DF(Transaction.trackingnumberlist) as TrackingNumberList
FROM Transaction
WHERE Transaction.Type = 'ItemShip'
AND Transaction.ID = 4048681Aaron Lozier
06/18/2021, 4:22 PMHowever, it would still be nice to know why the join doesn't work
t
tdietrich
06/18/2021, 7:27 PM@Aaron Lozier This is rough, but it shows the joins that are needed to get from an item fulfillment down to the shipments and packages:
tdietrich
06/18/2021, 7:27 PM Copy code
SELECT
Transaction.ID,
Transaction.TranID,
Transaction.TranDate,
BUILTIN.DF( Transaction.Entity ) AS Entity,
TransactionShipment.*,
ShipmentPackage.TrackingNumber
FROM
Transaction
INNER JOIN TransactionShipment ON
( TransactionShipment.Doc = Transaction.ID )
INNER JOIN ShipmentPackage ON
( ShipmentPackage.ItemFulfillment = Transaction.ID )
WHERE
Transaction.Type = 'ItemShip'
AND RowNum < 10👏 1
2 Views