Tweet
Hello,
I have a problem when creating a Workflow.
Assumptions: After adding the meeting as at 30/03/2018, a task should be created with items to be completed before the meeting with date 27/03/2018
After setting, the workflow always adds day start in the task: from now - 3 days, but I want day start (meeting) - 3 days
Forgive me my English
An error occurs in data / logs:
[2018-03-23 10:22:45] Espo.WARNING: E_WARNING: Illegal offset type in isset or empty {"code":2,"message":"Illegal offset type in isset or empty","file"
:"/var/www/html/espocrm/application/Espo/Modules/Advanced/Core/Workflow/Utils.php","line":304,"context":{"entity":"[object] (Espo\\Modules\\Crm\\Entiti
es\\Task: {"id":null,"fields":{"id":{"dbType":"varc har","len":24,"type":"id"},"name":{"type ":"varchar","len":255},"deleted":{
"type":"bool","default":false},"status":{\ "type":"varchar","default":"Not Started","len":255},"priority":{"type":"va rchar","def
ault":"Normal","len":255},"dateStart":{"ty pe":"datetime","notNull":false},"dateEnd":{ "type":"datetime","notNull":false},"dateSta r
tDate":{"type":"date","notNull":false},"da teEndDate":{"type":"date","notNull":false}, "dateCompleted":{"type":"datetime","notNull \
":false},"isOverdue":{"type":"bool","notNul l":true,"notStorable":true,"default":false},\ "reminders":{"type":"jsonArray","notStorable \
":true},"description":{"type":"text"},"crea tedAt":{"type":"datetime","notNull":false}, "modifiedAt":{"type":"datetime","notNull": f
alse},"parentId":{"dbType":"varchar","len" :24,"type":"foreignId","index":"parent"," notNull":false},"parentType":{"type":"foreig n
Type","notNull":false,"index":"parent","le n":100,"dbType":"varchar"},"parentName":{" type":"varchar","notStorable":true,"relation \
":"parent","isParentName":true},"accountId": {"dbType":"varchar","len":24,"type":"fore ignId","index":true,"notNull":false},"accoun t
Name":{"type":"foreign","notStorable":false ,"relation":"account","foreign":"name"}," contactId":{"dbType":"varchar","len":24,"t y
pe":"foreignId","index":true,"notNull":fals e},"contactName":{"type":"foreign","notStor able":false,"relation":"contact","foreign":[
"firstName"," ","lastName"]},"createdById":{"dbType":"varchar","len": 24,"type":"foreignId","index":true,"notNull ":false},"create
dByName":{"type":"foreign","notStorable":fa lse,"relation":"createdBy","foreign":["firstName"," ","lastName"]},"modifiedById":{"db
Type":"varchar","len":24,"type":"foreignId ","index":true,"notNull":false},"modifiedByN ame":{"type":"foreign","notStorable":false, \
"relation":"modifiedBy","foreign":["firstName"," ","lastName"]},"assignedUserId":{"dbType":"varchar","len ":24,"type":"foreignId"
,"index":true,"notNull":false},"assignedUserN ame":{"type":"foreign","notStorable":false, "relation":"assignedUser","foreign":["firstN
ame"," ","lastName"]},"teamsIds":{"type":"varchar","notStorable ":true,"isLinkMultipleIdList":true,"relation" :"teams"},"teamsNames"
:{"type":"varchar","notStorable":true},"att achmentsIds":{"type":"varchar","notStorable\ ":true},"attachmentsNames":{"type":"varchar" ,
"notStorable":true},"isFollowed":{"type":"v archar","notStorable":true},"followersIds":{\ "type":"jsonArray","notStorable":true},"foll o
wersNames":{"type":"jsonObject","notStorable ":true},"attachmentsTypes":{"type":"jsonObje ct","notStorable":true}},"relations":{"conta c
t":{"type":"belongsTo","entity":"Contact" ,"key":"contactId","foreignKey":"id","for eign":null},"account":{"type":"belongsTo",\ "
entity":"Account","key":"accountId","forei gnKey":"id","foreign":null},"parent":{"typ e":"belongsToParent","key":"parentId"},"te a
ms":{"type":"manyMany","entity":"Team"," relationName":"entityTeam","midKeys":["entity_id","team_id"],"conditions":{"entityType":
"Task"},"additionalColumns":{"entityType":{\ "type":"varchar","len":100}}},"assignedUser\ ":{"type":"belongsTo","entity":"User","ke y
":"assignedUserId","foreignKey":"id","fore ign":"tasks"},"modifiedBy":{"type":"belong sTo","entity":"User","key":"modifiedById" ,
"foreignKey":"id","foreign":null},"createdB y":{"type":"belongsTo","entity":"User"," key":"createdById","foreignKey":"id","fore i
gn":null},"attachments":{"type":"hasChildren ","entity":"Attachment","foreignKey":"pare ntId","foreignType":"parentType","foreign": \
"parent"}}})","fieldName":["parentId","parentType"],"fieldList":{"id":{"dbType":"varchar","len":24 ,"t ype":"id"},"name":{"type":"varchar","len":255},"d
eleted":{"type":"bool","default":false},"status":{ "type":"varchar","default":"Not Started","len":255},"priority":{"type":"varchar"," default":"Normal","
len":255},"dateStart":{"type":"datetime","notNull " :false},"dateEnd":{"type":"datetime","notNull":fal se},"dateStartDate":{"type":"date","notNull":false }
,"dateEndDate":{"type":"date","notNull":false}, "da teCompleted":{"type":"datetime","notNull":false}," isOverdue":{"type":"bool","notNull":true,"notStora b
le":true,"default":false},"reminders":{"type":"j so nArray","notStorable":true},"description":{"type": "text"},"createdAt":{"type":"datetime","notNul l":f a
lse},"modifiedAt":{"type":"datetime","notNull":fal se},"parentId":{"dbType":"varchar","len":24,"type" :"foreignId","index":"parent","notNull":false}, "pa r
entType":{"type":"foreignType","notNull":false,"in dex":"parent","len":100,"dbType":"varchar"},"pare n tName":{"type":"varchar","notStorable":true,"relat i
on":"parent","isParentName":true},"accountId":{" db Type":"varchar","len":24,"type":"foreignId","index ":true,"notNull":false},"accountName":{"type": "for e
ign","notStorable":false,"relation":"account","fo r eign":"name"},"contactId":{"dbType":"varchar","len ":24,"type":"foreignId","index":true,"notNull" :fal s
e},"contactName":{"type":"foreign","notStorable": f alse,"relation":"contact","foreign":["firstName"," ","lastName"]},"createdById":{"dbType":"varchar","
len":24,"type":"foreignId","index":true,"notNull" : false},"createdByName":{"type":"foreign","notStora ble":false,"relation":"createdBy","foreign":["first
Name"," ","lastName"]},"modifiedById":{"dbType":"varchar","len":24,"t yp e":"foreignId","index":true,"notNull":false},"m odi fiedByName":{"type":"foreign",
"notStorable":false,"relation":"modifiedBy","f orei gn":["firstName"," ","lastName"]},"assignedUserId":{"dbType":"varchar","len":24, "t ype":"foreignId","i
ndex":true,"notNull":false},"assignedUserName":{"t ype":"foreign","notStorable":false,"relation":"as s ignedUser","foreign":["firstName"," ","lastName"]},
"teamsIds":{"type":"varchar","notStorable":tru e,"i sLinkMultipleIdList":true,"relation":"teams"},"tea msNames":{"type":"varchar","notStorable":true},"at t
achmentsIds":{"type":"varchar","notStorable":true} ,"attachmentsNames":{"type":"varchar","notStora ble ":true},"isFollowed":{"type":"varchar","notSto rabl e
":true},"followersIds":{"type":"jsonArray","no tSto rable":true},"followersNames":{"type":"jsonObject" ,"notStorable":true},"attachmentsTypes":{"type" :"j s
onObject","notStorable":true}}}} []
I have a problem when creating a Workflow.
Assumptions: After adding the meeting as at 30/03/2018, a task should be created with items to be completed before the meeting with date 27/03/2018
After setting, the workflow always adds day start in the task: from now - 3 days, but I want day start (meeting) - 3 days
Forgive me my English
An error occurs in data / logs:
[2018-03-23 10:22:45] Espo.WARNING: E_WARNING: Illegal offset type in isset or empty {"code":2,"message":"Illegal offset type in isset or empty","file"
:"/var/www/html/espocrm/application/Espo/Modules/Advanced/Core/Workflow/Utils.php","line":304,"context":{"entity":"[object] (Espo\\Modules\\Crm\\Entiti
es\\Task: {"id":null,"fields":{"id":{"dbType":"varc har","len":24,"type":"id"},"name":{"type ":"varchar","len":255},"deleted":{
"type":"bool","default":false},"status":{\ "type":"varchar","default":"Not Started","len":255},"priority":{"type":"va rchar","def
ault":"Normal","len":255},"dateStart":{"ty pe":"datetime","notNull":false},"dateEnd":{ "type":"datetime","notNull":false},"dateSta r
tDate":{"type":"date","notNull":false},"da teEndDate":{"type":"date","notNull":false}, "dateCompleted":{"type":"datetime","notNull \
":false},"isOverdue":{"type":"bool","notNul l":true,"notStorable":true,"default":false},\ "reminders":{"type":"jsonArray","notStorable \
":true},"description":{"type":"text"},"crea tedAt":{"type":"datetime","notNull":false}, "modifiedAt":{"type":"datetime","notNull": f
alse},"parentId":{"dbType":"varchar","len" :24,"type":"foreignId","index":"parent"," notNull":false},"parentType":{"type":"foreig n
Type","notNull":false,"index":"parent","le n":100,"dbType":"varchar"},"parentName":{" type":"varchar","notStorable":true,"relation \
":"parent","isParentName":true},"accountId": {"dbType":"varchar","len":24,"type":"fore ignId","index":true,"notNull":false},"accoun t
Name":{"type":"foreign","notStorable":false ,"relation":"account","foreign":"name"}," contactId":{"dbType":"varchar","len":24,"t y
pe":"foreignId","index":true,"notNull":fals e},"contactName":{"type":"foreign","notStor able":false,"relation":"contact","foreign":[
"firstName"," ","lastName"]},"createdById":{"dbType":"varchar","len": 24,"type":"foreignId","index":true,"notNull ":false},"create
dByName":{"type":"foreign","notStorable":fa lse,"relation":"createdBy","foreign":["firstName"," ","lastName"]},"modifiedById":{"db
Type":"varchar","len":24,"type":"foreignId ","index":true,"notNull":false},"modifiedByN ame":{"type":"foreign","notStorable":false, \
"relation":"modifiedBy","foreign":["firstName"," ","lastName"]},"assignedUserId":{"dbType":"varchar","len ":24,"type":"foreignId"
,"index":true,"notNull":false},"assignedUserN ame":{"type":"foreign","notStorable":false, "relation":"assignedUser","foreign":["firstN
ame"," ","lastName"]},"teamsIds":{"type":"varchar","notStorable ":true,"isLinkMultipleIdList":true,"relation" :"teams"},"teamsNames"
:{"type":"varchar","notStorable":true},"att achmentsIds":{"type":"varchar","notStorable\ ":true},"attachmentsNames":{"type":"varchar" ,
"notStorable":true},"isFollowed":{"type":"v archar","notStorable":true},"followersIds":{\ "type":"jsonArray","notStorable":true},"foll o
wersNames":{"type":"jsonObject","notStorable ":true},"attachmentsTypes":{"type":"jsonObje ct","notStorable":true}},"relations":{"conta c
t":{"type":"belongsTo","entity":"Contact" ,"key":"contactId","foreignKey":"id","for eign":null},"account":{"type":"belongsTo",\ "
entity":"Account","key":"accountId","forei gnKey":"id","foreign":null},"parent":{"typ e":"belongsToParent","key":"parentId"},"te a
ms":{"type":"manyMany","entity":"Team"," relationName":"entityTeam","midKeys":["entity_id","team_id"],"conditions":{"entityType":
"Task"},"additionalColumns":{"entityType":{\ "type":"varchar","len":100}}},"assignedUser\ ":{"type":"belongsTo","entity":"User","ke y
":"assignedUserId","foreignKey":"id","fore ign":"tasks"},"modifiedBy":{"type":"belong sTo","entity":"User","key":"modifiedById" ,
"foreignKey":"id","foreign":null},"createdB y":{"type":"belongsTo","entity":"User"," key":"createdById","foreignKey":"id","fore i
gn":null},"attachments":{"type":"hasChildren ","entity":"Attachment","foreignKey":"pare ntId","foreignType":"parentType","foreign": \
"parent"}}})","fieldName":["parentId","parentType"],"fieldList":{"id":{"dbType":"varchar","len":24 ,"t ype":"id"},"name":{"type":"varchar","len":255},"d
eleted":{"type":"bool","default":false},"status":{ "type":"varchar","default":"Not Started","len":255},"priority":{"type":"varchar"," default":"Normal","
len":255},"dateStart":{"type":"datetime","notNull " :false},"dateEnd":{"type":"datetime","notNull":fal se},"dateStartDate":{"type":"date","notNull":false }
,"dateEndDate":{"type":"date","notNull":false}, "da teCompleted":{"type":"datetime","notNull":false}," isOverdue":{"type":"bool","notNull":true,"notStora b
le":true,"default":false},"reminders":{"type":"j so nArray","notStorable":true},"description":{"type": "text"},"createdAt":{"type":"datetime","notNul l":f a
lse},"modifiedAt":{"type":"datetime","notNull":fal se},"parentId":{"dbType":"varchar","len":24,"type" :"foreignId","index":"parent","notNull":false}, "pa r
entType":{"type":"foreignType","notNull":false,"in dex":"parent","len":100,"dbType":"varchar"},"pare n tName":{"type":"varchar","notStorable":true,"relat i
on":"parent","isParentName":true},"accountId":{" db Type":"varchar","len":24,"type":"foreignId","index ":true,"notNull":false},"accountName":{"type": "for e
ign","notStorable":false,"relation":"account","fo r eign":"name"},"contactId":{"dbType":"varchar","len ":24,"type":"foreignId","index":true,"notNull" :fal s
e},"contactName":{"type":"foreign","notStorable": f alse,"relation":"contact","foreign":["firstName"," ","lastName"]},"createdById":{"dbType":"varchar","
len":24,"type":"foreignId","index":true,"notNull" : false},"createdByName":{"type":"foreign","notStora ble":false,"relation":"createdBy","foreign":["first
Name"," ","lastName"]},"modifiedById":{"dbType":"varchar","len":24,"t yp e":"foreignId","index":true,"notNull":false},"m odi fiedByName":{"type":"foreign",
"notStorable":false,"relation":"modifiedBy","f orei gn":["firstName"," ","lastName"]},"assignedUserId":{"dbType":"varchar","len":24, "t ype":"foreignId","i
ndex":true,"notNull":false},"assignedUserName":{"t ype":"foreign","notStorable":false,"relation":"as s ignedUser","foreign":["firstName"," ","lastName"]},
"teamsIds":{"type":"varchar","notStorable":tru e,"i sLinkMultipleIdList":true,"relation":"teams"},"tea msNames":{"type":"varchar","notStorable":true},"at t
achmentsIds":{"type":"varchar","notStorable":true} ,"attachmentsNames":{"type":"varchar","notStora ble ":true},"isFollowed":{"type":"varchar","notSto rabl e
":true},"followersIds":{"type":"jsonArray","no tSto rable":true},"followersNames":{"type":"jsonObject" ,"notStorable":true},"attachmentsTypes":{"type" :"j s
onObject","notStorable":true}}}} []
Comment