Posts Tagged ‘json’

7 Dec 2015

John Jardin’s 2nd Session at IBMConnect 2016: Optimus XPages


So, to my utter surprise, my second Abstract for IBM Connect 2016 was approved. It’s titled “Optimus XPages: An Explosion of Techniques and Best Practices“. For a reference to my first Abstract, click here. Just so everyone knows, IBM Connect takes place at “The Hilton” in Orlando, Florida. My session “Optimus XPages” is scheduled for Monday the 1st February 2016 at 3:30pm.

I am extremely excited to be presenting this session. Over the past year I have implemented a number of solutions running on XPages, and I got to experience first hand the improvement in performance and overall user experience when comparing these solutions to ones I developed in the past. I feel I have come up with some serious practices that anyone can easily apply to make their applications work and feel fast and responsive, whether running on a local network or in the cloud.

Below is a rundown of my session:


AD-1074 – Optimus XPages: An Explosion of Techniques and Best Practices


Starting a new XPages project but not sure it’s going to be done right the first time? Do you have an existing application that doesn’t seem to have that “X” Factor? In this session John will demonstrate how XPages developers can apply proven techniques and best practices to take their applications to a game changing level.


  1. Rapidly develop responsive applications
  2. Improve user experience and response times with background and multi threaded operations
  3. Keep your XPages lightweight with code injection
  4. Create scheduled tasks the XPages way
  5. and much more.

I hope to see you all there :)

Cheers for now :)
7 Jan 2014

Convert MySQL queries to MongoDB using QueryMongo

I needed to perform a query search in MongoDB based on an array of values. I referenced MongoDB’s Manual, which provides great examples of comparisons between SQL and Mongo Queries, but sadly they don’t provide examples of all queries types. QueryMongo to the rescue!!!

The MySQL Version of the query I wanted to perform

In my particular case, I needed a MongoDB version of the following MySQL Statement:

SELECT mallType FROM Places 
WHERE mallType IN('Mall Type 1','Mall Type 2') 
ORDER BY mallType;

What I did to convert the Query

I opened QueryMongo, pasted the above Query in the MySQL Query Field and clicked on “Translate To Mongo“.

QueryMongo returned the following MongoDB Query back to me, which was exactly what I was looking for:

    "mallType": {
        "$in": ["Mall Type 1", "Mall Type 2"]
}, {
    "mallType": 1
    "mallType": 1
I hope this helps. Happy coding :)
29 Nov 2013

DanNotes Session Slides: Mobile Blast – Mobile Strategy for Developers

Here are the slides to my 2nd session at DanNotes this week: Mobile Blast – Mobile Strategy for Developers.

Enjoy :)

25 Jun 2013

Javascript Tip: Test to see if your variable’s value is valid

Invalid values in JavaScript come in all shapes and sizes. Sometimes you just want to know if a variable has a valid value so that you can execute the necessary code.

I had a pretty hard time with this, but I found that testing a variable for a ‘Truthy’ value works very well for me. When I say test for a ‘Truthy’ value, I mean a legit value that will return true. See below example:

var myVariable = 'Test';

The example above would return true because myVariable contains a valid value. If myVariable returned one of the following, the above example would return False:

– Undefined
– Null
– <null>
– NaN
– +0
– -0
– Empty String where length is 0.

Hope this helps :)

18 Sep 2012

TUTORIAL: Integrating XPages with DB2 – Part 2

Hi everyone. So, just 2 things firstly:

1. This is an extended Post to David Leedy’s NotesIn9 Posting of “Intro to XPages and Relational Data – Part 2“.

2. I do apologize that this took a while to publish. This is one of the more challenging years to find some free time to contribute to the Domino and XPages community. Having said that, I have quite a few Video Tutorials planned before this year ends, so stay tuned :)


Now that that’s out the way…..this post is Part 2 to the “Integrating XPages with DB2 – Part 1“. In this Video I show you how to Create/Read/Update/Delete DB2 Data using XPages. More importantly, I show you how to empower the User to perform all these functions via a User Interface. It’s usually easy to write this logic in the back-end, but a little more involved when handing that power over to the User.


The good news is that it’s fairly straightforward. I show you some quick functions that will get you up and running in no time. As I explained in the Video though, there are much more advanced ways of integrating to DB2. This will involve some knowledge of DB2 itself. The keyword is…..”Stored Procedures“. This is where the power lies. A Stored Procedure is very much like a Sub Routine in LotusScript or a Function in Java or JavaScript, but you code in SQL Language. You can pass the Stored Procedure parameters, have all your logic neatly set out in a central place in DB2 and return values from the Stored Procedure which will allow you do things like create Child Documents, etc.

Later on in the near future, I will think up a straightforward Tutorial which will show you how this all works.

I hope you enjoy this Video. I really enjoyed making it. It was one of my smoothest recordings where everything went right the first time.

I want to thank David Leedy as always for adding this to his NotesIn9 Series. You da man :)




IMPORTANT NOTE: If you are not able to view this Video in HD, please Click Here to open this video up in a different Player.