CreateView, personal on 1st use, search results - help PLEASE

HCL Domino Domino Forum
1

Hi all,

Please bear with me while I spell out my problem.

I have a database having approx 40,000 records, on the server. Users use this as a kind of corporate yellow pages, to locate users. The user would enter the search criteria and then execute the search, the right frame should then display the search results.

Since it is a server db, it is accessed simultaneously by more than one user.

I created the default view (to have all records) as Shared, private on first use. After the search string is compiled and the search results are obtained (am using a db.search), I create a new view programmatically using CreateView method and modify the view selection formula through the same code. Unfortunately, I am unable to open the new view unless I exit the database and re-open it.

I searched this forum and it said that this is a known issue with the CreateView method.

Is there any way that I can do this? Creating a document collection and putting it into a folder has a very very serious negative impact on the response time.

Please, please, please, any suggestions / inputs would save my sanity.

TIA

Devyani

2

Subject: RE: CreateView, personal on 1st use, search results - help PLEASE

Use a folder instead of a view.Search for spofu (Shared private on first use ) folder and this forum should give you all the answers

3

Subject: Make the folder SPOFU - Stored on Server

if that is allowable

(It makes for marginally easier handling)

4

Subject: why do you need to CREATE a view ?

Notes supports many users apply their own seraches to the same shared view

why not simply a

  1. open the view

  2. apply the search as a Full Text Search

Admittedly FT syntax is a BIT more complex than formula Search but still ok

5

Subject: RE: why do you need to CREATE a view ?

Hi Alan,

Thanks for your response. I would love if your approach gives me the result i want but i have a query… probably a very silly question, but…

If I understand you right, I open the view via LotusScript, run the FT Search on the view. How then do I show the view to the user to show only the results of the FTSearch? A pointer to the command/syntax would really help.

TIA

devyani

6

Subject: Oops -

I believed that in R6 if you got your view from the UIView

and then did a FTSearch

the FTSearch would be visible

apparently NOT.

So then we fall back on more indirect methods. I have five approaches for you to consider :

  1. Make the user do more work

simply open the view to be searced with the search bar visible

(add a search form if that is useful)

Problem: not user friendly

  1. Use an embedded view

on the form that embeds the view have drop down list to create a “Query by Example”

If needede build a view with a compound key

Refresh form on changes - list shows only those that match

Disadvantage: only ‘=’ searched

limited function on embedded view

  1. use the R6 Feature to @SetViewInfo

to filter for a single category

action button asks question

Disadvantage: simple matching - one at a time?

  1. Use Folders

basically the “Friendly Query” method in the FAQ of FAQs.

have user enter data on a form - do the FT Search - throw resulting collection into a Private Folder (best Private on First Use Stored on Server)

Problem: not the fastest

  1. Build a dynamic document

again use a form to collect query parameters

and do the query

However on same form have an area of pass through HTML

(basically a single field … Computer when composed to blank)

Afterethe query set this field in code to teh text to draw a HTML table

equivalent to a view with colums and rows.

(obviosly with values calculated from the returned collection)

This is quite easy to code for display purposes

and you can even include hotspots to open the document

(simple javascript)

BTW: I have used all 5 methods at various times with good results.

7

Subject: RE: Oops -

Hi Alan,

Thank you so much for the details of the 5 various methods! I opted for the 4th one, and the response time over 35,000 records is good :slight_smile:

thanks once again.

devyani

8

Subject: You are very welcome