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 &amp;&amp; Column(IWA_TaskQuery.State) &lt;&gt; 3 &amp;&amp; (((Column(AddPrpTask_isDeleted.Name) = isDeleted || Column(AddPrpTask_isDeleted.Name) IS NULL) &amp;&amp; Column(AddPrpTask_isDeleted.Value) IS NULL) || ((Column(AddPrpTask_isDeleted.Name) = isDeleted || Column(AddPrpTask_isDeleted.Name) IS NULL) &amp;&amp; Column(AddPrpTask_isDeleted.Value) NOT LIKE true)) &amp;&amp; (Column(IWA_TaskQuery.CurrentActivatorUserId) = 64104 || (! Column(IWA_Task.State) = 3 &amp;&amp; (Column(IWA_Task.ActivatorRoleId) = 204 || (Column(IWA_Task.IsExpired) = 1 &amp;&amp; Column(IWA_Task.ExpiryActivatorRoleId) = 204))) || (! Column(IWA_Task.State) = 3 &amp;&amp; (Column(IWA_Task.ActivatorRoleId) = 205 || (Column(IWA_Task.IsExpired) = 1 &amp;&amp; Column(IWA_Task.ExpiryActivatorRoleId) = 205))) || (! Column(IWA_Task.State) = 3 &amp;&amp; (Column(IWA_Task.ActivatorRoleId) = 902 || (Column(IWA_Task.IsExpired) = 1 &amp;&amp; Column(IWA_Task.ExpiryActivatorRoleId) = 902)))) &amp;&amp; (Column(IWA_TaskQuery.State) = 4 || Column(IWA_TaskQuery.State) = 5 || Column(IWA_TaskQuery.State) = 8) &amp;&amp; ((Column(AddPrpCase_taskType.Name) = taskType || Column(AddPrpCase_taskType.Name) IS NULL) &amp;&amp; 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