Hey y'all, we're trying to programmatically access...
# suitescriptj
Jonathan Allen
11/11/2025, 2:15 PMHey y'all, we're trying to programmatically access attached files for a list of expenses; this expense list is generated by querying a saved search via suitescript. Is there any identifier we can return from a saved search to look up in the N/file Module if it has any file attachments? Also open to alternative ideas about how we can find attached files for an expense.
a
Anthony OConnor
11/11/2025, 4:04 PMyou just need a filter to join to the file
Copy code
search.createFilter({
name: 'internalidnumber',
join: 'file',
operator: search.Operator.ISNOTEMPTY
}),j
Jonathan Allen
11/11/2025, 5:07 PMthank you! is there any documentation on what kind of values this returns?
a
Anthony OConnor
11/11/2025, 5:12 PMits a filter? it doesn't return a value 😄
Anthony OConnor
11/11/2025, 5:14 PMthese are the columns I also add, i think they're pretty self explanatory?
Copy code
columns: [
search.createColumn({
name: 'internalid',
join: 'file'
}),
search.createColumn({
name: 'documentsize',
join: 'file'
}),
search.createColumn({
name: 'name',
join: 'file'
})
]2 Views