asked on

Retrieving Database Creation date remotely using formula language ???

Hello all ,

I have a doubt regarding database modification date retrival remotely .

Suppose i have two databases on the same server.

currentdb
remotedb

now i want to show the modification/creation date of remotedb into a form/view of currentdb . But the restiction is that i can use only formula language .

Is there any solution you guys have ??

One more thing which i want to tell u that i got another solution of this , which uses "Catalog.nsf" in which we get all those databases information. But @dblookup command works only for first sorted column . While in second column (which is not sorted) is occupied by database name , which is useful for me in this case . but because of limitation of first sorted column i am not able to process that . Can u guide me in this direction also ??

Thanks in advance.

SysExpert

All you would need to do is to create a new view sorted the way you want and add the proper columns.

You should do this on the Catalog template ( not the nsf ) so that the update in design are done automaticaly each night.

I hope this helps !

ASKER CERTIFIED SOLUTION

Sjef Bosman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

codeguru14

ASKER

@SysExpert;

I am using such a server which has restricted access and i don't have permissions to create new views / documents .. So if there is any other solution excpet creating views , please share with me.

@sjef_bosman;

I found it interesting , but the problem is that i don't have "ReplicaID" value with me . The value which i only know is the "database Name" and nothing else .
Here is the view Selection formula for "$replicaId" view :

SELECT @IsAvailable(ReplicaID)& @IsUnavailable(RepositoryType)

So it means that ReplicaID must be available . But i don't know the ReplicaID of remote database except knowing its name .

Sjef Bosman

Sorry, but no, that's not what it means. It means that only documents in that database are shown in the ($ReplicaID) view that match that condition: in the document there has to be a field ReplicaID and there must not be a field RepositoryType.

From your point of view, this seems irrelevant. You need to get a ReplicaID for a database. How are you planning to program this? What remotedb are you talking about? You seem to have a Domino Designer available, what are you allowed to do with it?

SOLUTION

SysExpert

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

marilyng

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial