Hi all, Hey I want to see the latest document from the views when i click the hopspot .It’s very urgent .Can anyone solve this problem .Any help wus be highly appreciated .
My code is like There is a menu okay
Menu2=new Array(“Latest Arrivals”,“”,“”,5);
Menu2_1=new Array("Latest News ","http://news/pin.nsf/683cea2ffa120a9f65256c3900233d91/e69262c97fc2643b65256fbf003ecc41?OpenDocument","",0,20,75);
Menu2_2=new Array("Books","http://news/pin.nsf/Latest+Books+in+Current+Month?OpenView&Start=1&Count=30&Expand=1#1","",0);
There is a document number in the code but i want that when i feed any data in the form the latest one get automatically reflected on the web site when anyone click the "Latest News
thanx
Subject: it’s urgent:Want to see the latest document from the views
use db/view/$first and however the view is sorted this will open the first doc in the view.
example
http://www-10.lotus.com/ldd/nd6forum.nsf/DateAllThreadedweb/$first
Subject: RE: it’s urgent:Want to see the latest document from the views
Hi Jack, well I have done the same thing u told me.I sorted the view’s columns in descending order but it is showing the first document which i initially stored in the form everytime.I want the latest document .Please tell me asap
Thanx for helping me
kanishka
Subject: RE: it’s urgent:Want to see the latest document from the views
Post your updated code that shows the link so I can take a look. I’m not really sure what’s going on since the link I gave for this site seems to be working.
This shows the latest “main” doc from the thread view.
http://www-10.lotus.com/ldd/nd6forum.nsf/DateAllThreadedweb/$first
This shows the latest doc from the “flat” view.
http://www-10.lotus.com/ldd/nd6forum.nsf/DateAllFlatweb/$first
Subject: RE: it’s urgent:Want to see the latest document from the views
Hi Jack, well my problem is solved I had sone the same way as u told me Thanx.Actually Database is not showing the latest view immediately on the web may be that Database is taking time in doing the updation and when i update the index in the Database properties then it showed the changes after few minutes .Can u tell me y this problem is occuring .
n Thanc for solving my problem
regards
Kanishka
Subject: RE: it’s urgent:Want to see the latest document from the views
On the advanced tab of the properties for the view, what are your refresh index and discard index settings?
Subject: RE: it’s urgent:Want to see the latest document from the views
Refresh Index is : Auto after first use Discard Index :If Inactive for 45 days
Now tell me whether I’m using wrong properties
Thanx
kanishka
Subject: it’s urgent:Want to see the latest document from the views
Hi,
A fast solution :
-
sort the view by descending order (the last document is the first),
-
embbedded your view in form,
-
in properties of embedded view > “maximun display lines” > put “1”
and when your view is displayed, you see only one line and this line will be the last document…
A less fast solution :
-
Create a view, let’s say “ViewDocsIDs” with one column, descending order, column formula = @text(@DocumentUniqueID );
-
create a link with a computed text, with a formula something like this :
REM “Return the first doc id of view”
@Subset(@Dbcolumn(“”:“”;“”:“”;“ViewDocsIDs”;1);1)
- link will be something like this :
<a href=“htttp:\server\path\viewname"++”?openDocument">Open lastest document
There are also other soultions, I think…
HTH
Thierry