Programatically change the color of rows in a view

This is a fairly simple but effective way to highlight documents in a view.

Insert a column at the beginning of your view, hide it and ensure the column option "Use Value as Color" is checked.  In the formula for this column, add the following color definitions (or make your own based on the RGB scheme).

red := 255:0:0;
black := 1:1:1;

After the colors are defined, add a line of code like the one below.  In this example, if the field AssignmentTargetDate is blank, then set this column to contain the RGB code for red, otherwise, leave it as black. 

@If(AssignmentTargetDate = "";red;black)

When the view is displayed, any rows which have a blank AssignmentTargetDate will be displayed with red text.  You can get as complex as you can with your color logic, but the simplicity of this feature is what makes it so effective.

New Articles Coming

I'm doing a bunch (18 or so) of smaller iSeries related Tech Tips for MC Press which will be published over the next few months.  My editor is keeping me quite busy and I'm keeping her quite happy.  :)

Below are some of the topics being covered.  I'll be posting updates here and on Twitter when they're available.

•  Use Database Navigator to see your database graphically and to manage it
• What are the GUI equivalents of WRKSPLF, DSPMSG, WRKUSRJOB, etc.? The advantages and disadvantages of GUI vs. Green-Screen for each.
• Manage Objects in the IFS Directory
• How to import and export a multi-occurrence data structure
• What's CHGACTSCDE/CHGEXPSCDE Used For?
• Using named activation groups
• QPWDCHGBLK (Change Block) and QPWDRULES (Password Rules) System Values: New in 6.1
• Use iSeries Navigator to find dependencies in tables
• Don't Like WebSphere? Then Try Jetty!
• File Auditing Symplified
• New in V6R1: MONTHS_BETWEEN
• New in V6R1 : two separate functions (Select and Insert) has become one function (Select from Insert).
• Use Backup Scheduler in i5/OS to set up daily, weekly, and monthly backup routines
• What does SAVSECDTA do?
• System Values QINACTITV and QINACTMSGQ
• Copying to a test environment using a batch program of all files greater than a specific date
• Beware of the QIBM_QDB_OPEN Exit Point!
• Use Print Adopting Objects (PRTADPOBJ ) to keep track of adoption of authority (security)

Be Sure Your Spring Cleaning Includes Tidying Up Disk Space

Check out this article I did for MC Press a couple of weeks ago. Give your system a good scrubbing.

Admin/Developer 2010

Just got back from beautiful Boston, MA at joint Admin/Developer 2010 conference by The View. I was there in 2007 and there was a much bigger turn out back then. Regardless, the conference was pretty good and the content was worth the price of admission.

Notable speakers were Rob Axelrod and Franziska Tanner. Francie had some great tips on performance tuning that I implemented within hours that had an immediate impact on server performance.

I’ve been asking this question for about 5 or 6 years now and no one yet can give me an answer: when will IBM support Kerberos authentication with Domino?

Speaking of training, check out this nugget…

A $35 donation is suggested, but not required. Before you give me the “you get what you pay for” stuff, have a look at last years presenters and conference track. Looks pretty damn good for a couple days in Cleveland.

Getting face time with an Ed Brill or Kim Greene is worth the flight/hotel costs by itself.

http://www.mwlug.com/mwlug/mwlug2010.nsf/uxpages/registration.uxp