Can I get a list of script deployments that includ...
# ask-stanley-ai
d
Can I get a list of script deployments that include X role using SuiteQL or a Saved Search?
c
AI generated answer (using internal Slack threads):
Yes, you can get a list of script deployments that include a specific role using SuiteQL or a Saved Search. However, it's important to note that this might not be straightforward as there isn't a direct link between script deployments and roles in the database schema. Here's a general approach you can take: 1. Create a Saved Search or SuiteQL query on the Script Deployment record. 2. Join this with the Script record. 3. Then join this with the Script File record. 4. Filter the results based on the role you're interested in. Please note that the role restriction might not be directly available in the script deployment or script record. You might need to use a client script to get the actual user's role and then query and set the list data on the client side. This approach might be a bit slower as it's client-side, but it's a workaround to achieve your goal. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.85949713
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.850585938
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.841491759
Please provide your feedback on this answer.