Getting this error for some reason from this code:
if (configSettings.showchildinvoices == true) {
invoicefilter.push("AND", [["customermain.internalid","is", companyid],
"OR",
["customermain.parent", "is", companyid]]);
} else {
invoicefilter.push("AND", ["customermain.internalid","is", companyid]);
}
An nlobjSearchFilter contains an invalid join ID, or is not in proper syntax: internalid
b
battk
12/16/2020, 3:27 PM
is companyid valid?
n
Nick
12/16/2020, 3:40 PM
yes it is
b
battk
12/16/2020, 3:46 PM
filters look nomral
battk
12/16/2020, 3:46 PM
i would start the normal debugging process of hardcoding the companyid
battk
12/16/2020, 3:46 PM
and using only one of those filters at a time
n
Nick
12/16/2020, 3:48 PM
okay makes sense. I'll give that a try. thanks!
Nick
12/16/2020, 4:19 PM
The fix was changing it to customer.internalid and changing "is" to "anyof"