Query Creatio Data
From Apps for Creatio
For Creatio: eg.addserver creatio "<ALIAS>" "<URL>" "<USERNAME>" "<PASSWORD>"
Example walk through
A.
>addserver creatio "creatio2215" "https://server2215.creatio.com" "Supervisor" "******"
This sets up creatio as a connection in the App
B.
List the tables(collections) in the system
>dbtables
C.
See the columns in a table (collection)
>describe Account
D.
Query some data
querydb <ENTITY> "<FILTER>" "<COMMALISTOFFIELDS>" "<ORDERBY>" "<CUSTOMPARAMS>" <ENTER>
Example
>querydb Account "contains(Name,'a')" "Id,Name" "NAME ASC"
