Data Model | InterSystems Developer Community

Question

Chris Stewart · Jun 9, 2016

I've been building up a REST services API, consisting of a dozen or so classes referenced from a Dispatch class, which has route mappings for the first piece of the URI. I'd like to have the Dispatch class be able to output all of the available Services, with some documentation. Is there something like a %Library resource that I could use to pull this information from each of the classes?

Thanks

Chris

#Data Model #REST API #Mapping #Caché

0 7

0 797

Question

Stephen Wilson · Oct 18, 2016

How do you add a Total Phones column populated by SQL COUNT(*) expression in the Zen Quickstart Tutorial?

I have been following the online Zen Quickstart Tutorial using the lastest release documentation. In addition to playing around with the styling and making a few minor functionality tweaks, I wanted to add an additional column that shows a count of the number of phone numbers for that Contact (as shown in the image below).

#Data Model #Object Data Model #SQL #Tutorial #ZEN #Caché

0 4

0 441

Question

Claudio Devecchi · Jul 7, 2016

get DocumentId column from DocDM

Does anybody know how can I get the DocumentId property from a DocDM repository using SQL?. So far my SQL is like this:

SELECT name,email,gender FROM JSON_TABLE(
'person',
'$' COLUMNS(
name VARCHAR(100) PATH '$.name',
email VARCHAR(100) PATH '$.email',
gender VARCHAR(2) PATH '$.gender'
)
)

Thanks!

#Data Model #Document Data Model (NoSQL) #Caché

0 2

0 336