tdietrich
09/12/2021, 5:34 PMSELECT
Transaction.TranID,
Transaction.TranDate,
TransactionLine.Location,
BUILTIN.DF( TransactionLine.Location ) AS LocationName
FROM
Transaction
INNER JOIN TransactionLine ON
( TransactionLine.Transaction = Transaction.ID )
AND ( TransactionLine.MainLine = 'T' )
WHERE
( Transaction.Type = 'SalesOrd' )
Alan Fitch
09/13/2021, 10:50 AMAlan Fitch
09/13/2021, 10:52 AMWITH cte (col1, col2) AS
(
SELECT 1, 2
UNION ALL
SELECT 3, 4
)
SELECT col1, col2 FROM cte
but it gives me an errorAlan Fitch
09/13/2021, 11:13 AMstalbert
09/14/2021, 3:59 PMjen
09/14/2021, 10:40 PMcustrecord_sn_allowed_entities
. I assume there is a mapping table somewhere for this, so I tried joining to map_customrecord_stick_note_entity
but that doesn’t seem to exist. Anyone know how to look up the names of tables in SuiteQL if they are from a bundle and don’t appear in Records Browser?Loïc Beaujean
09/15/2021, 6:11 AMDmitry Masanov
09/15/2021, 11:51 AMDavid B
09/17/2021, 2:39 AMautoJoin()
, createCondition()
, createColumn()
, etc)?NickSuite
09/20/2021, 8:05 PMSELECT id, custbody_url FROM transaction WHERE recordtype is INVOICE AND mainline is true AND custbody_url is null AND custbodyc_sftransid is NOT NULL FETCH FIRST 15 ROWS ONLY
jen
09/20/2021, 11:38 PMTim Kramer
09/21/2021, 3:34 PMtdietrich
09/21/2021, 4:47 PMTim Kramer
09/21/2021, 5:15 PMtdietrich
09/21/2021, 6:55 PMSELECT
Item.ID,
ItemVendor.Vendor,
Item.ItemID,
Item.DisplayName,
BUILTIN.DF( Item.Class ) AS Category,
Item.Description,
Item.Cost AS PurchasePrice,
ROUND( Item.AverageCost, 2 ) AS AverageCost,
ROUND( Item.LastPurchasePrice, 2 ) AS LastPurchasePrice,
Item.TotalQuantityOnHand,
Item.SeasonalDemand,
Item.DemandModifier,
Item.Manufacturer,
Item.MPN,
Item.IsDropShipItem,
Item.IsSpecialOrderItem,
InventoryItemLocations.Location,
BUILTIN.DF( InventoryItemLocations.Location ) AS LocationName,
InventoryItemLocations.QuantityOnHand AS LocationQuantityOnHand,
InventoryItemLocations.ReorderPoint AS LocationReorderPoint,
InventoryItemLocations.QuantityAvailable AS LocationQuantityAvailable,
InventoryItemLocations.PreferredStockLevel AS LocationPreferredStockLevel,
InventoryItemLocations.QuantityCommitted AS LocationQuantityCommitted,
InventoryItemLocations.QuantityBackOrdered AS LocationQuantityBackOrdered,
InventoryItemLocations.QuantityOnOrder AS LocationQuantityOnOrder
FROM
ItemVendor
INNER JOIN Item ON
( Item.ID = ItemVendor.Item )
INNER JOIN InventoryItemLocations ON
( InventoryItemLocations.Item = ItemVendor.Item )
WHERE
( ItemVendor.PreferredVendor = 'T' )
AND ( Item.ItemType = 'InvtPart' )
AND ( Item.IsInactive = 'F' )
AND ( InventoryItemLocations.Location IN ( 1, 6 ) )
ORDER BY
Item.ItemID,
LocationName
Tim Kramer
09/21/2021, 9:51 PMTim Kramer
09/21/2021, 9:52 PMTim Kramer
09/21/2021, 9:52 PMTim Kramer
09/21/2021, 9:52 PMTim Kramer
09/21/2021, 9:52 PMTim Kramer
09/21/2021, 9:53 PMTim Kramer
09/21/2021, 9:58 PMTim Kramer
09/21/2021, 9:58 PMClay Roper
09/21/2021, 10:12 PMTim Kramer
09/21/2021, 10:18 PMAlli Deacon
09/22/2021, 2:03 PM{"function":"suiteQLRun","sql": "SELECT * from item where itemid = '10092783' or upccode = '10092783' and BUILTIN.DF(isinactive) = 'F'" }
However it is returning records where isinactive = 'T'
, even when that BUILTIN.DF(isinactive)
in the select clearly returns a 'T'
. Any ideas? TIA!Mark Christensen
09/22/2021, 7:31 PMtdietrich
09/22/2021, 7:51 PMsmoke raven
09/22/2021, 10:22 PMscottvonduhn
09/23/2021, 4:44 PM'2021-02-01 11:00:00.0'
, '2021-02-01 11:00:00',
'2021-02-01 11:00'
and even '2021-02-01'
but always get a Failed to retrieve data
error with the query.