Query Creatio Data: Difference between revisions
From Apps for Creatio
Created page with " For Creatio: eg.addserver creatio "<ALIAS>" "<URL>" "<USERNAME>" "<PASSWORD>" Example >addserver creatio "creatio2215" "<nowiki>https://server2215.creatio.com</nowiki>" "Supervisor" "******" This sets up creatio as a connection in the App" |
No edit summary |
||
| Line 3: | Line 3: | ||
For Creatio: eg.addserver creatio "<ALIAS>" "<URL>" "<USERNAME>" "<PASSWORD>" | For Creatio: eg.addserver creatio "<ALIAS>" "<URL>" "<USERNAME>" "<PASSWORD>" | ||
Example | Example walk through | ||
A. | |||
>addserver creatio "creatio2215" "<nowiki>https://server2215.creatio.com</nowiki>" "Supervisor" "******" | >addserver creatio "creatio2215" "<nowiki>https://server2215.creatio.com</nowiki>" "Supervisor" "******" | ||
This sets up creatio as a connection in the App | 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" | |||
Revision as of 09:49, 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"
