Where does dashboard data exist in YF config db?

Hi Dillon,

Thanks for reaching out to support with your question.

You can find the dashboard data in the reportgroup table. I believe you can llink reports up to this table via the reportgroupentity table.

Hope this helps!

Thanks, Eric

Hi Eric,

Based on your comment, my expectation of what is stored in reportgroupentity doesn't align with what I'm seeing.

I have a dashboard (group id = 142767), that contains a single entity id in reportgroupentity (id = 142768). This dashboard contains a report (report id = 142665).

I don't see anything I can use in reportgroupentity to join to reportheader to ultimately get from reportgroup --> reportheader. Is there another mapping table for entities I need to use? Naming-wise, I don't see anything that sticks out in the db.

Thanks

Hi Dillon,

I was able to see a report id defined in the reportgroupentity table for a dashboard tab that included the report - here was my process -

Made a dashboard with TEST report - reportid - 104743

This dashboard is in the reportgroup table - subtab groupid - 104766

In reportgroupentity I can see report 104743 defined as an "entity" of groupid 104766 -

Perhaps it's as simple of looking up the subtab versus the main dashboard groupid in this case? Let me know if I'm missing something here.

Thanks,

Eric

Hi Dillon,

Just wanted to check in to see how you made out on this?

Thanks,

Eric

Hi Dillon,

I'm going to go ahead and mark this question as Answered due to inactivity at this time. Feel welcome to reach out in the future.

Thanks,

Eric