How to use %Dictionary API to retrieve some essences of the properties of the class

Question

Question

CJ H · Aug 20, 2018

Given the class name, how could I leverage the %Dictionary API to

1. Get the ID Key field

2. Check the ID Key field is Integer type.

3. Given a property name, how could I check there is a UNIQUE constraint/index on it and also the property is Integer type?

Thanks you.

Discussion (4)0

Log in or sign up to continue

Eduard Lebedyuk · Aug 20, 2018

1.

SELECT
parent As Class,
Properties
FROM %Dictionary.CompiledIndex
WHERE IdKey=1

2.

SELECT
parent As Class, Name, Type
FROM %Dictionary.CompiledProperty
WHERE Type='%Library.Integer' -- Name='Property' AND parent='Class'

3.

SELECT 1 As "Exists"
FROM %Dictionary.CompiledIndex
WHERE _Unique=1 AND parent = :Class AND Properties = :Property

0 0

score 0 · Answer 1 · 2018-08-20T12:22:11-04:00

Does your first query works for the child class under parent child relationship? I don't think there is an ID Key for the child table, but the first query still return the child table.

score 0 · Answer 2 · 2018-08-20T12:27:54-04:00

CJ H · Aug 20, 2018

never mind my previous question, because you just check "parent".

Thanks.

0 0

score 0 · Answer 3 · 2018-08-20T12:37:16-04:00

Eduard Lebedyuk · Aug 20, 2018

parent for index means class.

0 0