result type: string
If a lookup attribute (ie. project.goal_code) are not listed in the pulldown try to write id in formula ;)
Be careful with syntax because some functions like DateDiff, internally the result can be negative but the attribute will displays with no minus symbol.!!
!!(If negative it will be displayed in red color and between bracket () symbols)
Boolean output Min(Max(DateDiff(Now(), prfinish,"Day"),0),1)
Calculated attribute+mappi>ng colors
-1 to -100 (red)
0 to 100 (green)
In views, Fields, configure field; Display Elements=Image
-Power filters are not SQL!
-The Power Filter is currently designed to search for values only. If you leave the field empty (NULL value) that field is not included in the filtering. There is no current functionality that allows the configuration of the power filter to search for NULL or NOT NULL values.
"wildcard" character in Oracle is a percentage "%", but Clarity handles that;
i.e. I enter a "*" in a Clarity LIKE condition and this is converted by Clarity to a "%" when the SQL hits the database.
note: on v7.5.3 on Oracle, both % and * worked as wildcards, since v8 only * has worked
project.schedule_finish >= dateMacro("today")+50
like( project.name, "Mi_" ) && notLike( project.name, "PR-" )
Syntax: dateMacro(“period name”)
Start conditions. to avoid to enter in the process. Include here the conditions required by steps.
To detect a change in on attribute: I.e of formula created by manual writing or generated from forms.
( project.status__oldValue != lookup("INVESTMENT_OBJ_STATUS", 1) && project.status == lookup("INVESTMENT_OBJ_STATUS", 1) ) || ( project.status__oldValue == lookup("INVESTMENT_OBJ_STATUS", 1) && project.status != lookup("INVESTMENT_OBJ_STATUS", 1) )Same expression (Clarity Evaluated)
( ( ( Project Status [Previous Value] != 'Approved' ) and ( Project Status = 'Approved' ) ) or ( ( Project Status [Previous Value] = 'Approved' ) and ( Project Status != 'Approved' ) ))Process Notification
Process have default message for notifications, and these messsages can be customized per each process.
Some generic tags:
when using "project" object