That's great to hear! I'm glad I could help. Custom charts can be a powerful way to visualize data and gain insights, so I hope this query helps you achieve your goals. If you have any other questions or if there's anything else I can help with, feel free to ask!

Yes, that's definitely possible! Here's an example GlideRecord query that should achieve that:

```

var taskGr = new GlideRecord('sc_task');

taskGr.addQuery('assignment_group', 'your_group_name_here');

taskGr.query();

var reqItemGr = new GlideRecord('sc_req_item');

var reqItemIds = [];

while (taskGr.next()) {

reqItemGr.addQuery('request', taskGr.getValue('request'));

}

reqItemGr.addQuery('stage', 'requested');

reqItemGr.query();

while (reqItemGr.next()) {

reqItemIds.push(reqItemGr.getValue('sys_id'));

}

var totalPriceGr = new GlideAggregate('sc_req_item');

totalPriceGr.addAggregate('SUM', 'total_price');

totalPriceGr.addQuery('sys_id', 'IN', reqItemIds);

totalPriceGr.query();

if (totalPriceGr.next()) {

var totalPrice = totalPriceGr.getAggregate('SUM', 'total_price');

gs.print('Total price: ' + totalPrice);

}

```

This query first queries the sc_task table to find all tasks assigned to your group, and then uses the request field to query the sc_req_item table to find all RITMs associated with those tasks. It then uses GlideAggregate to perform an aggregate function (SUM) on the total_price field of the sc_req_item records that meet the specified conditions. Let me know if you have any questions or if this helps!

Yes, I can definitely help with a GlideRecord query! Here's an example query that should achieve the same result as the SQL query I provided earlier:

```

var gr = new GlideAggregate('sc_req_item');

gr.addAggregate('SUM', 'total_price');

gr.addQuery('stage', 'requested');

gr.addQuery('request', 'IN', 'sc_task.request');

gr.addQuery('sc_task.assignment_group', 'your_group_name_here');

gr.groupBy('request');

gr.query();

if (gr.next()) {

var totalPrice = gr.getAggregate('SUM', 'total_price');

gs.print('Total price: ' + totalPrice);

}

```

This query uses GlideAggregate to perform an aggregate function (SUM) on the total_price field of sc_req_item records that meet the specified conditions. It also uses GlideRecord to join the sc_req_item and sc_task tables together based on the request field. Let me know if you have any questions or if this helps!

Thanks for the additional information! Based on what you've described, it sounds like you might need to use a join statement to link the sc_task and sc_req_item tables together. Here's an example query that might work:

```

SELECT SUM(sc_req_item.total_price)

FROM sc_req_item

JOIN sc_task ON sc_req_item.request = sc_task.request

WHERE sc_task.assignment_group = 'your_group_name_here'

AND sc_req_item.stage = 'requested'

```

This query should return the total sum of all sc_req_item records that are associated with an sc_task record assigned to your group, and that are in the 'requested' stage. Let me know if this helps or if you have any other questions!

Sure, I'd be happy to help! Can you give me some more information about the structure of the ServiceNow tables and the conditions you're working with? It might be helpful to see some sample data or a screenshot of the tables you're working with.

That sounds like a complex query, but it's great that you're taking on the challenge! Have you tried breaking down the problem into smaller steps or working with a colleague to brainstorm possible solutions? Sometimes it can be helpful to bounce ideas off of someone else when you're stuck on a difficult problem.

That's great to hear! It's always good to keep learning and improving your skills, especially in a field like programming where there's always something new to learn. Do you have any specific goals or projects that you're working on right now?

That's really interesting! It's great that you're taking the time to learn more about yourself and your emotions. Do you have any other favorite podcasts or resources that you like to use to help you learn and grow?

That's a great variety of music and podcasts! Coldplay is always a good choice for some uplifting tunes, and it's great that you're also interested in podcasts that can help you learn and grow. Have you learned anything interesting from Dr. Gabor Mate's podcast?

That sounds like a good way to balance getting some much-needed rest and staying productive during your workday. Do you have any favorite music or artists that you like to listen to while you eat?

I see, that makes sense. Do you have any tips for making the most of your lunch break when you're short on time? Do you prefer to eat quickly and get back to work, or do you try to take a few minutes to relax and recharge during your break?

I'm doing well, thank you for asking! Do you have any favorite lunch spots near your workplace? What do you usually like to eat for lunch?

Hello! How are you doing today? Is there anything interesting happening in your life that you'd like to share?

It's possible that the query is not returning any results due to the filter conditions. Here are a few things you can try to troubleshoot the issue:

1. Make sure that the `managerSysId` parameter is a valid sys_id of a manager in the `sys_user` table. You can verify this by checking the `sys_user` table directly.

2. Check the filter conditions in the `recurseUser` function to make sure they are correct. You can add some debug statements to print out the `filter` object and the encoded query to see if they match your expectations.

3. Try running the query directly in the `sys_user` table to see if it returns any results. This can help you identify any issues with the query conditions.

4. If the issue persists, you can try removing the `active` query condition temporarily to see if it's causing the issue. If the query returns results without the `active` condition, it's possible that there are inactive users in the hierarchy that are being filtered out.

I hope this helps you troubleshoot the issue. Let me know if you have any further questions!

I apologize for the confusion. It looks like there was a typo in my previous response. The function name should be `recurseUser` instead of `recurseUsers`. The updated function name should be:

```

function recurseUser(manager, level, maxLevel, userList) {

var emp = new GlideRecord('sys_user');

var filter = new GlideFilter('OR');

var filter1 = filter.addQuery('manager', manager);

var filter2 = filter.addQuery('sys_id', manager);

filter1.addOrCondition('sys_id', manager);

emp.addEncodedQuery(filter.getXML());

emp.addQuery('active', true);

emp.query();

while (emp.next()) {

userList.push(emp.getValue('sys_id'));

if (level + 1 <= maxLevel) {

recurseUser(emp.getValue('sys_id'), level + 1, maxLevel, userList);

}

}

}

```

Regarding the issue with the empty array, it's possible that the `userList` array is empty due to the query conditions. Make sure that the `managerSysId` parameter is a valid sys_id of a manager in the `sys_user` table, and that the manager has active subordinates up to the specified `maxLevel`.

Also, make sure that you're calling the `getSubordinates()` method correctly and passing in the `managerSysId` parameter. Here's an example of how you can call the method:

```

var myScriptInclude = new MyScriptInclude(); // Replace with the actual name of your script include

var managerSysId = '1234567890abcdef1234567890abcdef'; // Replace with the actual manager sys_id

var subordinates = myScriptInclude.getSubordinates(managerSysId);

// Do something with the subordinates list

```

If you're still having issues, please let me know and I can try to help you further.