xpages - view daterange , end date not correct -
i'm selecting documents in view daterange. start date alway correct end date isn't. selection goes startdate till last entry. code :
var vdaterange = session.createdaterange(sessionscope.selectedstartdate, sessionscope.selectedenddate); var projects:notesview = database.getview('visits_by_date_vb') var viewnav:notesviewnavigator = projects.createviewnav(); var viewentrycollection:notesviewentrycollection = projects.getallentriesbykey(vdaterange); var viewent:notesviewentry = viewentrycollection.getfirstentry(); var output:string = ""; while (viewent != null) { output += "<tr>"; output += "<td>" + viewent.getcolumnvalues()[0]; + "</td>"; output += "<td>" + viewent.getcolumnvalues()[3] + "</td>"; output += "<td>" + viewent.getcolumnvalues()[4] + "</td>"; output += "<td>" + viewent.getcolumnvalues()[5] + "</td>"; output += "</tr>"; viewent = viewnav.getnext(viewent); }
edit
picking dates following code :
<xe:djdatetextbox id="startdate" defaultvalue="#{javascript:sessionscope.selectedstartdate}" value="#{sessionscope.selectedstartdate}"> <xp:this.converter> <xp:convertdatetime type="date" datestyle="full"> </xp:convertdatetime> </xp:this.converter> </xe:djdatetextbox> <xe:djdatetextbox id="enddate" defaultvalue="#{javascript:sessionscope.selectedenddate}" value="#{sessionscope.selectedenddate}"> <xp:this.converter> <xp:convertdatetime type="date" datestyle="full"> </xp:convertdatetime> </xp:this.converter> </xe:djdatetextbox>
first column of view date /time "style" sorted ascending field on form stores dates date time field .
change 1 line
viewent = viewnav.getnext(viewent);
to
viewent = viewentrycollection.getnextentry(viewent);
and work.
you initialize viewnav
complete view content. that's why starts right date viewentrycollection runs view's end. don't need viewnav
in code , can delete line.
Comments
Post a Comment