CODEWITHSUNDEEP
joinimplicitintersystems-cache
ElJoNNo
ElJoNNo

Reputation: 11

How do you determin a parent/child relationship in Intersystems Cache?

I'm having trouble using implicit joins or Arrow joins "->". It's on an Intersystems Cache database. This is my code that isn't working

SELECT qcpr_arf_OC.AssessmentCategoryDataElement->AssessmentCategoryID FROM qcpr_arf_OC.AssessmentCategory

I've read through Intersystems Implicit join page http://docs.intersystems.com/ens20102/csp/docbook/DocBook.UI.Page.cls?KEY=GSQL_specialfeatures

And I tried to alter this one to work as it's also a for the QCPR application Intersystems Cache coding query

So am I doing something wrong or am I assuming a parent/child relationship when there is none? If so how do I tell? Thank you to everyone for your time.

Upvotes: 1

Views: 222

Answers (1)

SSH
SSH

Reputation: 2553

The syntax you are using is correct, but without database schema it's difficult to find an actual error.

What I would suggest, is to use "Query Builder" to create your first few queries in Cache. It's accessible from Management Protal -> Explore -> SQL, "Execute Query" tab, and there is a "Query Builder" button above text area. Don't forget to switch to your application namespace.

Upvotes: 2

Related Questions