How to get all the names of the classes which inherits %Persistent

Question

Question

CM Wang · Aug 15, 2017

#Object Data Model #Caché

I want to retrieve all the names of classes which are %Persistent in a namespace by COS.

Any suggestion, Thanks.

Discussion (8)0

Log in or sign up to continue

Robert Cemper · Aug 15, 2017

ClassReference of %Library.Persistent shows it as sub classes

http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?P...

2 0

Dan Pasco · Aug 15, 2017

SYSTEM is not a valid filter. That keyword allows the class compiler to organize classes into compile 'groups' so that a class that may depend on another class at compile time is guaranteed to have the dependency resolved.

It isn't an indicator that the class originated in %SYS/%CACHELIB.

0 0

score 1 · Answer 1 · 2017-08-15T15:50:29-04:00

Programmatically you can use the SubclassOf() query in the %Dictionary.ClassDefinitionQuery class. Pass in %Persistent and the flag for non-system classes.

score 0 · Answer 2 · 2017-08-15T16:04:25-04:00

It seems like any classes defined in %SYS would also returned by this method.

Any way to filter them out? Thanks.

score 0 · Answer 3 · 2017-08-15T16:22:29-04:00

You could then iterate through the returned classes and check to see which ones are marked "system" by opening up each definition. I seem to vaguely remember a way to do this with a query but I can't find it now.

score 2 · Answer 4 · 2017-08-15T16:25:00-04:00

SQL join or is there something more elaborate?

SELECT cd.name
FROM %Dictionary.ClassDefinition cd
JOIN subclassofquery sq ON sq.Name = cd.Name
WHERE cd.System IS NULL

score 0 · Answer 5 · 2017-08-15T16:32:34-04:00

Robert Cemper · Aug 15, 2017

high comfort service !

0 0

score 0 · Answer 6 · 2017-08-17T06:04:00-04:00

John Murray · Aug 17, 2017

I have just posted an article here about how to determine whether a class is mapped.

0 0