I have a weird sql result. This query works fine.
...
# suiteqlc
Chris
05/22/2025, 2:53 PMI have a weird sql result. This query works fine.
Copy code
select t.id, t.createddate, cc.transactionline, cc.standardcost
from transaction t
inner join TransactionAccountingLineCostComponent cc on cc.transaction = t.id
where t.id = 84064869
and t.recordtype = 'inventorycostrevaluation' Copy code
[
{
"id": 84064869,
"createddate": "4/29/2025",
"transactionline": 1,
"expr1": 160.54666055666667
},
{
"id": 84064869,
"createddate": "4/29/2025",
"transactionline": 2,
"expr1": 160.37890055666668
}
]whereand cc.transactionline = 2Chris
05/22/2025, 2:59 PMEek.. just had to rubber duck it here.
BUILTIN.DF()a
Anthony OConnor
05/22/2025, 3:10 PMcan you put the working query syntax here please? I thought that builtin stuff was just for how things are output, didn't realize it would effect where clauses
c
Chris
05/22/2025, 3:12 PM Copy code
select t.id, t.createddate, cc.transactionline, cc.standardcost
from transaction t
inner join TransactionAccountingLineCostComponent cc on cc.transaction = t.id
where t.id = 84064869
and t.recordtype = 'inventorycostrevaluation'
and BUILTIN.DF(cc.transactionline) = 2Chris
05/22/2025, 3:12 PMFor some reason the DB doesn't see the 2 as a 2. It sees something else...
a
Anthony OConnor
05/22/2025, 3:20 PMoh can you try
and cc.transactionline = '2'c
Chris
05/22/2025, 3:20 PMDoesn't work
a
Anthony OConnor
05/22/2025, 3:20 PMvery interesting, thanks for sharing
👍🏻 1
5 Views