in this test scenario, dir 2077 was empty and the ...
# suitescriptc
Craig
03/07/2024, 9:32 AMin this test scenario, dir 2077 was empty and the file was in 2078. If I delete the file in 2078, and place the file in 2077, the code picks up the file in 2077 as expected.
If the file is in both dirs, it prefers the sub-dir 2078.
c
creece
03/07/2024, 10:30 AMTry a folder search not file and use a file.name/file.internalid join as a column.
c
Craig
03/07/2024, 2:35 PMI'll give this a try later - thanks.
a
Anthony OConnor
03/07/2024, 5:30 PMI wasn't aware there WAS a file search? I thought you HAD to do folder searches?
Anthony OConnor
03/07/2024, 5:30 PMc
Craig
03/07/2024, 5:52 PM@Anthony OConnor surprised it doesn't throw an error
Craig
03/07/2024, 5:54 PMThis is why it's better to use search.Type.xxx instead of a string.
a
Anthony OConnor
03/07/2024, 6:16 PMi mean there clearly is a file search cos it DIDNT throw the error, but it isn't documented so I wouldn't trust it
Anthony OConnor
03/07/2024, 6:18 PM... err well actually apparently it is ... somewhat documented?
https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2023_1/script/record/file.html
c
Craig
03/07/2024, 6:18 PMRegardless, it certainly doesn't work the way you think it should
Craig
03/07/2024, 6:18 PMIt will happily traverse sub-directories
Craig
03/07/2024, 6:24 PMSomeone else has been here already it seems: https://stackoverflow.com/questions/66172356/searching-for-files-using-search-create-in-suitescript-2-0
a
Anthony OConnor
03/07/2024, 6:32 PMcan you change your folder structure...
filesToProcesss
---Processed
to
ProcessName
---Pending
---Processed
That way they aren't in each others subfolders
Anthony OConnor
03/07/2024, 6:33 PMkinda hacky but might be the quickest way to be able to move on with your life 🙂
c
creece
03/07/2024, 6:49 PMA folder search should work fine. You know the folder ID and the file name you can search on all of that. I have this exact code in my projects
c
Craig
03/07/2024, 6:50 PMI'll change it to that