— Update 03/08/2019 2 PM EST: Windows crash issue has been resolved. Please go to https://github.com/icstechsales/dql-explorer/releases and download latest release. More fixes coming next week.

— Update 03/08/2019 11 AM EST: We are aware of some instance where the code crashes the Domino server when running on Windows at the time we populate the list of databases. We're working on it. Another update coming soon.

Prototype for….- Business users have access to Domino data like never before.

  • Developers to understand their queries before even opening the Designer

  • Administrators to understand the impact on the Domino servers (if any)

From the Domino documentation, "Domino Query Language (DQL) is a facility running in Domino core allowing for a terse shorthand syntax for finding documents according to a wide variety of complexity of terms. It leverages existing design elements without the need to write detailed code to access them."

Starting mid-January, we started discussing the possibility of a solution that would facilitate the creation of DQL queries by non-developers. And after a few weeks of work, this new tool was showcased at IBM Think 2019 as DQL Explorer. You can see the video here: https://www.youtube.com/watch?v=OMjSND5cPsE

Today we are excited to announce that we are making the code for this project available both on GitHub and OpenNTF.

DQL Explorer is built as a web-based UI using React on the front end and a Domino database for storage and some configuration functionality. It provides a means for non-developers to use Domino Query Language to easily search and return data from Domino databases.

Scott Good provides a deeper overview of the capabilities in this video: https://www.youtube.com/embed/Cfw_6Wvk8c8

# How DQL Explorer was built

- React. A JavaScript library for building user interfaces. The application is built using React without bloat, i.e. no Redux.

- Office UI Fabric React components. The official front-end framework for building experiences that fit seamlessly into Office and Office 365. We used it as it is MIT licensed and allows for a seamless experience in the context of Office 365 where a lot of our Domino customers tend to work.

- Fontawesome. All icons used in the application are based on the free Fontawesome library.

- Domino. IBM Domino has always been a stable, secure, and trusted platform for developing and hosting business-focused collaboration applications. Choose from a variety of platforms and operating systems to deliver critical business applications, built for today's world by today's developers. Access your applications from an Apple iPad and even operate in disconnected mode on iOS. Secure to the core, IBM Domino V10 has self-healing and auto-repair, which will further reduce your risk of exposure to outage or failure. Learn how the value of IBM Domino has been extended dramatically.

# How you can help

1. Sharing this post article with your network, always appreciated!

2. Contributing and/or testing. You can fork the repo and create pull request for any updates you make. Some suggestions on things to work on are under the Issues in the GitHub repo.

Visit the OpenNTF for more details: https://openntf.org/main.nsf/project.xsp?r=project/DQL%20Explorer

Please note this is a prototype and we’re giving the code away for you to make the most of out of it, this prototype is given to you for you to use at your own risk.

Also, we developed this prototype under the following specs:

  • Domino Server 10.0.1
  • Linux CentOS centos-release-7-5.1804.4.el7.centos.x86_64
  • dqlexplorer must be located in root data folder
  • GA AppDev pack is installed but is not used by the DQL Explorer

Please follow the README.md file for more detailed configuration. https://github.com/icstechsales/dql-explorer

Check latest releases: https://github.com/icstechsales/dql-explorer/releases