Search DominoPower's 10,675 Lotus-related article archive 
Home
EasyPrint
News details Click here for the RSS feed's XML code. This is not a browser URL.
Articles-only Click here for the RSS feed's XML code. This is not a browser URL.
Twitter Feed Click here for the Twitter feed.
PROGRAMMING POWER
Dynamic view filtering in Notes
By Mick Moignard

There's been one question that has been asked over and over again by Notes developers: "How can I parameterise a Notes view selection?" The answer was always "You can't" because it is the server that maintains the view, and at the time the server does the view, there's no opportunity to customise a view for one particular user.

But, actually, since Notes 6 you can customise view selections at the point of display. There are two ways to do this, both of which are reliant, basically, on being able to categorise the view in question.

Embedded views
The first approach is to use a single category in an embedded view. This one works both in the Notes client and on the Web.

I used an embedded view on a project for a customer a bit back. The application here was quite simple; we extracted some data about software installed on each PC from a Tivoli database, making one Notes document for each machine. We could also have created one document per software item per machine, but we didn't. We added the computer owner's name to each document, because some people had more than one computer. We then compared the software items and versions reported by Tivoli against the company's approved software list, and marked items as to whether they were approved or not.

There were views in the database that enabled administrators to see all the data, but what we wanted to do was be able to show each user just what was recorded for them, and to do that, we used a single-category embedded view.

We first created a view categorised by the computer owner's name. How you generate that category column is up to you. In our case, it was the field containing the person's name, but so long as you get a category value, how you do it is up to you. All the single-category check does is match against the final category value. Figure A shows you the view when opened directly in a Notes client. You can see that it is categorised by the user name.

FIGURE A


You can see the view categorised by user name. Roll over picture for a larger image.

Next, we need to embed this view onto a form or page. Figure B shows this view embedded into a page.

FIGURE B


Next, embed the view onto a form or page. Roll over picture for a larger image.

At the top of the page is a computed text field that displays the current user name. Look at the Designer's Objects/Reference pane in the middle bottom of the screenshot. You can see, at the end of the list, the embedded view program events, and "Show Single Category" is highlighted.


1  ·  2  ·  3  ·  4  ·  Next »
Other articles you might like
Home > Lotus Technologies > Notes (78 articles)
   When the debugger won't debug hidden code that isn't hidden
   What to do if the LotusScript debugger won't single-step over code
   Troubleshooting an OpenSuse Notes install
Get Weekly Email Updates
Subscribe to our regular weekly email newsletter. It's packed with tips, reviews, deep analysis, and the latest news.
 
Recent DominoPower Articles
What to look for in a Domino-based document management solution
Understanding Domino.doc end-of-life options
When the debugger won't debug hidden code that isn't hidden
What to do if the LotusScript debugger won't single-step over code
Top 10 ways to launch and build a Lotus consulting practice (with a little help from the Beatles)
Troubleshooting an OpenSuse Notes install
Incident report: denial of service attack against ConnectedPhotographer.com
Latest Lotus Headlines
SnTT - Enabling ALL the bells and whistles!
Tivoli Data protection causes Domino to crash
Fun when running DB2 CLP scripts
Introducing Flippr, the easy way to admin Quickr
DXL and fake security
Using search forms in IBM Workplace Collaborative Learning 2.7
Schmidt, Freed, and Gering on the OVF Toolkit
>> Read all the news
More from the ZATZ journals
Computing Unplugged: Eight steps to successful and reliable home backups
David Gewirtz Online: CNN commentary and analysis
OutlookPower: Can Outlook run when it's not running (and other mysteries)?
-- Advertisement --

PDF Conversion for Lotus Notes
Convert Lotus Notes documents to PDF for sharing, archiving or web printing.

  • 1-step PDF: As easy as clicking a Lotus Notes toolbar icon
  • Archive email folders or views as a self-contained PDF
  • Convert any document collection into a PDF file
  • Produce print-quality output from Web applications
  • Client side or Server side conversion
  • Doesn't require any DLL files
  • LotusScript API for developers


Ready to learn more?
-- Advertisement --

Integrate your Notes Applications with Microsoft Office and Symphony
Integra for Notes Integrates Microsoft Office and/or IBM Lotus Symphony
Requires NO change to the design of the appliation or Installations of DLL's and EXE's
  • Integra is a ready to use solution, enhance static reports with Excel data analysis, pivot tables, macros
  • User friendly aproach, using a point and click access to features
  • Reports from any Lotus Notes databases
  • Runs reports through a Notes client, web browser and scheduled basis
  • Allows use of LotusScript for advanced data manipulation
  • Enables self service reporting capabilities to end-users


Learn more at www.integra4notes.com.
ZATZ Home  ·  News  ·  Back Issues  ·  Credits/Trademarks ·  Link To Us
Copyright © 1998-2009, ZATZ Publishing. All rights reserved worldwide.
Editor's Login