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

Edits in one view affect the other view

I am making a program that travels to different authoritie for approval or rejection. I have made views on the department names. As per the department field, approval authority is decided and doclink is send to that approver.

Now my problem:
I am using formula language, and when I delete records in one view, the other view also deletes the record. If I add some fields, blank records are also added in the other view.

You should adjust the "selection formula" for each of the views to show only documents whose "department" field contains a value appropriate for that particular view. For example, the view selection for a Sales view might be.. "SELECT @UpperCase(department_field) = "SALES" where department_field is the field you use to store the department name.

Tip** I use the @UpperCase function to ensure that the pattern match is case-insensitive as is usually required for selection formulas

This was last published in January 2002

Dig Deeper on Domino Resources - Part 4

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.




  • 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 ...