Question

Process library

Arkadiusz Polus
10:40 Oct 10, 2023

Hi, 

it is possible to add description of process to process library - list view ?

I don't see it in fields to display.

Like 0

Like

2 comments
Anhelina
17:13 Oct 11, 2023

Hello Arkadiusz,

Unfortunately it’s impossible. You can read more about it in this article:

https://community.creatio.com/questions/display-process-description?_gl…

Best regards, Anhelina!

Anhelina
16:46 Oct 17, 2023

 

Hello Arkadiusz,

I found one hack how to add a “Description” column. It will only work in the selected product language. If you work with one language, this method can help you.

  1. You have to replace “VwProcessLib” in Advanced settings, add new column and publish schema.
  2. In All packages use filtration by type, select SQL script, search for “VwProcessLib”. Copy code of script based on your DB (VwProcessLibMSSql / VwProcessLibOracle / VwProcessLibPostgreSql).
  3. In Custom package create new SQL Script, paste code from p.2 and add new logic (for example in VwProcessLibPostgreSql you should add new code between 76,77 lines):
...
	END AS "IsProcessTracing",
	(select slv."Value" from "SysLocalizableValue" slv
	where slv."SysCultureId" = 'A5420246-0A8E-E111-84A3-00155D054C03'
	 and slv."SysSchemaId" = "VwSysSchemaInWorkspace"."Id"
	 and slv."Key" = 'Description') as "UsrProcessDescription"
FROM public."VwSysSchemaInWorkspace"
...

      4. Find SQL Script from p.3 in Custom folder and click Install.

P.S. where slv."SysCultureId" = “ID of needed language”

You can find ID of language in SysCulture table (check Name and id column)

UsrProcessDescription - name of new column from p.1

 

Show all comments