trying to fetch parent department of a department....
# suitescriptr
raghav
03/10/2022, 2:03 PMtrying to fetch parent department of a department.
Can someone help me fix the syntax of lookupField
Copy code
var fieldLookUp = search.lookupFields({
type: search.Type.DEPARTMENT,
id: i_department,
columns: ['parent']
});e
eliyahu moskowitz
03/10/2022, 3:22 PMlooks good, except i_department is a variable, right?
r
raghav
03/10/2022, 3:57 PMYes.
For some reason it's not allowing 'parent' as column ID. Not sure why.
b
battk
03/10/2022, 8:01 PMfields and columns are not required to be the same between searches and records
battk
03/10/2022, 8:01 PMthe parent is not available as a search column
battk
03/10/2022, 8:02 PMyou can the columns available while creating the search in the ui