Question

How to find out your Creatio version while using PostgreSQL

12:11 Mar 21, 2023

All the solutions ive found to find your current Creatio version/distribution require you to use a specific MSSQL SQL query that doesnt work with PostgreSQL and doesnt seem to have any easy syntax conversion, does anyone have any ideas?

3 comments

Best reply

keith schmitt

14:03 Mar 22, 2023

Oliver Crowe,

Use 'Product Version'

SELECT "Name", "TextValue"  FROM public."SysSettings" 
left join public."SysSettingsValue"  on public."SysSettings"."Id" = Public."SysSettingsValue"."SysSettingsId" 
where  "Name" = 'Product version'

keith schmitt

21:51 Mar 21, 2023

SELECT "Name", "TextValue"  FROM public."SysSettings" 
left join public."SysSettingsValue"  on public."SysSettings"."Id" = Public."SysSettingsValue"."SysSettingsId" 
where  "Name" = 'Configuration version'

Oliver Crowe

11:17 Mar 22, 2023

keith schmitt,

How do you get it to involve the product distribution? eg Sales enterprise/Studio

keith schmitt

14:03 Mar 22, 2023

Oliver Crowe,

Use 'Product Version'

SELECT "Name", "TextValue"  FROM public."SysSettings" 
left join public."SysSettingsValue"  on public."SysSettings"."Id" = Public."SysSettingsValue"."SysSettingsId" 
where  "Name" = 'Product version'

Show all comments