Private Object Marks, Sign & Notes

Technically any system object could have user's defined private signs

• Set view to provide data for user
• Activate user sings in view
• Back-end server functionality
  • Get information about user reading object
  • User flags are automatically deleted
• Support at the database level
  • Support of the discussions

Users' signs, mark, notes and evaluations are all stored in single objects sysUserObjectSign. However, selections for clips and lists with object marks shall support that adding the fields to the view

Set view to provide data for user

Be careful that fields for this marks have special names that are not the same with names from the table. Always use the view fields names:

SELECT
   ...
   -- columns for flags and notes
   uos.uosMark, uos.uosFlag, uos.uosNote, uos.usrObjStatus
FROM
	left outer join syswUOSigns uos on 
      uos.uosUserID = u.sysUserID 
      AND uos.uosObjectName = ...systemObject
      AND uos.uosObjectID = ...ID

Activate user sings in view

View shows marks for object flags automatically when it has defied view parameter:

"parameters":{ "userSigns":true },

Back-end server functionality

Get information about user reading object

System object is created automatically when user first-time change the object flags. Typically there is object only when user set something, However, object is also used together with object notes to store information what object notes user already read. For notes the user notes are created automatically

However, modules could never user the sysUserObjectSign to store some user-related data about object. System module doesn’t guarantee that object is not deleted even when user already had values there.

User flags are automatically deleted

User defined object attributes are deleted in response to the message from the application server. Objects should raise the frm.objectDeleted system message. The message is captured by the system modules and deleted also the flags

All user’s flags are notes are automatically deleted when user’s account is deleted. They are not deleted for blocked user.

Support at the database level

User private notes are provided to the list of objects and object detail in the common views with the primary data. Private notes can be linked with external objects as well, but actually only in case that external object has numerical id.

Support of the discussions

Private notes are also used to store mark of objects that were read by used. Objects that controls, how visited them (articles in discussions, review notes and object comments) stores sign of read as well as user note assignment to the system suer note object.