Query Creatio Data: Difference between revisions
From Apps for Creatio
No edit summary |
No edit summary |
||
| Line 32: | Line 32: | ||
>querydb Account "contains(Name,'a')" "Id,Name" "NAME ASC" | >querydb Account "contains(Name,'a')" "Id,Name" "NAME ASC" | ||
[[File:Creatio querydb.png|thumb]] | |||
Revision as of 09:55, 9 April 2025
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"
