Xpath error

0
I tried the following xpath retrieve: [day-from-dateTime(AanmaakDatum)=day-from-dateTime($Dag)] [month-from-dateTime(AanmaakDatum)=month-from-dateTime($Dag)] [year-from-dateTime(AanmaakDatum)=year-from-dateTime($Dag)] But this resulted in the following error: An error has occurred while handling the request. [User 'mxadmin' with roles 'Administrator'] -------- com.mendix.core.CoreException: Exception occurred in action 'Microflow [Rapportage.BerekenDagStatistiek]', all database changes executed by this action were rolled back at com.mendix.core.actionmanagement.CoreAction.d(SourceFile:553) Caused by: com.mendix.core.CoreException: Exception occurred in microflow 'Rapportage.BerekenDagStatistiek' for activity 'Call 'TelAantalAangemaakteFacturen'', all database changes executed by this microflow were rolled back at kP.b(SourceFile:251) Caused by: com.mendix.core.CoreException: Exception occurred in microflow 'Rapportage.TelAantalAangemaakteFacturen' for activity 'AggregateUsingDatabase', all database changes executed by this microflow were rolled back at kP.b(SourceFile:251) Caused by: com.mendix.core.CoreException: ac: An exception has occurred for the following request(s): jE (depth = -1): count(//Rapportage.RapportageData[day-from-dateTime(AanmaakDatum)=day-from-dateTime(1299106800000)] [month-from-dateTime(AanmaakDatum)=month-from-dateTime(1299106800000)] [year-from-dateTime(AanmaakDatum)=year-from-dateTime(1299106800000)]) at it.b(SourceFile:167) Caused by: ac: An exception has occurred for the following request(s): jE (depth = -1): count(//Rapportage.RapportageData[day-from-dateTime(AanmaakDatum)=day-from-dateTime(1299106800000)] [month-from-dateTime(AanmaakDatum)=month-from-dateTime(1299106800000)] [year-from-dateTime(AanmaakDatum)=year-from-dateTime(1299106800000)]) Caused by: ac: Exception occurred while retrieving data. (SQL State: 42883, Error Code: 0) Caused by: org.postgresql.util.PSQLException: ERROR: function pg_catalog.timezone(unknown, bigint) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 267 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at aw.a(SourceFile:388) at aw.a(SourceFile:292) at aw.a(SourceFile:167) at aw.a(SourceFile:156) at iB.a(SourceFile:47) at gl.a(SourceFile:182) at gl.a(SourceFile:140) at gl.a(SourceFile:88) at lx.a(SourceFile:69) at jC.a(SourceFile:47) at jm.a(SourceFile:222) at lF.b(SourceFile:68) at lF.a(SourceFile:43) at lF.executeAction(SourceFile:18) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) at it.b(SourceFile:155) at com.mendix.core.Core.retrieveXPathQueryAggregate(SourceFile:1319) at cb.b(SourceFile:94) at cb.a(SourceFile:27) at kP.a(SourceFile:66) at eO.executeAction(SourceFile:96) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) at it.b(SourceFile:155) at com.mendix.core.Core.executeSync(SourceFile:167) at is.a(SourceFile:71) at kP.a(SourceFile:66) at eO.executeAction(SourceFile:96) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) at it.b(SourceFile:155) at com.mendix.core.Core.execute(SourceFile:191) at dw.execute(SourceFile:183) at ju.a(SourceFile:299) at ju.a(SourceFile:230) at ju.processRequest(SourceFile:174) at fC.a(SourceFile:71) at com.mendix.core.MxRuntime.processRequest(SourceFile:916) at com.mendix.m2ee.server.handler.RuntimeHandler.handle(RuntimeHandler.java:42) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) at org.eclipse.jetty.server.Server.handle(Server.java:334) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1007) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:747) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:209) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:462) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436) at java.lang.Thread.run(Thread.java:662) Anybody a clue how to avoid this? I try to retrieve all objects on a certain date. I thought this was the way to do this using xpath?
asked
0 answers