add new flag to each record of Sugar

[pravin.agham]

Hi All,


I want alert system or Flag system like email application , on sugar dashlets so Admin can know which record is New or unread and which record is old or read.

In simple way the record which is Unread will be display in BOLD and those record which is Read will displayed in normal font.

Hope you understand my problem

Can anybody help me on this


Regards,
Pravin

[kinshibuya]

Hi All,


I want alert system or Flag system like email application , on sugar dashlets so Admin can know which record is New or unread and which record is old or read.

In simple way the record which is Unread will be display in BOLD and those record which is Read will displayed in normal font.

Hope you understand my problem

Can anybody help me on this


Regards,
Pravin

Hi there,

how do u plan to set a recod read or unread? using track module?
And would that be for each user?
i guess u can accomplish that using a controller for listview (will also extend to dashlet view)

[pravin.agham]

Hi there,

how do u plan to set a recod read or unread? using track module?
And would that be for each user?
i guess u can accomplish that using a controller for listview (will also extend to dashlet view)

Hi,

Thanks for reply.

Yes. That is for each user.
Each user can login and see unread records in Bold font and read record in normal Font.

I dont know about Tracking module. can you give me some idea how i accomplish this with the help of track module or other way..


Regards,
Pravin

[kinshibuya]

i believe the easiest way would be this:
1. creating an custom field (checkbox, via studio)to determine if the record was read or not.
2. creating and logickhook after_retrieve (this logic hook would be called when the user accessed the detailview of the record) to update the record and set the customfield = read.
3 update the get_list_view_data function to put one or more fields bold. (i just know how to accomplish it by changing 1 column, to change the hole row will require template customization)

If anyone has another idea plz share.

[pravin.agham]

but how could I manage it for all individual user,Is I have to create an table in which I store user id and record Id with status as read or unread?

I comes to know the Tracking table in Sugar Database in which it store the userId,Module name and record Id.

we can write a code to looks up the Record id against UserId in this table. If the match found then it means the record is read and if not means the record is unread.

How is comes up?

Any guess....

Regards,
Pravin

[kinshibuya]

i believe you could also accomplish it that way, im not a big fan of working with traking table,
but it can work. you can also use get_list_view_data to accomplish this

[pravin.agham]

Please give me any solution!!!

Help me out from this!!

Pravin