How do I send a URL via macro with Bookmark ID? - Qlik Community

Report Inappropriate Content · ‎2015-04-30

I have scoured the forums looking for a straight-forward answer and have come up with null results. *sigh*. I apologize if this has been answered somewhere else but I couldn't find it.

Here is my scenario:

I have a button that creates a doc bookmark based off of a variables that I generate from username and a time/date stamp:
- Variable examples:
  - vCRBookMarkName = CR-QG_20150430
  - vCRBookMarkID = CRQG_150430

Small sample set of the code:

sub mCreateSendBookMark

set docprop = ActiveDocument.GetProperties

docprop.AllowServerBookmarks = true

ActiveDocument.SetProperties docprop

ActiveDocument.CreateDocBookmark true, getVariable("vCRBookMarkName"),getVariable("vCRBookMarkID"),1

I then have the script(macro) create an email to display all the pertinent information for our help-desk team. The issue i am having is that the URL for the QV app via Ajax, on our server, cannot correctly display the BM ID since there is no way to call up the id by GetProperties and such. Even with using the CreateDocBookmark with a BM Name and a BM ID, the ID still does not get populated correctly. It just defaults to "BM01... " etc.
- txtBody=txtBody & "<HTML><BODY><font face=""verdana"" size=""1"">http://qli-app-000/QvAJAXZfc/opendoc.htm?document=CompanyApp%5FR32%5FemailDemo.qvw&bookmark=Server\"& getVariable("vCRBookMarkID")&"&host=QVS@qli-app-000<br> <br>"
- In theory, the link should be correct but when viewing the bookmark from the "Repository" in Ajax, I see that the bookmark that I named does not show the ID that I tried to apply.
- I have "allow server bookmarks" and all that enabled in the Management Console.

So, how do I create a bookmark via macro and use that bookmark name or ID in a concatenated string to display the correct bookmark link so that our Help-Desk team can click the link in the email and go straight to the filtered data?

See attached png files showing what we get when bookmark is created via Ajax (IE Explorer) or on the Server: QV Desktop App.

Thanks in advance for any help you "gurus" can give me.

Regards,

Quincy