Query Creatio Data: Difference between revisions
No edit summary |
No edit summary |
||
| Line 33: | Line 33: | ||
>querydb Account "contains(Name,'a')" "Id,Name" "NAME ASC" | >querydb Account "contains(Name,'a')" "Id,Name" "NAME ASC" | ||
[[File:Creatio querydb.png|thumb]] | [[File:Creatio querydb.png|thumb]] | ||
--- | |||
So of course this is a fairly basic example. What about GUID fields. Lets say the requirement is to get the data into a Data mart of warehouse and really we dont want or need the GUID but we do need the translation or lookup code so people can write simpler queries in SQL. | |||
Revision as of 11:18, 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"
---
So of course this is a fairly basic example. What about GUID fields. Lets say the requirement is to get the data into a Data mart of warehouse and really we dont want or need the GUID but we do need the translation or lookup code so people can write simpler queries in SQL.
