/dev-club/b/dev-blog/posts/how-to-filter-on-related-fields-using-filter-apiThis post originally appeared on the SynoLab blog hosted by Synolia , an Elite SugarCRM Partner. Yann Berg&egrave;s describes how you can use a relate filter with the Filter API. He also explores how Sugar does it as well as identifying a d...en-USTelligent Community 12https://sugarclub.sugarai.com/dev-club/b/dev-blog/posts/how-to-filter-on-related-fields-using-filter-apiThu, 30 Aug 2018 11:20:06 GMT5c521d64-519d-47a6-9065-134618b211bf:80b12685-b60a-4a16-b54b-5bdc2c835980brad foster0 <p>I&#39;m running into a problem and i&#39;ve traced it back to this.</p><p>When calling the Contacts api with max_num set to 20, it was only returning 10 records. After reviewing the query it&#39;s joining the &quot;tag_bean_rel&quot; table and because the contacts have 2&nbsp; tags, its returning 10 distinct contacts (2 rows for each).&nbsp; &nbsp;</p><p>The fixQuery isn&#39;t working. although it is passing through it. (perhaps because we are using MSSQL?)&nbsp;&nbsp;</p><p>The fix for me was to simply specify the fields in the request so that it doesnt join all related tables. (luckily i dont need the tags anyway)</p><p><span>/Contacts?fields=id,full_name,customer_number,membership_type,date_modified&amp;offset=0&amp;max_num=20</span></p><p><span>This also gives a massive performance boost so I suggest you specify your fields anyway - even if you don&#39;t have a duplicate problem.</span></p> <img src="https://sugarclub.sugarai.com/aggbug?PostID=804&AppID=56&AppType=Weblog&ContentType=0" width="1" height="1">