Michelle's Universe

Michelle, this was just the article i needed to ge...

2014-10-24T08:37:03.091+11:00

Michelle, this was just the article i needed to get started with integrating a better solution to the old clunky Domino web pages we are all accustom to working on for many many years. I as well as of 6 months ago had no xPages experience, JSON objects, Dojo grids, Datatables, etc so after several months learning some xPages, REST services, xAgents, DataTables, a touch of JAVA and of course this great read to get me started here is what I actually did..

At first (months ago) I implemented DataTables producing a JSON object using Lotusscript with a great LotusScript class i found from a gentleman by the name of Troy Reimer. This worked good except could not handle any data sets larger than a couple thousand docs if that and with any server latency issues you may have forget it cut that number in half. I think it took me over 30 seconds to load 4000 docs which is clearly unacceptable so what i did was just load the first 1000 set the datatables per page attribute to 100 docs and allow my users to next page..previous page etc. The filtering provided by Datatables is awesome i love the real-time search capabilities which prevented users having to next/previous page.. Worked wonderful! Sounds great, right! Well, i have 15,000 docs in a view so of course i needed to add a search functionality using FTSearch, etc build the JSON object and serve it back into DataTables etc. UGH i thought. There has got to be a better solution for this.

So after several more months of learning and researching here is what i am doing today.

What i do now is on web open I call an xPage. Ye, an xPage. Create a simple javascript var with a lookup to a profiledocument and in the onLoad event and in your Datatables $(document).ready(function() call that var something like this "sAjaxSource": CallGetJSON looks like this when i pull from my profile doc.."https://domdevostx01.ten-net.net/SASE/SASENomination.nsf/GetJSON.xsp".. GetJSON is the name of the xPage essentially an xAgent if you read up on that and in the afterRenderResponse event I call a Java Class that i modified(creation compliments to Jeff Byrd - Titled "Roll your Own Domino REST Service") that actually produces the JSON object and sends it back to me to be consumed.

Oddly enough I STILL load my data into Datatables and not xPages. I am was not happy about the out of the box xPages view and Dojo grid and our organization will not fund the Dojo grid EXTJS - 600 dollars a license so I stick with Datatables which is awesome. I now can load 20,000+ documents in 5 seconds with all the nice filtering, paging, CSS modifications, etc that Datatables provides.

Not to mention no more LotusScript to write out my JSON objects! Very nice, clean and fast.

Thanks to you Michelle I thought I would share my story you got me started in the right direction and inspired me to go even further!

Ohh the power of Domino who says it's going away!

Hi Ashwin This plug-in does not really handle res...

2013-01-03T11:39:50.522+11:00

Hi Ashwin

This plug-in does not really handle response documents in the way that a Notes view does - it has no concept of expand / collapse or parent / child etc. It renders a standard table only.

But if your response documents make sense in a flat list, then your agent can return them & have them listed along with the parents.

The plug-in also provides for a callback function to post-process each row after rendering, so you could add some additional HTML manipulation in a custom function if you wanted to, to change the appearance of the child rows or whatever made sense in the relevant context.

Hi Michelle, Can we include response documents as...

2013-01-02T23:06:20.380+11:00

Hi Michelle,

Can we include response documents as well with this plugin?

Regards,
Ashwin

Nick - I have also used the Dojo framework (enhanc...

2012-06-22T21:46:20.179+10:00

Nick - I have also used the Dojo framework (enhanced grid) and actually can load large data set, 1000+, reasonably. Unlike Michelle, don't have to worry about IE6 specifically, but can attest to decent performance with more than 200 records using a dojo grid. That being said, I do agree about the search results paradigm.

Nick - I haven't done ant detailed testing, bu...

2012-06-22T18:39:46.616+10:00

Nick - I haven't done ant detailed testing, but with IE6 using jQuery, the problems seem to occur around the 1500-2000 records mark. There is also a deferred render setting which boosts this significantly.

I have also found that how you handle any events (eg on click handlers) is significant. I generally attach a single handler to the entire table and process the current target, rather than registering handlers at the td or even lower.

As for why users would want this number of results, I agree - if you are looking for a specific document, this number of results is pointless. If you want the data for reporting purposes, a dedicated export button can open the data as cvs, print to a plain table, email it to the user or some other, more useable solution.

Good read. I've used jqGrid in classic Domino,...

2012-06-22T02:27:56.517+10:00

Good read. I've used jqGrid in classic Domino, but not Datatables. I would say its a viable argument that these jQuery grid plugins actually offer more functionality than the basic Dojo grid does in XPages. (XPages does not use the Dojo enhanced grid)

great that someone took the time to describe these...

2011-11-14T19:40:27.476+11:00

great that someone took the time to describe these controls.

is that not a job for IBM?

/bitching

Hm, where does the element ... go? The design s...

2011-09-16T07:14:32.560+10:00

Hm, where does the element

... go? The design spec? Embedded in what? Is it in the custom control somewhere? Or on the XPage?

It doesn't want to go in the facets area apparently, it generates an error there.

Great information, thanks for sharing. The applic...

2011-08-18T04:21:09.857+10:00

Great information, thanks for sharing. The application layout was one of the most difficult parts of the extension library for me to wrap my head around.

That's a shame, there's always next year t...

2011-07-26T09:25:27.201+10:00

That's a shame, there's always next year though. Good luck for your new job.

No :( I'm based in Melbourne and have just st...

2011-07-26T08:39:06.432+10:00

No :(

I'm based in Melbourne and have just started a new job. I'd love to be going but it just didn't work out this year.

Michelle, you coming to AusLUG at the end of Augus...

2011-07-26T08:32:49.398+10:00

Michelle, you coming to AusLUG at the end of August? www.auslug.org

Hi Leon - I'm not sure if something is missing...

2011-07-08T14:46:42.816+10:00

Hi Leon - I'm not sure if something is missing from your comment, but I'm not quite sure what it is you are trying to do.

The information above explains how to apply Dojo to an existing Notes picklist (which is generated from a dialog list or combobox).

Any valid formula for populating a Notes dialog box will work.

Hi Michell, How do populate the label/values insid...

2011-07-08T14:10:02.171+10:00

Hi Michell,
How do populate the label/values inside filtering select combo boxes from a keyword doc?

I can do this -

but don't know how to generate it on the fly.
Any help would be appreciated.
thank you
leon

Great series!

2011-03-26T01:46:09.487+11:00

Great series!

Nice post.

2011-03-22T00:14:57.847+11:00

Nice post.

Can't wait for your next post, great job so fa...

2011-03-19T04:03:10.531+11:00

Can't wait for your next post, great job so far.

Trying to futz my way around the extension library with limited success.

2011-03-19T04:02:05.932+11:00

This comment has been removed by the author.

Hi Fredrik - sorry, no I don't know how you co...

2011-02-13T10:24:28.374+11:00

Hi Fredrik - sorry, no I don't know how you could generate the tree nodes in a breadcrumb dynamically. I'm really just starting at this and posting as I go along.

My first approach would be to see if you could create nodes for the maximum number of levels you need then compute their properties - label, url, visibility, etc. The variables could be hard-coded on each page and fetched by the breadcrumb, derived from the url or set on one page & passed to the next using session variables. It may take some work to set up, but once your layout is working the way you want you don't need to touch it again.

Hi, Michelle! Not sure if you've considered t...

2011-02-13T01:48:38.639+11:00

Hi, Michelle! Not sure if you've considered this, but check out how to join Planet Lotus -> http://planetlotus.org/forum/index.php?topic=27.0

Also, I'm guessing from your name you are a lady (if I'm wrong, ooops, I apologize) in which case you might also want to check out the Nerd Girls group on Linked In. There are several admins, developers, and other women in technology (especially Lotus) there.

Do you know if you can create treenodes dynamical?...

2011-02-12T23:50:41.189+11:00

Do you know if you can create treenodes dynamical?
For The page navigator / breadcrumb control.

You've been creating new icons :-)

2010-08-27T21:38:52.434+10:00

You've been creating new icons :-)

2010-06-07T23:53:24.479+10:00

This comment has been removed by a blog administrator.

hello. thank you very much for letting me comment....

2010-05-24T04:25:13.938+10:00

hello. thank you very much for letting me comment. very good article I would like more information on this item

You might want to try Visustin. While not as prett...

2010-04-27T20:24:06.310+10:00

You might want to try Visustin. While not as pretty as Giffly it has one distinct advantage: it generates the diagram out of your actual source code. It does LotusScript,JavaScript, Java and a ton of other languages.