There is a Notes view(view1).The each document in the view1 have information for ID and Name. Then, there is another view(view2) in another DB.The each document in the view2 also have information for ID and Name.
As "XPages view", I'd like to display the documents in view1 which are filtered out by view2 data.
For example, view1 in DB1 has 4 documents.
Doc1 - ID1, AAA
Doc2 - ID2, BBB
Doc3 - ID3, CCC
Doc4 - ID4, DDD
view2 in DB2 has 2 documents.
Doc1 - ID2, BBB
Doc2 - ID3, CCC
I'd like to see the data as a XPages view which filtered out by view2 data. Is this feasible?
Doc1 - ID1, AAA
Doc2 - ID4, DDD
I feel it is possible if I'd like to get the next data by 'filter by column value'option. But I'd like to get the opposite result in XPages view.
Doc1 - ID2, BBB
Doc2 - ID3, CCC
If you retrieve a DocumentCollection for each view, you can use the following set operations on those NotesCollections: Intersect, Subtract and Merge. I think you need Subtract in your case. These operations can be very slow, in my experience.