CMDBuild Forum

"IdClass" type value

Old Versions
#1

Hi,

 

I Have a motherClass "SuperClass" with two childs and I would like use the attribute "IdClass" to know how many times "ChildClass1" is used from all "MotherClass" rows

In my sql query i writted " Select * from "Classmere" where "IdClass" = 'Classefille1' ; "

it's can't work because "IdClass" has a regClass type and i don't know what is it !!

My question is how can i do to test the IdClass value ??

 

Regards
#2

Hi,

if for example "Asset" is a superclass and "Monitor" is a subclass

you can write:

    select * from "Asset" where "IdClass" = '"Monitor"'::regclass;

CMDBuild team

#3

Previously Tecnoteca wrote:

Hi,

if for example "Asset" is a superclass and "Monitor" is a subclass

you can write:

    select * from "Asset" where "IdClass" = '"Monitor"'::regclass;

CMDBuild team

 

Thank's, that's what i need

 

Regards.