topic Report a bug in metadata query ibatis file in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/report-a-bug-in-metadata-query-ibatis-file/m-p/131287#M35438 <P>There is a bug in sql fragments with id sql_select_byDynamicQuery defined in&nbsp;metadata-query-common-SqlMap.xml file</P><P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="微信图片_20220623020116.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="image"><img src="https://connect.hyland.com/t5/image/serverpage/image-id/1551i1BE813699C3D6CDE/image-size/large?v=v2&amp;px=999" role="button" title="image" alt="image" /></span></SPAN></P><P>text highlighted should be&nbsp; <FONT color="#00FF00">${item.alias}.${item.fieldName} IS NULL</FONT> &nbsp;instead of <FONT color="#FF0000">${item.alias}.${item.fieldName} IS NOT NULL</FONT></P> Wed, 22 Jun 2022 18:05:32 GMT kaynezhang 2022-06-22T18:05:32Z Report a bug in metadata query ibatis file https://connect.hyland.com/t5/alfresco-forum/report-a-bug-in-metadata-query-ibatis-file/m-p/131287#M35438 <P>There is a bug in sql fragments with id sql_select_byDynamicQuery defined in&nbsp;metadata-query-common-SqlMap.xml file</P><P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="微信图片_20220623020116.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="image"><img src="https://connect.hyland.com/t5/image/serverpage/image-id/1551i1BE813699C3D6CDE/image-size/large?v=v2&amp;px=999" role="button" title="image" alt="image" /></span></SPAN></P><P>text highlighted should be&nbsp; <FONT color="#00FF00">${item.alias}.${item.fieldName} IS NULL</FONT> &nbsp;instead of <FONT color="#FF0000">${item.alias}.${item.fieldName} IS NOT NULL</FONT></P> Wed, 22 Jun 2022 18:05:32 GMT https://connect.hyland.com/t5/alfresco-forum/report-a-bug-in-metadata-query-ibatis-file/m-p/131287#M35438 kaynezhang 2022-06-22T18:05:32Z Re: Report a bug in metadata query ibatis file https://connect.hyland.com/t5/alfresco-forum/report-a-bug-in-metadata-query-ibatis-file/m-p/131288#M35439 <P>Thanks for raising this issue.</P> <P>I've created a JIRA ticket to address the problem:</P> <P><A href="https://alfresco.atlassian.net/browse/MNT-23097" target="_blank" rel="nofollow noopener noreferrer">https://alfresco.atlassian.net/browse/MNT-23097</A></P> Thu, 23 Jun 2022 06:14:55 GMT https://connect.hyland.com/t5/alfresco-forum/report-a-bug-in-metadata-query-ibatis-file/m-p/131288#M35439 angelborroy 2022-06-23T06:14:55Z