Can I use the location name as the filter instead ...
# suiteql
n
Can I use the location name as the filter instead of the internal ID? If so, how? Do I need to use Builtin.DF?
m
yeah this seems to work for me
Copy code
select
  location,
  builtin.DF(location)
from
  transactionLine
WHERE
  BUILTIN.DF(location) = 'xxx'
you could also join directly join onto the location table
Copy code
select
  location,
  builtin.DF(location),
  location.name
from
  transactionLine
  inner join location on transactionline.location = location.id
  WHERE
  location.name = 'xxx'
n
Thank you @Matt Bernstein