Hey developers, some non-developers, have you ever thought of where the heck the queries are of List View and Sub panels?
Let me give you the file names and function names.
List View:
- Go to include/ListView/ListViewData.php
- Search for function getListViewData
- Scroll down until you see $main_query = $ret_array[‘select’] . $params[‘custom_select’] . $ret_array[‘from’]
- Right below that you can print the query for List View.
Sub Panel:
- Go to data/SugarBean.php
- Search for function get_union_related_list
- Go to the end of the function and before it returns the result echo $final_query to see the queries of subpanels.
Hope this helps and feels like missing piece is just found!
Feel free to drop your comments.
Your valuable feedback means a lot.
You can contact us at [email protected]
Thank you.