Archive for the ‘CommentsView’ Category

CommentsView

Posted: 2017-01-17 in CommentsView

social media is used extensively by ourselves as well as our users.

I was thinking about this and was trying to better see how this type of social interaction could be used within business Apps that are developed in Lianja.

What I really wanted to achieve was social database functionality.

For example, if a user is looking at a customer or an employee record, I thought it would be useful to be able to collaborate directly inside the App without having to resort to emailing people as that email would not be properly associated with the record nor could I see a conversation history or have a proper discussion with other users about this data.

And that’s the reason I have now included a CommentsView section in v2.0.

A section can have a child CommentsView section that displays threaded comments related to the record being displayed.

Additionally, the CommentsView can have a list of topics that are displayed in the caption bar. Clicking on a topic provides the ability to add comments for a given topic and view only those comments that are specific to a given topic. Clicking “All Comments” lets you look at all comments for the current record.

You can Reply to comments, Delete then and Like them.

I think you will find this extremely useful as it has a wide range of uses.

There is a new table in the southwind database called “comments”. You will need to copy this table into your own database to use CommentView sections.

It was interesting to develop this and highlights the flexibility of the database engine for handling a graph of threaded comments, The source code is in the library directory and is called commentsview.rsp and comments_controller.prg which handles the various operations such as “add”, “reply”, “like” etc.

Screen Shot 2015-04-15 at 11.31.21 AM.jpg

Screen Shot 2015-04-15 at 11.31.39 AM.jpg

Screen Shot 2015-04-15 at 11.31.58 AM.jpg

Screen Shot 2015-04-15 at 11.32.22 AM.jpg

Screen Shot 2015-04-15 at 11.33.13 AM.jpg