how to create a join using query module for a cust...
# suitescript
s
how to create a join using query module for a custom field
a
Its present in documentation you can follow up N/query module
r
documentation is pretty good for this, although the example for "right join" is actually the same as "left join"
s
I tried using this but didnt work var DepartmentQuery = query.create({ type: query.Type.DEPARTMENT, }); var parentpracticeJoin = DepartmentQuery.join({ fieldId: "custrecord_practicehead", }); this join of customrecord is giving error Am I doing it right?
b
usually you want to use the records catalog to see which joins are available, and the direction to use
but if you are absolutely sure that you are using the right field, then there is only really Query.joinFrom
s
Thank you