{"id":1232,"date":"2020-02-17T09:08:23","date_gmt":"2020-02-17T09:08:23","guid":{"rendered":"https:\/\/sdf-docs.mansystems.com\/docs\/acr-rules\/performance\/xpathassociationgrouped\/"},"modified":"2020-07-08T14:35:30","modified_gmt":"2020-07-08T14:35:30","slug":"xpathassociationgrouped","status":"publish","type":"docs","link":"https:\/\/sdf-docs.clevr.com\/?docs=acr-rules\/performance\/xpathassociationgrouped","title":{"rendered":"Retrieves over the same association should be grouped together"},"content":{"rendered":"\n<p> Released in version 1.6 (03 March 2020) <\/p>\n\n\n\n<p>When retrieving it is inefficient to have multiple constraints over the same association. If possible, it is advised to group them together.<\/p>\n\n\n\n<p>Check <a href=\"https:\/\/www.youtube.com\/watch?time_continue=1732&amp;v=xNR3BjJYt3U\">the expert webinar series for more information<\/a>.<\/p>\n\n\n\n<p><strong>Non-compliant example:<\/strong><\/p>\n\n\n\n<p><code>[Courses.Subscription_Person\/Courses.Subscription\/Grade &lt; 5 or Courses.Subscription_Person\/Courses.Subscription\/Grade > = 7]<\/code><\/p>\n\n\n\n<p><strong>Compliant example:<\/strong><\/p>\n\n\n\n<p><code>[Courses.Subscription_Person\/Courses.Subscription<\/code><br>  <code>[Grade &lt; 5 or Grade > = 7]<\/code><br><code>]<\/code><\/p>\n","protected":false},"featured_media":0,"parent":95,"menu_order":25,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-1232","docs","type-docs","status-publish","hentry"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/sdf-docs.clevr.com\/index.php?rest_route=\/wp\/v2\/docs\/1232"}],"collection":[{"href":"https:\/\/sdf-docs.clevr.com\/index.php?rest_route=\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/sdf-docs.clevr.com\/index.php?rest_route=\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/sdf-docs.clevr.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1232"}],"version-history":[{"count":3,"href":"https:\/\/sdf-docs.clevr.com\/index.php?rest_route=\/wp\/v2\/docs\/1232\/revisions"}],"predecessor-version":[{"id":1235,"href":"https:\/\/sdf-docs.clevr.com\/index.php?rest_route=\/wp\/v2\/docs\/1232\/revisions\/1235"}],"up":[{"embeddable":true,"href":"https:\/\/sdf-docs.clevr.com\/index.php?rest_route=\/wp\/v2\/docs\/95"}],"next":[{"title":"Loops should not have loops inside","link":"https:\/\/sdf-docs.clevr.com\/?docs=acr-rules\/performance\/loopinloop","href":"https:\/\/sdf-docs.clevr.com\/index.php?rest_route=\/wp\/v2\/docs\/1149"}],"prev":[{"title":"Retrieve & aggregate combo should not be nullified by using the list","link":"https:\/\/sdf-docs.clevr.com\/?docs=acr-rules\/performance\/retrieveaggregatenullified","href":"https:\/\/sdf-docs.clevr.com\/index.php?rest_route=\/wp\/v2\/docs\/758"}],"wp:attachment":[{"href":"https:\/\/sdf-docs.clevr.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1232"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/sdf-docs.clevr.com\/index.php?rest_route=%2Fwp%2Fv2%2Fdoc_tag&post=1232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}