Hi all,
I need some help, I need to create a search keyword on basis of a field which is common on all my databases.How to I append the @dblookup formula to search across various database views resulting a common output??
Subject: Designer help reqd
Sounds like you might want to put the @dblookup formula inside of an @for or an @while loop. On second thought, you would need to change the name of the database on each iteration so that wouldn’t work, unless you had control of the db names and did something tricky like named the databases db1, db2, db3 db4 and db5 then just change the name with the loop iteration.
I’ve done a search accross several databases with the same content, but I did it by writting a java agent inside of notes that used the ftsearch method and sorted all of the results irrespective of which database they came from, then displayed the results on the web.
It will be easier to help you with more information of where you want to display these results.
hth,
Heather Smith
Subject: RE: Designer help reqd
Thanx for your response Heather.Let me tell you in detail what exactly I am looking for:
We have several databases in our system which share the same Form structure.These databases are different for different groups though their functionalkity and sturture is same.At present the Search happens only within the database.
What I am looking for is a search which should happen across databases for a particular keyword and display the result in a page or view.
For this I have selected a search field say in my case is the Client Name which is same across all the databases.In my search field i do a lookup on all the cleint names available across all the databases for this i will need to club or concatenate the @dblookup formula so that it searches all my databases and gives me a drop down of all the client names existing across all databases.
After selecting the client name i hit the search button which then gives me the list of client details present across databases.
i need to know how will i club the @dblookup formula to lookup across all the databases and get the desired result.
Subject: RE: Designer help reqd
@dblookup does not work in columns. You’ll have to go with putting the results in a computed value inside a page. You can concatenate lists using the : inbetween @dblookup formulas. Good luck!Heather Smith