I am using the report composer and building my own templates.
Where can I find documentation for the properties available for various elements.
In particular, what are the properties of DBColumn and what children does it have?
Thanks,
Ion
Hello Ion,
Thank you for your message and you can find out details about the report template at http://www.visual-paradigm.com/support/documents/vpumluserguide/304_reportgenera.html
Best regards,
Rain Wong
I looked at the report template documentation. There is information about generic properties but nothing specific to DBColumn (like primary key, foreign key, etc.).
Maybe I’m missing something. Could you point me to the appropriate section that documents DBColumn?
Thanks,
Ion
Hi Ion ,
You can check if the column is a primary key with:
To show the column type:
To show the length with scale:
Hope this helps. Feel free to post again if you need any more help.
Best regards,
Jick Yeung
Thanks, it works.
Can you please tell me how I can determine if there is a foreign key on a column and which table and field is it referencing?
TIA.
Ion
Hi Ion,
You may use <ForEach property=“foreignKeyConstraints” …> to get the foreign key constraints (s) from a column.
Foreign key constraint has 2 properties:
refColumn (the opposite side’s Entity’s PK Column)
foreignKey (the relationship)
For your case, you refColumn.
So, use <MetaModelElement property=“refColumn” …> to get the column from the foreign key constraint.
Then use <ParentModel …> to get the table of the column
Best regards,
Jick Yeung