Can anyone think of why a user might be able to se...
# suitescript
e
Can anyone think of why a user might be able to see a file in File Cabinet, but not see it in results of a SuiteQL query. The SuiteScript code is running as Current User. The SuiteQL query looks like this:
Copy code
SELECT
			ID,
			Name,
			Description
		FROM
			File
		WHERE 
			( Folder = ? )
		ORDER BY 
			Name
j
weird. What happens when you do
Id = <whatever>
instead? Does the query return the result of the file?
just to rule out any issue with the folder
double check that
?
is an integer… just in case.
and that it’s the RIGHT integer