tag:blogger.com,1999:blog-8878360187292205236.post6650922792798481922..comments2023-08-15T14:32:32.337+02:00Comments on @eclipsophy: Mylyn to MySQL: writing the queriesMaarten Meijerhttp://www.blogger.com/profile/05900699818398561644noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-8878360187292205236.post-6294159408175690642010-01-04T11:20:22.665+01:002010-01-04T11:20:22.665+01:00Hi, I have used your example to successfully conne...Hi, I have used your example to successfully connect to our postgresql GForge database. My problem is that my open tasks display as closed items and that I cannot edit any of the tasks.<br /><br />Closed items show the date they were closed, but it seems when completionDate is null it shows them as completed, but when I introspect a task with the developer tools there is no completion date attribute in the properties view. My query is as follows:<br /><br /> <select id="getForKey" resultClass="ibatisTask"><br /> SELECT<br /> (TIMESTAMP WITH TIME ZONE 'epoch' + close_date * INTERVAL '1 second') AS "completionDate",<br /> a.artifact_id as taskId,<br /> user_name AS owner,<br /> summary AS summary,<br /> priority AS priority,<br /> status_name AS issueStatus,<br /> field_data AS product,<br /> details as notes,<br /> (TIMESTAMP WITH TIME ZONE 'epoch' + open_date * INTERVAL '1 second') AS creationDate,<br /> null AS scheduledForDate,<br /> 0 as estimatedTimeHours<br /> FROM artifact a, users b, artifact_status c, artifact_extra_field_data d WHERE a.assigned_to = b.user_id and a.artifact_id = d.artifact_id and extra_field_id = 121 and a.status_id = c.id and a.artifact_id=#value#<br /> </select><br /><br />The creationDate works fine, but completionDate does not, even if I change the query like to make the completionDate equal to the creationDate (which works). All tasks seem to stay completed, and I cannot edit the task to make it not so.<br /><br />Can you give me some hints as to how to go about finding the problem?<br /><br />Zachzachhttps://www.blogger.com/profile/00231116481180622871noreply@blogger.com