# Custom charts query

**URL:** <https://forum.radsystems.io/t/custom-charts-query/370>\
**Category:** PHPRad Classic\
**Created:** [June 29, 2021, 6:15am UTC](https://forum.radsystems.io/t/custom-charts-query/370 "2021-06-29T06:15:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Arty](https://forum.radsystems.io/letter_avatar_proxy/v4/letter/a/3ab097/32.png) [@Arty](https://forum.radsystems.io/u/Arty)\
**Post date:** [June 29, 2021, 6:15am UTC](https://forum.radsystems.io/t/custom-charts-query/370/1 "2021-06-29T06:15:41Z")

</div>

Good day,

In your previous version of PHPRad you could customize SQL query for charts. In RadSystems Studio you can only select table. Are you planning to add this function back in future updates or I didn`t notice something?

With great respect,  
Arty

 ![new-old](https://forum.radsystems.io/uploads/default/original/1X/933185d882047d5efa3a3052aae31ba3e80fac17.jpeg)

---

<div class="post-metadata">

**Author:** ![willvin](https://forum.radsystems.io/user_avatar/forum.radsystems.io/willvin/32/7_2.png) [@willvin](https://forum.radsystems.io/u/willvin)\
**Post date:** [June 29, 2021, 3:48pm UTC](https://forum.radsystems.io/t/custom-charts-query/370/2 "2021-06-29T15:48:07Z")

</div>

@Arty you can create a **Database View** or **Custom View** and then select it as a **TableName** in the chart.

---

<div class="post-metadata">

**Author:** ![Arty](https://forum.radsystems.io/letter_avatar_proxy/v4/letter/a/3ab097/32.png) [@Arty](https://forum.radsystems.io/u/Arty)\
**Post date:** [June 30, 2021, 7:34am UTC](https://forum.radsystems.io/t/custom-charts-query/370/3 "2021-06-30T07:34:39Z")

</div>

Thank you  
I will try.

 ![create](https://forum.radsystems.io/uploads/default/original/1X/d8dd2204ae13c3fd54bbdcc14619421726026b86.png)