Questions asked by maidanhhttps://answers.axonivy.com/questions/asked-by/938/maidanh/?type=rssQuestions asked by <a href="/users/938/maidanh" >maidanh</a>enFri, 27 Jul 2018 04:55:35 -0400show sql query when query ivy taskhttps://answers.axonivy.com/questions/3370/show-sql-query-when-query-ivy-task<p>Dear IvyTeam</p>
<p>How can I print sql query to log file when there are some get ivy task by query?</p>
<p>I followed this link <a href="https://answers.axonivy.com/questions/1585/hibernate-show_sql">https://answers.axonivy.com/questions/1585/hibernate-show_sql</a> but it seem for project that using hibernate?</p>
<p>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</p>
<pre><code>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))
</code></pre>
<p>Do you have any idea about it?
How can I print sql?</p>maidanhFri, 27 Jul 2018 04:55:35 -0400https://answers.axonivy.com/questions/3370/show-sql-query-when-query-ivy-tasktask-queryMax size for total attachment when send email via ivy mailhttps://answers.axonivy.com/questions/3233/max-size-for-total-attachment-when-send-email-via-ivy-mail<p>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</p>maidanhMon, 23 Apr 2018 05:51:59 -0400https://answers.axonivy.com/questions/3233/max-size-for-total-attachment-when-send-email-via-ivy-mailemail