Thanks Jeroen, I'll raise a ticket and maybe try to fix it too.
On Wed, Oct 19, 2016 at 8:14 AM, Jeroen van der Wal <jer...@stromboli.it> wrote: > Hi Stephen, > > I've created a separate branch in my personal fork of the kitchensink app > [1] and pasted some of your code there in order to reproduce the issue. > Could you please follow a similar pattern next time to allow faster > debugging? > > I have not debugged further but it might be an issue with storing Date > types in the viewmodel memento, could you raise a ticket in Jira? > > Cheers, > > Jeroen > > [1] https://github.com/jcvanderwal/isis-app-kitchensink/tree/bug-stephen > > On 12 October 2016 at 11:49, Stephen Cameron <steve.cameron...@gmail.com> > wrote: > > > Hi, > > > > I've done a bit more investigation on this but no solution, maybe someone > > can tell me what is happening? > > > > I've defined a View Model, objects properties will normally get seeded > from > > a database view but the behaviour is the same if I initialise the > property > > values directly. > > > > I have the action below to demonstrate the effect: > > > > public List<ActivityAttendanceSummary> listAttendanceData() { > > ArrayList<ActivityAttendanceSummary> list = new ArrayList<>(); > > Calendar calendar1 = new GregorianCalendar(2015,0,29); > > ActivityAttendanceSummary temp1 = new > ActivityAttendanceSummary(); > > temp1.setActivityId(1000L); > > temp1.setActivityName("Activity 1"); > > temp1.setAttendedCount(10); > > temp1.setCancelled(false); > > temp1.setRegionName("SOUTH"); > > temp1.setMaxEndDateTime(calendar1.getTime()); > > temp1.setMinEndDateTime(calendar1.getTime()); > > temp1.setMaxStartDateTime(calendar1.getTime()); > > temp1.setMinStartDateTime(calendar1.getTime()); > > list.add(temp1); > > > > Calendar calendar2 = new GregorianCalendar(2015,0,30); > > ActivityAttendanceSummary temp2 = new > ActivityAttendanceSummary(); > > temp2.setActivityId(1001L); > > temp2.setActivityName("Activity 2"); > > temp2.setAttendedCount(20); > > temp2.setCancelled(true); > > temp2.setRegionName("NORTH"); > > temp2.setMaxEndDateTime(calendar2.getTime()); > > temp2.setMinEndDateTime(calendar2.getTime()); > > temp2.setMaxStartDateTime(calendar2.getTime()); > > temp2.setMinStartDateTime(calendar2.getTime()); > > //list.add(temp2); > > return list; > > } > > > > The effect seen is that if there is only one object in the list then all > > the dates are displayed fine, whereas if there is two (I do add temp2) no > > dates for either temp1 or temp2 get displayed in the table but the other > > values I set do get displayed. > > > > The class ActivityAttendanceSummary is very simple: > > > > package au.com.scds.chats.dom.report.view; > > > > import java.util.Date; > > > > import javax.jdo.annotations.Extension; > > import javax.jdo.annotations.IdentityType; > > import javax.jdo.annotations.Inheritance; > > import javax.jdo.annotations.InheritanceStrategy; > > import javax.jdo.annotations.PersistenceCapable; > > import javax.jdo.annotations.Queries; > > import javax.jdo.annotations.Query; > > > > import org.apache.isis.applib.annotation.DomainObject; > > import org.apache.isis.applib.annotation.Editing; > > import org.apache.isis.applib.annotation.ViewModel; > > import org.joda.time.DateTime; > > > > @ViewModel > > @DomainObject(editing = Editing.DISABLED) > > @PersistenceCapable(identityType = IdentityType.NONDURABLE, table = > > "ActivityAttendanceSummary", extensions = { > > @Extension(vendorName = "datanucleus", key = "view-definition", > > value = "CREATE VIEW ActivityAttendanceSummary " > > + "( " + " {this.activityId}, " + " > {this.activityName}, > > " + " {this.regionName}, " > > + " {this.startDateTime}, " + " {this.cancelled}, " + " > > {this.attendedCount}, " > > + " {this.notAttendedCount}, " + " > > {this.hasStartAndEndDateTimesCount}, " > > + " {this.minStartDateTime}, " + " > > {this.maxStartDateTime}, " + " {this.minEndDateTime}, " > > + " {this.maxEndDateTime} " + ") AS " + "SELECT " + " > > activity.activity_id as activityId, " > > + " activity.name AS activityName, " + " > > activity.region_name AS regionName, " > > + " activity.startdatetime AS startDateTime, " + " > > activity.cancelled, " > > + " sum(case when attend.attended = TRUE then 1 else 0 > > end) as attendedCount, " > > + " sum(case when attend.attended = FALSE then 1 else 0 > > end) as notAttendedCount, " > > + " sum(case when attend.attended = TRUE AND not > > isnull(attend.startdatetime) AND not isnull(attend.enddatetime) then 1 > else > > 0 end) as hasStartAndEndDateTimesCount, " > > + " min(attend.startdatetime) as minStartDateTime, " > > + " max(attend.startdatetime) as maxStartDateTime, " + " > > min(attend.enddatetime) as minEndDateTime, " > > + " max(attend.enddatetime) as maxEndDateTime " + "FROM > " > > + " activity " + "LEFT OUTER JOIN" > > + " attend " + "ON " + " attend.activity_activity_id = > > activity.activity_id " + "GROUP BY" > > + " activity.activity_id") }) > > @Queries({ > > @Query(name = "allActivityAttendanceSummary", language = > "JDOQL", > > value = "SELECT FROM > > au.com.scds.chats.dom.report.view.ActivityAttendanceSummary"), > > @Query(name = "allActivityAttendanceSummaryForPeriodAndRegion", > > language = "JDOQL", value = "SELECT FROM > > au.com.scds.chats.dom.report.view.ActivityAttendanceSummary pa " > > + "WHERE pa.startDateTime >= :startDateTime && > > pa.startDateTime <= :endDateTime && pa.regionName == :region"), }) > > @Inheritance(strategy = InheritanceStrategy.NEW_TABLE) > > public class ActivityAttendanceSummary implements > > Comparable<ActivityAttendanceSummary> { > > > > private Long activityId; > > private String activityName; > > private String regionName; > > private Date startDateTime; > > private Boolean cancelled; > > private Integer attendedCount; > > private Integer notAttendedCount; > > private Integer hasStartAndEndDateTimesCount; > > private Date minStartDateTime; > > private Date maxStartDateTime; > > private Date minEndDateTime; > > private Date maxEndDateTime; > > > > public Long getActivityId() { > > return activityId; > > } > > > > public void setActivityId(Long activityId) { > > this.activityId = activityId; > > } > > > > public String getActivityName() { > > return activityName; > > } > > > > public void setActivityName(String activityName) { > > this.activityName = activityName; > > } > > > > public String getRegionName() { > > return regionName; > > } > > > > public void setRegionName(String regionName) { > > this.regionName = regionName; > > } > > > > public Date getStartDateTime() { > > return startDateTime; > > } > > > > public void setStartDateTime(Date startDateTime) { > > this.startDateTime = startDateTime; > > } > > > > public Boolean getCancelled() { > > return cancelled; > > } > > > > public void setCancelled(Boolean cancelled) { > > this.cancelled = cancelled; > > } > > > > public Integer getAttendedCount() { > > return attendedCount; > > } > > > > public void setAttendedCount(Integer attendedCount) { > > this.attendedCount = attendedCount; > > } > > > > public Integer getNotAttendedCount() { > > return notAttendedCount; > > } > > > > public void setNotAttendedCount(Integer notAttendedCount) { > > this.notAttendedCount = notAttendedCount; > > } > > > > public Integer getHasStartAndEndDateTimesCount() { > > return hasStartAndEndDateTimesCount; > > } > > > > public void setHasStartAndEndDateTimesCount(Integer > > hasStartAndEndDateTimesCount) { > > this.hasStartAndEndDateTimesCount = > hasStartAndEndDateTimesCount; > > } > > > > public Date getMinStartDateTime() { > > return minStartDateTime; > > } > > > > public void setMinStartDateTime(Date minStartDateTime) { > > this.minStartDateTime = minStartDateTime; > > } > > > > public Date getMaxStartDateTime() { > > return maxStartDateTime; > > } > > > > public void setMaxStartDateTime(Date maxStartDateTime) { > > this.maxStartDateTime = maxStartDateTime; > > } > > > > public Date getMinEndDateTime() { > > return minEndDateTime; > > } > > > > public void setMinEndDateTime(Date minEndDateTime) { > > this.minEndDateTime = minEndDateTime; > > } > > > > public Date getMaxEndDateTime() { > > return maxEndDateTime; > > } > > > > public void setMaxEndDateTime(Date maxEndDateTime) { > > this.maxEndDateTime = maxEndDateTime; > > } > > > > public String getMinStartDateTimeName() { > > if (getMinStartDateTime() == null) > > return null; > > else > > return getMinStartDateTime().toString(); > > } > > > > public String getMaxStartDateTimeName() { > > if (getMaxStartDateTime() == null) > > return null; > > else > > return getMaxStartDateTime().toString(); > > } > > > > public String getMinEndDateTimeName() { > > if (getMinEndDateTime() == null) > > return null; > > else > > return getMinEndDateTime().toString(); > > } > > > > public String getMaxEndDateTimeName() { > > if (getMaxEndDateTime() == null) > > return null; > > else > > return getMaxEndDateTime().toString(); > > } > > > > @Override > > public int compareTo(ActivityAttendanceSummary o) { > > // compare on name > > if (getActivityName() != null && o.getActivityName() != null) { > > if (!getActivityName().equals(o.getActivityName())) > > return getActivityName().compareTo(o.getActivityName()); > > } > > // compare on start date > > if (getStartDateTime() != null && o.getStartDateTime() != null) { > > if (getStartDateTime().equals(o.getStartDateTime())) > > return 0; > > else if (getStartDateTime().before(o.getStartDateTime())) > > return -1; > > else > > return 1; > > } > > // compare on activity Id > > if (getActivityId() != null && o.getActivityId() != null) { > > if (getActivityId().equals(o.getActivityId())) > > return 0; > > else if (getActivityId() < o.getActivityId()) > > return -1; > > else > > return 1; > > } else > > return 0; > > } > > > > } > > > > > > > > > > On Tue, Oct 4, 2016 at 11:58 AM, Stephen Cameron < > > steve.cameron...@gmail.com > > > wrote: > > > > > Hi, > > > > > > I've noticed that Dates and Joda DateTimes are not being shown in > Wicket > > > Viewer from a View Model class based on a database view. > > > > > > I am using 1.13.0 and a MySQL database. > > > > > > Its not critical at the moment, I'll look into it further soon. > > > > > > Steve > > > > > >
