OQL Scala Error
0
Hey Guys, I think that I am implementing my statement correctly, however I know I am doing something incorrect. Essentially, all I am trying to to is pull three records from an entity (Please See log and screenshots below). And finally, I would like to pass explicit params to the query after I retrieve data. Any thoughts? If you are not too busy could I see of an example and instructions for proper implementation? OQL Log scala.MatchError List() (of class scala.collection.immutable.Nil$) com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): InternalOqlTextGetRequest (depth = -1): SELECT (*) FROM Application.current_audit_service_item_mod_record at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:110) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): InternalOqlTextGetRequest (depth = -1): SELECT (*) FROM Application.current_audit_service_item_mod_record at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:110) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): InternalOqlTextGetRequest (depth = -1): SELECT (*) FROM Application.current_audit_service_item_mod_record at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:110) Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): InternalOqlTextGetRequest (depth = -1): SELECT (*) FROM Application.current_audit_service_item_mod_record at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:110) Caused by: An exception has occurred for the following request(s): InternalOqlTextGetRequest (depth = -1): SELECT (*) FROM Application.current_audit_service_item_mod_record at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:110) Caused by: Input 'SELECT (*) FROM Application.current_audit_service_item_mod_record' could not be parsed Error on line 1 character 8: no viable alternative at input '(*' Error on line 1 character 9: mismatched input ')' expecting {CASE, '(', '+', '-', NULL, TRUE, FALSE, SUM, COUNT, AVG, MIN, MAX, CAST, COALESCE, DATEPART, DATEDIFF, ROUND, RANGEBEGIN, RANGEEND, LENGTH, NEXTVALUE, NATURAL, REAL, AT_SIGN, OPEN_QUOTE, IDENTIFIER, VARIABLE, STRING_LITERAL} at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:110) Caused by: List() (of class scala.collection.immutable.Nil$) at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:110)
asked
Chet S
2 answers
0
When you remove the braces around the * it should work, SELECT * FROM
answered
Thomas Lindenhofer
0
Thank you so much, It does look like the query is executing, however there is an associative table in the database that is not populated. Shouldn’t my target output entity just contain results? I don’t understand why OQL creates an association table that denotes an associative ID field that is not explicitly shown in my domain model.
answered
Chet S