Using SuiteQL, query all custom records related to a bundle if 123456

AI generated answer (using internal Slack threads):

To query all custom records related to a bundle using SuiteQL, you would need to join several tables together. Unfortunately, there is no direct way to do this as the bundle ID is not directly associated with custom records in the database. However, you can infer the relationship by looking at the scripts and script deployments related to the bundle. Here is a general approach: 1. Identify the scripts related to the bundle. You can do this by querying the

Script

table and filtering by the

BundleId

column. 2. Once you have the scripts, you can identify the custom records that these scripts interact with. This can be done by analyzing the script code, but this is not straightforward and would require parsing the script code to identify the custom record types it interacts with. Please note that this approach is not foolproof and may not capture all custom records related to a bundle, especially if the scripts do not directly interact with the custom records or if the interactions are complex. Here is a sample SuiteQL for the first step:

sql
SELECT scriptId, scriptFile 
FROM Script 
WHERE bundleId = '123456'

Please replace '123456' with your actual bundle ID. This will give you a list of scripts related to the bundle. Unfortunately, the second step of identifying the custom records from the script code is not straightforward and cannot be done using SuiteQL alone. You would need to manually analyze the script code or use a script parsing tool to identify the custom records. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******