Solved

Display Only Documents with Responses in a View

Posted on 2004-09-21
12
236 Views
Last Modified: 2013-12-18
How can I write a selection formula that will display only documents in the db that have response docs?
0
Comment
Question by:mcjann
12 Comments
 
LVL 19

Expert Comment

by:madheeswar
ID: 12111022
SELECT Form="Formname" & @AllChildren
0
 
LVL 1

Author Comment

by:mcjann
ID: 12111053
I want to see only "FormName" that have a response not all "FormName"
0
 
LVL 19

Expert Comment

by:madheeswar
ID: 12111071
I did not understood what u mean? U want to display only those form docs which have response. RIGHT?

This should work:

SELECT Form="YourFormNAme" | @AllChildren
0
 
LVL 1

Author Comment

by:mcjann
ID: 12111117
The database contains 100 documents based on "Form" and 15 of these documents have a response. This formula selects 115 documents when I only want 30 (15 "Forms" each with a single response).
0
 
LVL 19

Expert Comment

by:RanjeetRain
ID: 12111128
USe this:

SELECT Form="Formname" & @DocChildren > 1
0
 
LVL 1

Author Comment

by:mcjann
ID: 12111180
Now I get no documents in the view.
Even when I try @DocChildren=1 or >0
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 19

Expert Comment

by:madheeswar
ID: 12111216
@DocChildren won't work in selection formula.

ur requirement cannnot be achieved.

0
 
LVL 19

Expert Comment

by:madheeswar
ID: 12111237
what u need to do is,
if there is any response document created, update a field in parent and response document as "yes" and make this selection formula in view;
Select form="urformname" & fieldname="yes" | @Allchildren

Since u have already created docs,u need to write some script to update parent and child docs according to above logic and display the result.

Note that there is no striaght forward solution for you.
0
 
LVL 1

Author Comment

by:mcjann
ID: 12111480
madheeswar,

I set the same field on both forms.
The response doc inherets values from the main document.
Field exchange on the main form is not disabled.

I update the field  on the querysave (?) of the response doc.
The field on the response doc updated but the main form did not
Is this becasue the document is not in edit?
The main document should not be edited perhaps a computed field?
0
 
LVL 19

Expert Comment

by:madheeswar
ID: 12111508
Both parent and child documents should have same value.

I mean for all the documents(response and child) should have one data(field) in common and that field should hold a key. we can utilize that field as the key for our view selection formula.

Hoe it helps.

I am leaving office. Will respond tomorrow
0
 
LVL 15

Accepted Solution

by:
Bozzie4 earned 125 total points
ID: 12111595
If you don't want to touch the documents (by adding a field, like maddy suggests ,  which is a perfectly valid solution), you can also create an agent that puts documents with responses in a folder.
To limit the number of documents it works on, you can use the Document Seleciton in the agent

dim db as notesdatabase
dim s as new notessession
dim coll as notesdocumentcollection
set db = s.currentdatabase
Set coll  = db.AllDocuments
do while not doc is nothing
set resp = doc.responses
if resp is nothing then
' skip
Call doc.RemoveFromFolder( "Documents with responses" )
else
Call doc.putinfolder("Documents with responses", true )
end if

set doc = coll.getnextdocument()
loop
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 12112404
Can't do it with a view.  Bozzie's solution will work, though you have to run it regularly, and it will be inefficent when run that way (of course, if you only have a few hundred docs at most, that shluld be OK).

You should also create the folder DOCUMENTS WITH RESPONSES in advance, so you can set the design of it.  Otherwise, the PutInFolder command will create it on the fly, using the default folder design as a guide.

If you want to avoid that, flag the parent documents, but the code is going to be more or less the same.  Instead of doc.putInFolder and doc.removeFromFolder, you would use
        doc.flagAsHavingRespnses = 1
    and
        doc.flagAsHavingRespnses = 0

Then just base you view on flagAsHavingRespnses

In iether case, there will be some lag time between adding a response to a responseless document, or removing all responses from a document, and the time the doc appears in/disappears from the folder or view.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Text over two lines in VBA for email 26 159
Send email lotus notes / VBA 6 167
Domino Lotus Notes Client 4 67
Lotus Notes – Domino Document Manager 4 105
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now