Describes how to make user-dependent commentary with Portable Fragment Bookmarks. Basically, next show case what can you do with the portable fragment bookmarks.

Purpsose

Allow the user to save some comments on data, using the selection of crosstab or chart.

Animated App (click to animate)

/wp-content/uploads/2014/12/20141204_232114_capture_601614.gif

The Concept

Portable Fragment Bookmarks can

  • be assigned to a “groupIdentifier” which allows selective load from data base
  • can store any type of fragments (and by this any content you can pack into a container)

This means, using very basic components – input fileld, text filed and panel we can create simple application-dependent and user-dependent commentary solution.

How to Start?

The main object in our application is:

  • a Croosstab – with activated selection option, here:

pfb_sel.PNG

  • a Panel containing some components to implement an interaction for commentary

pfb_con.PNG

    • I) text “Add…” which just informs about the input (static one)
    • II) dynamic area which changes on selection – the selection information will be given there
    • III) a placeholder for commentary content, with scroll by local CSS… (as this part will be saved, better would be a CSS class)
    • IV) button for adding new comment on top
    • V) delete the complete comment on current selection (I do not want to be too restrictive here, I just delete the whole content…)
  • a Button “Commentary” just to show the panel…

On Selection in Crosstab

Prerequisite for this code (as it is not a generic function for all drill down states) : you know the query drilldown. Of course, you can rewrite the code with loops on dimensions, etc..

The logical description of the function:

  • ask crosstab for the selection…

pfb_con2.PNG

  • we create a selection-specific group identifier and internalPattern (by binding the internalKeys)
  • set the selection information into the text filed (just for info)
  • ask for portablefragmentbookmarks on the groupIdentifier
  • loop on all bookmarks given byy the framework and check if the internalPattern is in description
  • if it is, load the bookmark – and this sets the commentary content on the prepared textfield
  • if not, clean up the text filed manually
  • we ask crosstab for the selection…

var characteristic1 = “0BC_PROD1”;

var selection1 = CROSSTAB.getSelectedMember(characteristic1);

var characteristic2 = “0BC_PERS1”;

var selection2 = CROSSTAB.getSelectedMember(characteristic2);

  • we create a selection-specific group identifier and internalPattern (by binding the internalKeys)

var internalKeyPattern = “| ” + selection1.internalKey + “|” + selection2.internalKey;

var groupIdentifier = “COMMENTS_” + characteristic1 + “_” + characteristic2;

  • set the selection information into the text filed (just for info)

TEXT_SELECTION.setText(selection1.text + ” and ” + selection2.text);

  • ask for portablefragmentbookmarks on the groupIdentifier

var frBookmark = Bookmark.PortableFragmentBookmark.getAllBookmarkInfos(groupIdentifier);

  • loop on all bookmarks given byy the framework and check if the internalPattern is in description


var bookmarkId = “”;

frBookmark.forEach(function(element, index) {

  if (bookmarkId == “”) {

   var description = element.description;

 

   if(description.indexOf(internalKeyPattern) > -1) {

    // there is one.

    bookmarkId = element.id;

   }

  }

});

  • if it is, load the bookmark – and this sets the commentary content on the prepared textfield


if(bookmarkId != “”) {

  Bookmark.PortableFragmentBookmark.loadBookmark(bookmarkId);

} else {

  • if not, clean up the text filed manually


  TEXT_COMMENT_CONTENT.setText(“”);

}

By this, every selection will lead to reload, and to check if there is a specific bookmark on this groupIdentifier / internalPattern.

Saving a Comment

Now, having a selection and user created content, the idea here is just to append it into the TEXT_COMMENT_CONTENT, which is part of the container saved in the bookmark.

The logical sequence..

  • again, check the current selection
  • create same groupIdentifier and internalKeyPattern (this could be externalized into global script functions)
  • check again in a loop if a bookmark already exists (to get the key for overwrite), also here the loaded key could be back-uped when loading the comment
  • append the text with “\n” for new line
  • save or overwrite the bookmark.
  • again, check the current selection

var characteristic1 = “0BC_PROD1”;

var selection1 = CROSSTAB.getSelectedMember(characteristic1);

var characteristic2 = “0BC_PERS1”;

var selection2 = CROSSTAB.getSelectedMember(characteristic2);

  • create same groupIdentifier and internalKeyPattern (this could be externalized into global script functions)

var internalKeyPattern = “| ” + selection1.internalKey + “|” + selection2.internalKey;

var groupIdentifier = “COMMENTS_” + characteristic1 + “_” + characteristic2;

  • check again in a loop if a bookmark already exists (to get the key for overwrite)

if(selection2.internalKey != “”)  {

  var frBookmark = Bookmark.PortableFragmentBookmark.getAllBookmarkInfos(groupIdentifier);

  var bookmarkId = “”;

  • append the text with “\n” for new line

  TEXT_COMMENT_CONTENT.setText(APPLICATION.getInfo().dateNow + “: ” + INPUTFIELD_COMMENT.getValue() + “\n” + TEXT_COMMENT_CONTENT.getText());

  frBookmark.forEach(function(element, index) {

  if (bookmarkId == “”) {

   var description = element.description;

  

   if(description.indexOf(internalKeyPattern) > -1) {

    // there is one.

    bookmarkId = element.id;

   }

  }

  });

  • save or overwrite the bookmark.

  if(bookmarkId != “”) {

  Bookmark.PortableFragmentBookmark.saveBookmark(groupIdentifier, PANEL_COMMENTARY_CONTENT, “”, internalKeyPattern, “”, bookmarkId);

  } else {

  Bookmark.PortableFragmentBookmark.saveBookmark(groupIdentifier, PANEL_COMMENTARY_CONTENT, “”, internalKeyPattern, “”);

  }

  INPUTFIELD_COMMENT.setValue(“”);

}

By this, all user comments can be saved. I have used the date for append, but this is up to you. you can also use user name, but this makes more sense when the bookmarks will be sharable (not in 1.4 release).

Example App (you can download the ZIP)

Release SCN_SIMPLE_COMMENTARY · KarolKalisz/DesignStudioBiAppRepository · GitHub

Have Fun!

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. Carlton Cheung

    Hi Karol,

    This is a really good idea. Do you know if there is any way that you can make these comments/bookmarks visible to ALL users, instead of just the creator?

    Cheers,

    Carl

    (0) 
    1. Mustafa Bensan

      Hi Carlton,

      I think at the time this blog post was written, Portable Fragment Bookmarks could only be loaded by the creator.  However, as of at least DS 1.6 Portable Fragment Bookmarks can be loaded by all users, so you should find that the code example in this blog will allow all users to see the comments.

      Regards,

      Mustafa.

      (0) 
  2. jing zhang

    That’s a very good blog At least for me ,Thank you!
    but I have some question ,due to  I just use this recently.can you help me ?
    in you blog,I have see following 3 variable,but I don’t understand why characteristic1 use this value,or just Occasionally?
    var characteristic1 = “0BC_PROD1”;
    var characteristic2 = “0BC_PERS1”;
    var groupIdentifier = “COMMENTS_” + characteristic1 + “_” + characteristic2;

    (0) 

Leave a Reply