Which Table Are The Datasets Stored On?

[JosephW1]

Hello,

I am trying to find the table that datasets are stored on and view it in list view. For example, reports are stored on the sys_report table, dashboards are stored on the pa_dashboards table, and dashboard tabs are stored on the pa_m2m_dashboard_tabs table.

Well, which table are datasets stored on? Thanks!

Kind Regards,

Joseph 

[Matt Taylor - G · Accepted solution]

You could try checking the sys_report_layer table. The field named "Series name text" should be the name of the dataset

[JosephW1]

@Matt Taylor - CloudPires I just took a look in the table you mentioned and noticed many datasets that I have created.

You hit the nail on the head! Wonderful, thank you! This will give me the ability to audit the filters of my datasets without having to load each one separately in the report editor. This may save me dozens of page loads.