Category Archives: Plug-ins other scope

Interactive RQL tool

With this plug-in you can execute RQL commands and explore the response delivered from MS at lowest possible level.  The plug-in preserves your request and responses into a re-start of the tool.

In addition you can have several RQL requests in parallel. You need to select the command you want to execute, so there is still space to comment RQL requests. Use the plug-in Show session variables to get the IODATA tag with your current session.

The tool was not written by me. A consultant from the RedDot service handed it over to me after a RQL training session.

Benefits
Without this handy plug-in it’s almost impossible to work intensively with RQL. I uses this plug-in intensively, while developing of the jRQL API.

For me it is and was the basis to investigate all RQL commands. I grab quite often undocumented commands from the common log files and uses this tool to test the core command (remove unavailable attributes).

How to start the interactive RQL tool
You found this plug-in not in SmartTree. Instead open the Windows Start Menu and use the provided link “Interactive RQL”.

The URL in the form http://server/cms/ExecuteXml.asp to the Interative RQL tool can be distributed to your local desktop PC too. You don’t have to work on the server machine to use it!

How it works
After start of this tool you get a separated screen. On top an entry box with your latest used RQL requests and below a text are with your latest response.

You need to select the RQL request and click the button above Execute marked XML.

It’s quite handy, that the tool remember your requests and responses so you can even proceed with your work the next day. The most used RQL commands can be collected and stored this way for easy access.

I strongly recommend to use the plug-in Show session variables in addition to get the IODATA tag with your current logonGUID and sessionKEY.

Installation
This plug-in can be installed using the combined setup routine for all jRQL API based plug-ins. Follow the instructions in this blog to download the installer and configure the plug-ins you want.

Plug-in Show all session variables

This plug-in helps you to investigate all MS session variables. You can easily check the complete session if the needed data are already contained.

If you need to grab only the connection information as RQL tag or Java source code, you are better served by the plug-in Show session variables.

Benefits
This small but fine tool helps you out of the box to search the complete session data for an information you expect there.

This is helpful for RQL and plug-in developers. I used it quite often, when I try to integrate a plug-in into MS SmartTree.

Location in SmartTree
You found the plug-in under Administer Project Structure.

How it works
Immediately after the start you get a quite long list of all current session variables. Please have in mind, that this plug-in is a simple ASP page, means a running Tomcat is not needed to use it.

Installation
This plug-in can be installed using the combined setup routine for all jRQL API based plug-ins. Follow the instructions in this blog to download the installer and configure the plug-ins you want.

Plug-in Show Session Variables

With this plug-in RQL enthusiasts and API developers get the needed connection information (LogonGUID, SessionKey, ProjectGUID) as Java Source code and as RQL command.

For further investigation of the MS session variables, please refer to the plug-in Show all session variables too.

Benefits
Instead of copying and pasting these GUIDs one by one this plug-in combine it all into only one copy step needed.

If you need to explore the RQL command, for instance with the interactive RQL tool, this is the perfect companion to get the first line of every RQL command in a one step copy fashion.

As an API developer you often need to copy the connection information into your Java IDE for a quick try. At my desk this happen quite often within the day.

Location in SmartTree
You found the plug-in under Administer Project Structure.

How it works
When you start the plug-in it immediately opens the result screen. Please have in mind, that this plug-in is a simple ASP page, means a running Tomcat is not needed to use it.

The first 3 lines are Java source code for the API developers. The IODATA tag provided can be copyied directly into the interactive RQL tool and can be supplemented with other RQL tags.

Installation
This plug-in can be installed using the combined setup routine for all jRQL API based plug-ins. Follow the instructions in this blog to download the installer and configure the plug-ins you want.

Plug-in Collect user e-mail addresses from different projects

With this plug-in you can collect all e-mail address of all MS users assigned to several projects in one list separated by semicolon. I used this address list afterwards to write an e-mail to all authors. Users without an e-mail address will be ignored.

The list of e-mail addresses is ready to use within Outlook, because they are separated by ;. As a result you can copy the whole list into your clipboard and proceed with writing your announcement e-mail.

Benefit
The MS did not offer such this functionality, at least at the time I wrote this plug-in. You can now contact all MS users, regardless regardless what combination of projects you need. A manually maintained list is not an option, I think, therefore I wrote this plug-in.

Location in SmartTree
To start this plug-in, please navigate to Administer Project Structure > Project, even the scope is in fact ServerManager. I found this place more handy as switching to the ServerManager module.

How it works
You will be asked first to select the projects from where all users should be considered. Btw, the project GUID is displayed for API developers.

After using the button Collect addresses you get the list of addresses presented in a text area for easy copying.

Above the text area the plug-in tells you the distinct number of users in your selected projects for information only.

Installation
This plug-in can be installed using the combined setup routine for all jRQL API based plug-ins. Follow the instruction in this blog to download the installer and configure the plug-ins you want.

For API developers
The functionality of this plug-in is completely offered by jRQL through the function CmsClient > collectUserMailAddressesForProjects().