How Bookmark works?

Pratiksha Rane shared this idea 42 days ago
Idea Logged

We have added few reports as bookmark. After few days we noticed that those gets removed automatically.

For testing we marked 3 reports as Favorite and removed it again. We could see FAVADD entry is added in event table but delete entry is not there.

I wanted to know where we will get Favorite Delete /remove entry in YF table. Also how can we fin out that who has removed this bookmark.

Comments (15)

photo
1

Hi Pratiksha,

Thanks fore reaching out to support with your question. I will do a little research and see if I can get these answers for you. Will follow up shortly.

Thanks,

Eric

photo
1

Hi Pratiksha,


I'm doing some testing in 9.4.1 and I can see a FAVEADD entry in the DEBUG logs when adding a favorite, and there is no such event write on removing a favorite. So I think the way forward here would be to create a task for developers to add this "FAVEREMOVE" event write to the config db, with similar info to the FAVEADD event. Does this sound like the desired outcome here?

Thanks,

Eric

photo
1

Hi Eric,


How to create this task ? Is it verified earlier and working as expected ?


Regards

Pratiksha

photo
1

Hi Pratiksha,

I've gone ahead and created a developer task on your behalf to look into this functionality. Updates to the task will be provided here as they are available. I will in turn mark this ticket as Idea Logged for now. I am not sure if this functionality has existed previously, but I will try to find out for you.

Thanks,

Eric

photo
1

Hi Eric,

Thanks for the update.

I could see that some times FAVDELETE entries gets created in database. My question is how it gets added?


Here the requirement is to track whether the reports has been added to Favourite or not ? Is there any way to track this option in reports or by means of Export ?


Regards

Pratiksha

photo
1

Hi Eric,

Do you have any inputs on this ?


Regards

Pratiksha

photo
1

Hi Pratiksa,

Thanks for the update. Can you provide replication details on the differences needed to see the the FAVDELETE activity? I can update the task if I can create this type of entry.

The events table is where this activity would be tracked. If certain favdelete entries are not written, but others are, we'll have to approace the specifics of each scenario.

Thanks,

Eric

photo
1

Hi Eric,


We did not created these entries manually. If you want I can share the dump of those records from SR database where for few cases it's creating FAVDELETE task.


In a mean time could you please check if you have any inputs on "Here the requirement is to track whether the reports has been added to Favourite or not ? Is there any way to track this option in reports or by means of Export ?"


Thanks

Pratiksha

photo
1

Hi Pratiksha,

Thanks for the reply. If you could provide the dumps mentioned I'd appreciate it. In debug mode I see this activity -

YF:2021-02-03 11:32:38.679:DEBUG (EventManager) - [31] [A6082740] [/MIReportOutputAjax.i4] Entering createEvent()


resulting in this query -

INSERT SQL: 
INSERT INTO  Event (  EventId, EventTypeCode, GMTDateTime, IpSource, SessionId, FinancialTransactionValue, FinancialCommission, FinancialDestinationValue, FinancialTaxValue, EventTime, EventDate, EventCode, EventData, ReferenceId, UnitId, TomcatSessionId, ReasonCode, ReasonDescription, ContentId, LinkedUUID, GroupUUID) VALUES (276868,E'REPORT',20210203183238,5,E'127.0.0.1',0,0,0,0,0,'2021-02-03',E'FAVEADD',E'reportInstanceId=101453,report=100423',100423,1,E'A60827405C29803B2C656A0DA63E26F8',E'',E'',100423,E'',E'')

I see nothing like that when removing. If you can get this activity replicated and logged it would be very helpful. I'm wondering if maybe this is a web service or API call versus "un-clicking" the star in the UI like I am doing?

I see this process on deleting a favorite -

YF:2021-02-03 11:32:47.007:DEBUG (PersonFavouriteManager) - [36] [A6082740] [/MIReportOutputAjax.i4] Entering method deletePersonFavourite()
YF:2021-02-03 11:32:47.008:DEBUG (PersonFavouriteManager) - [36] [A6082740] [/MIReportOutputAjax.i4] PersonFavourite DELETE SQL: 
DELETE FROM PersonFavourite
WHERE ContentTypeCode = E'REPORTBOOKMARK'
AND IpPerson = 5
AND ContentId = 101453
AND FavouriteTypeCode = E'FAVOURITE'
AND CreateByCode = E'MANUAL'
AND TextEntityId = 0

Here is the selectpersonfavorite call prior to the delete call -


Entering method selectPersonFavourite()
YF:2021-02-03 11:32:46.958:DEBUG (PersonFavouriteManager) - [36] [A6082740] [/MIReportOutputAjax.i4] PersonFavourite SELECT SQL: 
SELECT IpPerson, ContentTypeCode, ContentId, LastAccessDate, StartDate,
   HitCount, CreateByCode, FavouriteTypeCode, ColumnNumber, WidthCode,
   SequenceNumber, PortletStatusCode, PortalHeight,
   CreatorId, TextEntityId, InstanceId, StartTimestamp
FROM PersonFavourite
WHERE IpPerson = 5
AND ContentTypeCode = E'REPORTBOOKMARK'
AND ContentId = 101453

You could use these queries to see existing bookmarks, but since the removed bookmarks are a doing DELETE statement, and there's no event entries (at least for me at this time), the info of "who deleted" is hard to get. I wonder if a better enhancement request would be to "mark bookmarks as deleted" like we do with reports for better auditing purposes, would this be preferable in your case?


Thanks,

Eric

photo
1

Hi Eric ,

Thanks for the update. Attached is the export of the reports for FAVDELETE activity.

Regards

Pratiksha

photo
1

Hi Pratiksha,

Thanks for the logs table. I was able to get these entries to appear, by removing a favorite report, as opposed to a report bookmark.


096b79a16fe7a554fdd5af61ddf0b967


So in this case I'd assume your entries are from similar actions, and as such, it looks like this event is cataloged for removing reports from favorites, but not bookmarks. Hopefully this will be a fairly easy and quick addition to the program on developers' end.

Hope this helps clear things up, it did for me!

Thanks,

Eric

photo
1

Hi Eric,

You mean to say that the entries for BookMark delete will not get captured in database. Also the Favourite and Bookmark both are different features.

Regards

Pratiksha

photo
1

Hi Pratiksha,

That's right - entries for bookmark delete do not get captured in the event table currently. I've created a developer task to look into including this type of log entry in a future version. I'll keep you updated via this thread.

Thanks,

Eric

photo
1

Hi Eric,


Thanks for the update. Could you please share the Task ID ?


Regards

Pratiksha

photo
1

H iPratiksha,

Task ID on this is YFN-21347.

Thanks,

Eric