Where does jira store the last accessed dashboard

[Sridhar Nimmagadda]

I wan't to reset the users to default to a dashboard, instead of loading the dashboard what they last accessed.

I see tis as an option to reduce unnecessary load on the JIRA server .

[Fabio Racobaldo _Herzum_ · Accepted solution]

Hello,

JIRA stores that information into the following table userhistoryitem.

+------------+---------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+------------+---------------+------+-----+---------+-------+

| ID | decimal(18,0) | NO | PRI | NULL | |

| entitytype | varchar(10) | YES | MUL | NULL | |

| entityid | varchar(60) | YES | | NULL | |

| USERNAME | varchar(255) | YES | | NULL | |

| lastviewed | decimal(18,0) | YES | | NULL | |

| data | longtext | YES | | NULL | |

+------------+---------------+------+-----+---------+-------+

There's a specific entitytype "Dashboard" and the entityid is the id of the related dashboard.

Hope this helps,

Fabio

[Sridhar Nimmagadda]

Thanks for the help !!

Query for getting the list of last accessed dashboards of all the users

select u.entityid ,u. username from userhistoryitem u where u.entitytype = 'Dashboard' group by u.username, u.lastviewed,entityid having u.lastviewed = max(u.lastviewed)

get the actual dashboard name form portalpage table

select * from portalpage where id = <u.entityid>

[Fabio Racobaldo _Herzum_]

well done. Please, mak my answer as accepted.

Regards,

Fabio