Get Subpanel Queries

SuiteCRM Forum - English Language Developer Collaboration
1

I have a question regarding how the subpanels are being shown and are queried. When I check the Network, it shows this request:

http://localhost/orion/index.php?module=Accounts&offset=1&stamp=1709076457023295400&return_module=Accounts&action=DetailView&record=8c502d0e-fe0d-7f74-10d4-6050f98272d1&ajax_load=1&Accounts_opportunities_CELL_offset=&inline=true&to_pdf=true&action=SubPanelViewer&subpanel=opportunities&Accounts_opportunities_CELL_ORDER_BY=account_name&layout_def_key=Accounts&inline=1&ajaxSubpanel=true&_=1709076435279

Is there any way to get the exact query of this? because the result is just the subpanel itself that do not have css.

2

What are you trying to do?

CRM & PHP version?

3

Hi @rsp, I wanted to get the query it used for the subpanels to show.

I have Version 7.11.21 and PHP 7.4.33

4

To inspect the query for subpanel check “data/SugarBean.php” you will have function called “get_union_related_list” check the variable “$final_query”

2 Likes
5

Apart from @sagarjaydeep 's tip, another approach is to make your logs show debug level and the query will come up in suitecrm.log

1 Like
6

Finally! Thank you so much

7

Thanks for the tip @pgr