Q
Problem solve Get help with specific problems with your technologies, process and projects.

Checking subtotals in a TimeLog

I have an application for TimeLog for all the users on R5.0.6 on WinNT. I have the view, which by columns are Person--Year--Month--Date--Project--Time. Here, the Time column displays sub-totals and total for every individual person and for the respective Project. I want to fetch the subtotal on a computed field for that person for that date, and if it exceeds 24hrs, then he should not be allowed to create a TimeLog. How is it possible?


It appears that you want to sum a numeric field from multiple documents related to a single person for a single day.

You could do the following:

  • use selected document to get a key (like name, or use session.UserName)
  • get date you're interested in (from doc or Today() function)
  • perform a NotesView.FTSearch providing a query based on the above fields
  • Iterate through the result set, summing the numeric field
  • Evaluate the result of above function.
  • If result > 24 then provide message and exit.


Dig Deeper on Domino Resources - Part 3

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchDataCenter

SearchContentManagement

Close