Xpages: Web Dashboards made easy, I Love X-pages!!

On a recent project, a simple one at that, an executive wanted an overview dashboard to show totals from many different views on one page. I started thinking about how i would do this in the

Notes client...

I could make a form with computed fields and create an agent or query open LS code to get the values and set the fields values.

I could create computed fields and do it with formula language but what a pain that would be.

The old way on the web

I would to use a webquery open agent and set the values, or compute formula on the fields.

Xpages...

Well in X-pages i am allowed to create a computed field and use SSJS to compute the value. It is like having a computed field on a client based notes form and setting the value to LS, which of course you cant do.

i wrote three lines of code per field

db = session.getCurrentDatabase()

view1 = db.getView('On Site')

view1.getEntryCount()

or it could be like

db = session.getCurrentDatabase()

view1 = db.getView('On Site')

dc1 = view1.getAllDocumentsByKey('test')

dc1.getCount()

and of course you can do a

db = session.getCurrentDatabase()

view1 = db.getView('On Site')

dc1= view1.getAllDocumentsByKey('test')

doc = dc1.getFirstDocument()

total = 0

while(doc != null)

{

total = doc.getItemValueDouble('amount') + total

set doc = dc1.getNextDocument(doc)

}

total.valueOf()

X-pages made this easy web development, compared to what i had to do in the past