When querying the

script

table is there any simple way to determine which are from bundles? I feel like the only way would be to look at the associated

file

and go up the tree of folders to see the root folder, which is ….. not ideal.

Can you use the script’s file ID and join to the file table where bundleable = T? That should tell you that its part of a bundle.

SELECT
   script.name,
   file.bundleable
FROM
   script
INNER JOIN
   file ON script.scriptfile = file.id AND file.bundleable = 'T'

Unfortunately not.

bundleable

is not T for many files that are part of bundles.