view daterange , end date not correct

Question

I'm selecting documents in a view by daterange. The start date is alway correct but the end date isn't. The selection goes from the startdate till the last entry. My code is :

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 up dates with 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 the view is a date /time "style" sorted Ascending The field on the form that stores the dates is a date time field .

How are your dates stored/formatted in sessionScope.selectedStartDate and sessionScope.selectedEndDate? — Per Henrik Lausten, Mar 17 '15 at 08:02
What do you mean the end date isn't correct? can you add a picture of the lookup columns in the view — Thomas Adrian, Mar 17 '15 at 08:48
I mean the entries (viewEnt) are gooing beyond the end date of the vDateRange. — Marc Jonkers, Mar 17 '15 at 09:39

Knut Herrmann · Accepted Answer · 2015-03-17T20:38:11.273

2

Change this one line

viewEnt = viewNav.getNext(viewEnt);

to

viewEnt = viewEntryCollection.getNextEntry(viewEnt);

and it will work.

You initialize viewNav with the complete view content. That's why it starts with the right date from viewEntryCollection but runs always to view's end. You don't need the viewNav in this code and can delete this line.

edited Mar 17 '15 at 20:38

answered Mar 17 '15 at 20:16

Knut Herrmann

30,880
4
31
67

view daterange , end date not correct

1 Answers1