show sql query when query ivy task

maidanh — Fri, 27 Jul 2018 04:55:35 -0400

Dear IvyTeam

How can I print sql query to log file when there are some get ivy task by query?

I followed this link https://answers.axonivy.com/questions/1585/hibernate-show_sql but it seem for project that using hibernate?

If I print query by method TaskQuery query.toString() I got some kind of query in log but it's not friendly with normal sql like below

SELECT *  
  FROM IWA_Task  
  LEFT JOIN IWA_TaskAdditionalProperty TaskAddPrp_isDeleted ON Column(IWA_TaskQuery.TaskId) = Column(IWA_TaskAdditionalProperty.TaskId)
  LEFT JOIN IWA_AdditionalProperty AddPrpTask_isDeleted ON Column(TaskAddPrp_isDeleted.AdditionalPropertyId) = Column(IWA_AdditionalProperty.AdditionalPropertyId)
  INNER JOIN IWA_CaseQuery ON (Column(IWA_CaseQuery.CaseId) = Column(IWA_TaskQuery.CaseId) || Column(IWA_CaseQuery.CaseId) = Column(IWA_TaskQuery.BusinessCaseId))
  LEFT JOIN IWA_CaseAdditionalProperty CaseAddPrp_taskType ON Column(IWA_Case.CaseId) = Column(IWA_CaseAdditionalProperty.CaseId)
  LEFT JOIN IWA_AdditionalProperty AddPrpCase_taskType ON Column(CaseAddPrp_taskType.AdditionalPropertyId) = Column(IWA_AdditionalProperty.AdditionalPropertyId)
  WHERE (Column(IWA_TaskQuery.CurrentActivatorName) NOT LIKE #SYSTEM && Column(IWA_TaskQuery.State) <> 3 && (((Column(AddPrpTask_isDeleted.Name) = isDeleted || Column(AddPrpTask_isDeleted.Name) IS NULL) && Column(AddPrpTask_isDeleted.Value) IS NULL) || ((Column(AddPrpTask_isDeleted.Name) = isDeleted || Column(AddPrpTask_isDeleted.Name) IS NULL) && Column(AddPrpTask_isDeleted.Value) NOT LIKE true)) && (Column(IWA_TaskQuery.CurrentActivatorUserId) = 64104 || (! Column(IWA_Task.State) = 3 && (Column(IWA_Task.ActivatorRoleId) = 204 || (Column(IWA_Task.IsExpired) = 1 && Column(IWA_Task.ExpiryActivatorRoleId) = 204))) || (! Column(IWA_Task.State) = 3 && (Column(IWA_Task.ActivatorRoleId) = 205 || (Column(IWA_Task.IsExpired) = 1 && Column(IWA_Task.ExpiryActivatorRoleId) = 205))) || (! Column(IWA_Task.State) = 3 && (Column(IWA_Task.ActivatorRoleId) = 902 || (Column(IWA_Task.IsExpired) = 1 && Column(IWA_Task.ExpiryActivatorRoleId) = 902)))) && (Column(IWA_TaskQuery.State) = 4 || Column(IWA_TaskQuery.State) = 5 || Column(IWA_TaskQuery.State) = 8) && ((Column(AddPrpCase_taskType.Name) = taskType || Column(AddPrpCase_taskType.Name) IS NULL) && Column(AddPrpCase_taskType.Value) LIKE CONTINUE_CREATE_KLARAHOME_COMPANY))

Do you have any idea about it? How can I print sql?

Max size for total attachment when send email via ivy mail

maidanh — Mon, 23 Apr 2018 05:51:59 -0400

Dear Ivy Team, When I attach some attachments and total size for attachment greater than about 8MB I can not send email otherwise I can. I don't know whether there is a configuration about it or not. Do you have any idea about it? Thank you Ivy Team

Questions asked by maidanh

show sql query when query ivy task

Max size for total attachment when send email via ivy mail