Query Creatio Data - Revision history

CreatioWikiSysop at 18:17, 22 February 2026

2026-02-22T18:17:48Z

← Older revision		Revision as of 14:17, 22 February 2026
Line 23:		Line 23:

	>dbtables acc%		>dbtables acc%
	[[File:Creatio describe.png~~\|thumb~~]]		[[File:Creatio describe.png]]

	C.		C.
Line 34:		Line 34:

	>describe Account Createdbyid		>describe Account Createdbyid
	[[File:Creatio field props.png~~\|thumb~~]]		[[File:Creatio field props.png]]

CreatioWikiSysop at 18:17, 22 February 2026

2026-02-22T18:17:30Z

← Older revision		Revision as of 14:17, 22 February 2026
Line 23:		Line 23:

	>dbtables acc%		>dbtables acc%
			[[File:Creatio describe.png\|thumb]]

	C.		C.
Line 33:		Line 34:

	>describe Account Createdbyid		>describe Account Createdbyid
			[[File:Creatio field props.png\|thumb]]

CreatioWikiSysop at 18:15, 22 February 2026

2026-02-22T18:15:18Z

← Older revision		Revision as of 14:15, 22 February 2026
Line 22:		Line 22:
	You can filter also		You can filter also

	>dbtables acc%		>dbtables acc%

	C.		C.
Line 29:		Line 29:

	>describe Account		>describe Account

			And view a column

			>describe Account Createdbyid



	----		----

CreatioWikiSysop at 18:14, 22 February 2026

2026-02-22T18:14:44Z

← Older revision		Revision as of 14:14, 22 February 2026
Line 20:		Line 20:

	>dbtables		>dbtables
			You can filter also

			>dbtables acc%

	C.		C.

CreatioWikiSysop at 10:41, 9 May 2025

2025-05-09T10:41:38Z

← Older revision		Revision as of 06:41, 9 May 2025
Line 7:		Line 7:
	Syntax:		Syntax:

	>addserver creatio "<ALIAS>" "<URL>" "<USERNAME>" "<PASSWORD>"		>addserver creatio "<ALIAS>" "<URL>" "<USERNAME>" "<PASSWORD>"

	EG		EG

	>addserver creatio "live2026" "https://live2026.creatio.com" "Supervisor" "********"		>addserver creatio "live2026" "https://live2026.creatio.com" "Supervisor" "********"

	This sets up creatio as a connection in the App		This sets up creatio as a connection in the App
Line 19:		Line 19:
	List the tables(collections) in the system		List the tables(collections) in the system

	>dbtables		>dbtables

	C.		C.
Line 25:		Line 25:
	See the columns in a table (collection)		See the columns in a table (collection)

	>describe Account		>describe Account

	----		----

CreatioWikiSysop at 10:41, 9 May 2025

2025-05-09T10:41:21Z

← Older revision		Revision as of 06:41, 9 May 2025
Line 32:		Line 32:

	eq - equals/=		eq - equals/=

	ne - not equals/!=/<>		ne - not equals/!=/<>

	ge - greater than or equals/=		ge - greater than or equals/=

	le - less than or equals/=		le - less than or equals/=

	contains - a string contains a value		contains - a string contains a value

	Strings only		Strings only

	contains(Name,'a')		contains(Name,'a')

CreatioWikiSysop at 10:40, 9 May 2025

2025-05-09T10:40:57Z

← Older revision		Revision as of 06:40, 9 May 2025
Line 31:		Line 31:
	Filter strings and comparison commands		Filter strings and comparison commands

	eq - equals/=		eq - equals/=

	ne - not equals/!=/<>		ne - not equals/!=/<>

	ge - greater than or equals/=		ge - greater than or equals/=

	le - less than or equals/=		le - less than or equals/=

	contains - a string contains a value		contains - a string contains a value

	* Strings only		Strings only

			contains(Name,'a')

	~~contains(Name,'a')~~
	----		----

Line 50:		Line 51:
	Date values must be in ISO format		Date values must be in ISO format

	filter=StartDate ge ${from} and StartDate le ${to}		filter=StartDate ge ${from} and StartDate le ${to}

	Example ISO format		Example ISO format
Line 68:		Line 69:
	EG		EG

	$filter=Owner/Id eq 410006e1-ca4e-4502-a9ec-e54d922d2c00 and		$filter=Owner/Id eq 410006e1-ca4e-4502-a9ec-e54d922d2c00 and stage/id ne a9aafdfe-2242-4f42-8cd5-2ae3b9556d79
	stage/id ne a9aafdfe-2242-4f42-8cd5-2ae3b9556d79

	So if you have only the string (EG Qualification) you need to get the Id value. You can use "querydb" or a method designed for this called "getGuid"		So if you have only the string (EG Qualification) you need to get the Id value. You can use "querydb" or a method designed for this called "getGuid"
Line 75:		Line 75:
	EG in jint		EG in jint

	var _accInGuid = di.getGUID("OpportunityStage","Qualification")		var _accInGuid = di.getGUID("OpportunityStage","Qualification")

	ref: https://creatio.crmtogether.com/index.php?title=DI_Jint		ref: https://creatio.crmtogether.com/index.php?title=DI_Jint
Line 82:		Line 82:
	Query some data		Query some data

	querydb <ENTITY> "<FILTER>" "<COMMALISTOFFIELDS>" "<ORDERBY>" "<CUSTOMPARAMS>" <ENTER>		querydb <ENTITY> "<FILTER>" "<COMMALISTOFFIELDS>" "<ORDERBY>" "<CUSTOMPARAMS>" <ENTER>

	Example		Example

	>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]]






	---		---
Line 109:		Line 105:
	EG		EG

	>querydb Opportunity "" "Id,Title,{getLookup('OpportunityStage','StageId','StageCode')}" "Title DESC"		>querydb Opportunity "" "Id,Title,{getLookup('OpportunityStage','StageId','StageCode')}" "Title DESC"

	[[File:Creatio_getlookup.png]]		[[File:Creatio_getlookup.png]]

CreatioWikiSysop at 10:39, 9 May 2025

2025-05-09T10:39:47Z

← Older revision		Revision as of 06:39, 9 May 2025
Line 72:		Line 72:

	So if you have only the string (EG Qualification) you need to get the Id value. You can use "querydb" or a method designed for this called "getGuid"		So if you have only the string (EG Qualification) you need to get the Id value. You can use "querydb" or a method designed for this called "getGuid"

			EG in jint

			var _accInGuid = di.getGUID("OpportunityStage","Qualification")

			ref: https://creatio.crmtogether.com/index.php?title=DI_Jint
	----		----

CreatioWikiSysop at 10:36, 9 May 2025

2025-05-09T10:36:30Z

@@ Line 1: / Line 1: @@
 For Creatio: eg.addserver creatio "<ALIAS>" "<URL>" "<USERNAME>" "<PASSWORD>"
-Example walk through
+Syntax:
-A.
+EG
->addserver creatio "creatio2215" "<nowiki>https://server2215.creatio.com</nowiki>" "Supervisor" "******"
+>addserver creatio "live2026" "https://live2026.creatio.com" "Supervisor" "********"
 This sets up creatio as a connection in the App
@@ Line 23: / Line 27: @@
 >describe Account
-D.
+----
 Query some data

CreatioWikiSysop at 10:16, 9 May 2025

2025-05-09T10:16:51Z

← Older revision		Revision as of 06:16, 9 May 2025
Line 42:		Line 42:

	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.		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.

			To do this you use

			getLookup

			Params are
			* Collection to lookup for the value
			* Field to use
			* Column name in island dataset

			EG

			>querydb Opportunity "" "Id,Title,{getLookup('OpportunityStage','StageId','StageCode')}" "Title DESC"

			[[File:Creatio_getlookup.png]]

			and when we push this to the Data Islands cloud you can see the data

			[[File:Creatio_getlookup_trans.png]]

			So this is the equivailent of a join in SQL to get the data a user can see in a report for example.

			Its ideal if you need the data to upload to a reporting tool like PowerBI for example. Or import the island into a local database to use with a reporting tool of choice or import to a CSV and use in Excel.