Suite Analytics Application Folder column has no consistency?
I’m trying to use “Application Folder” to filter out certain folders and subfolders in a few queries. This was going okay until I noticed that the format for the column has no discernable consistency to its format. It sometimes uses “:” but other times uses “/” and sometimes both and while it appears to always have the full directory path it sometimes doesn’t start at the base folders
I know there are also ways to ask for certain formats and contexts using suitescript but the only one that works is “RAW” and all others give “Unexpected Error”
Can anyone explain how netsuite formats this column or does it just do whatever it wants?