OQL query Exception

0
Hi, I m trying to run the following query: select * from dataload.gsrl INNER JOIN dataload.gsrl/dataload.actvtypegsrl/dataload.actvtype WHERE dataload.actvtype/expttype_cd = '9027' But i m getting following exception: Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: 'dataload.actvtype' is not a valid entity type., exception occurred on mapping the following query: SELECT * FROM dataload.gsrl INNER JOIN dataload.gsrl/dataload.actvtypegsrl/dataload.actvtype WHERE dataload.actvtype/expttype_cd = '9027' at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.getMappedQueries(QueryMapper.java:259) Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: 'dataload.actvtype' is not a valid entity type. at com.mendix.connectionbus.util.LegacyModel$$anonfun$getMetaObject$1.apply(LegacyModel.scala:43) at com.mendix.connectionbus.util.LegacyModel$$anonfun$getMetaObject$1.apply(LegacyModel.scala:43) at scala.Option.getOrElse(Option.scala:121) at com.mendix.connectionbus.util.LegacyModel.getMetaObject(LegacyModel.scala:43) at com.mendix.connectionbus.DomainModelUtilImpl.getPersistableMetaObject(DomainModelUtil.scala:70) at com.mendix.connectionbus.DomainModelUtil$.getPersistableMetaObject(DomainModelUtil.scala:30) at com.mendix.connectionbus.DomainModelUtil.getPersistableMetaObject(DomainModelUtil.scala)
asked
4 answers
0

The message says there's no such thing as "dataload.actvtype".

Do you have an entity named "actvtype" in your dataload domain model?

answered
0

Yes i have but the name is ActvType. Is it case sensitive?

answered
0

Hi,

Thanks I figured it out :).

But i have one more question as you see in the query i have used one level of Association , can i use second level of association and query Example:

SELECT * FROM dataload.gsrl INNER JOIN dataload.gsrl/dataload.actvtypegsrl/dataload.actvtype/dataload.actvtypeonemoreentity/dataload.onemoreentity WHERE dataload.onemoreentity/String = 'str'

answered
0

You can use multiple levels of association in your path, but use _ to describe associations: for example, from one of my apps: INNER JOIN HS.Project/SafeguardingAudit.AuditID_Project/SafeguardingAudit.AuditID

HS.Project = module name HS.entity Project. SafeguardingAudit.AuditID_Project = module name SafeguardingAudit.entity AuditIDover association entity Project SafeguardingAudit.AuditID = module name SafeguardingAudit.. entity AuditID

And so on for as long as you have a path to follow that ends in an entity.

answered