how to create a join using query module for a custom field
a
Arham Momin
12/27/2022, 5:30 PM
Its present in documentation you can follow up N/query module
r
Robert Vice
12/27/2022, 6:27 PM
documentation is pretty good for this, although the example for "right join" is actually the same as "left join"
s
Surapaneni 377
12/28/2022, 4:38 AM
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
battk
12/28/2022, 5:34 AM
usually you want to use the records catalog to see which joins are available, and the direction to use
battk
12/28/2022, 5:36 AM
but if you are absolutely sure that you are using the right field, then there is only really Query.joinFrom