How to access the type of a Part (property)

[jplusip]

So, in a SysML project, I have some parts (otherwise Properties) that are being typed by defined valueTypes. I would like to extract this type in a SQL statement, but all Object_Type extracts is Property (which is the type).

Is there an alternate "Object_Type" that I can use to grab this information?

[Geert Bellekens]

Educated guess: join t_object again using the Classifier column.

Geert

[Eve]

Educated guess: join t_object again using the Classifier column.

Geert

join t_object.ea_guid = t_object2.PDATA1

[jplusip]

Thanks for the responses, but I'm still having some issues (admittedly, I went a different direction before checking in here again).

So, to be clear, I'm making a custom SQL query in the document template editor. Currently (testing this in a small dummy model), I have the following SQL query:

select p.Name as Property, v.Name as Type
from t_object as p, t_object as v
where v.Object_ID = p.Classifier
order by p.Name, v.Name

It seems to me that this should work. However, nothing is being displayed on the generated documents. Any idea of why that is?

Edit:
Tried out Simon's approach using ea_guid and PDATA1 and that worked like a charm! Thanks Simon! Still, out of curiosity, why doesn't the .Classifier work in this case? According to qwerty's book that should be the primary key for the classifier.

[qwerty]

PDATA1 contains the guid of the classifier. Which part of my book are you referring to?

q.

[Eve]

This decision was before my time here. But I believe that technically this relationship is not a classifier. (Classifier is the opposite of the instance property and there's no instances in use)

[jplusip]

PDATA1 contains the guid of the classifier. Which part of my book are you referring to?

q.

2.1.5 Misc on p. 8. Then below is PDATA1, but I don't see anything about a classifier there.

Admittedly, your book has possibly been updated in the year+ since I originally purchased it.

[qwerty]

Looks like this table needs an update :-)

q.