Skip to Content
0
Dec 22, 2022 at 12:21 PM

CMS Database --> Querybuilder vs. SQL vs. FHSQL

158 Views

Hi

Is there any detailed Documentation how I can Connect the CMS (Audit as well) with normal SQL Statements? QueryBuilder ist not really comfortable.


QueryBuilder:

image.png

Direct SQL

image.png

WEBI FHSQL like:
image.png

How can I see CMS Systemobjects with a SQL IDE like "SQL Developer" (I Only see CMS_InfoObjects7)

There are some good Documentation for QueryBuilder. Also for Virtual and Physical Tables. But is there a ER Diagram for the Systemdatabases? And how is the relationship between the Objects in QueryBuilder, SQL and FHSQL in Webi?

I appreciate your support,

Best regards, Arno

Attachments

image.png (2.5 kB)
image.png (3.4 kB)
image.png (2.7 kB)
image.png (5.1 kB)