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

Popular posts from this blog

node.js - Mongoose: Cast to ObjectId failed for value on newly created object after setting the value -

gradle error "Cannot convert the provided notation to a File or URI" -

python - NameError: name 'subprocess' is not defined -