Sam L
09/07/2021, 10:48 AMBrendon Parker
09/08/2021, 7:13 PMREMOVED - Field is removed
I'm wondering if it is permissions related?
SQL:
SELECT
T1.id,
MAX(T4.shipmethod) as shipmethod
FROM transaction T1
INNER JOIN customer T2 ON T1.entity = T2.id
INNER JOIN cashrefundshippingaddress T3 ON T1.shippingaddress = T3.recordowner
INNER JOIN transactionline T4 ON T1.id = T4.transaction
INNER JOIN transaction T5 ON T4.createdfrom = T5.id
INNER JOIN customeraddressbook T6 ON T1.shippingaddress = T6.addressbookaddress
WHERE
T1.type = 'ItemShip'
AND T1.status IN ('A', 'B')
AND T4.mainline = 'T'
GROUP BY T1.id
Error:
Invalid search query. Detailed unprocessed description follows. Search error occurred: Field 'shipmethod' for record 'transactionLine' was not found. Reason: REMOVED - Field is removed\n.