NickSuite
12/16/2022, 2:43 PMMatt Bernstein
12/16/2022, 4:19 PMselect
location,
builtin.DF(location)
from
transactionLine
WHERE
BUILTIN.DF(location) = 'xxx'
you could also join directly join onto the location table
select
location,
builtin.DF(location),
location.name
from
transactionLine
inner join location on transactionline.location = location.id
WHERE
location.name = 'xxx'
NickSuite
12/16/2022, 5:43 PM