[#ZBXNEXT-4048] Allow add custom graphs to Favourite graphs

Comment by Oleg Vedeneev [ 2018 Aug 22 ]

It would be nice also to be able to add to favourites custom screens, for example ones created from graph prototypes.

Comment by Oleksii Zagorskyi [ 2023 Jun 13 ]

Just for a record, transactions to insert and delete a host graph to favorites list, in zabbix 4.0:

BEGIN
SELECT p.value_id,p.source FROM profiles p WHERE p.userid=1 AND p.idx='web.favorite.graphids' ORDER BY p.profileid
SELECT i.nextid FROM ids i WHERE i.table_name='profiles' AND i.field_name='profileid'
UPDATE ids SET nextid=nextid+1 WHERE table_name='profiles' AND field_name='profileid'
SELECT i.nextid FROM ids i WHERE i.table_name='profiles' AND i.field_name='profileid'
INSERT INTO profiles (profileid, userid, idx, value_id, type, source) VALUES (821, 1, 'web.favorite.graphids', '520', 1, 'graphid')
COMMIT

BEGIN
DELETE FROM profiles WHERE userid=1 AND idx='web.favorite.graphids' AND value_id='520' AND source='graphid'
COMMIT

And for a simple graph (from Latest data):

BEGIN
SELECT p.value_id,p.source FROM profiles p WHERE p.userid=1 AND p.idx='web.favorite.graphids' ORDER BY p.profileid
SELECT i.nextid FROM ids i WHERE i.table_name='profiles' AND i.field_name='profileid'
UPDATE ids SET nextid=nextid+1 WHERE table_name='profiles' AND field_name='profileid'
SELECT i.nextid FROM ids i WHERE i.table_name='profiles' AND i.field_name='profileid'
INSERT INTO profiles (profileid, userid, idx, value_id, type, source) VALUES (825, 1, 'web.favorite.graphids', '29158', 1, 'itemid')
COMMIT

BEGIN
DELETE FROM profiles WHERE userid=1 AND idx='web.favorite.graphids' AND value_id='29158' AND source='itemid'
COMMIT

[ZBXNEXT-4048] Allow add custom graphs to Favourite graphs Created: 2017 Aug 23 Updated: 2023 Jun 13
Status:	Open
Project:	ZABBIX FEATURE REQUESTS
Component/s:	Frontend (F)
Affects Version/s:	3.2.7
Fix Version/s:	None

[ZBXNEXT-4048] Allow add custom graphs to Favourite graphs Created: 2017 Aug 23 Updated: 2023 Jun 13