{"id":13244,"date":"2018-10-29T18:18:07","date_gmt":"2018-10-29T12:48:07","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=13244"},"modified":"2018-10-29T18:18:07","modified_gmt":"2018-10-29T12:48:07","slug":"working-with-filters-of-views-in-resco-mobile-app","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2018\/10\/working-with-filters-of-views-in-resco-mobile-app\/","title":{"rendered":"Working with Filters of views in Resco Mobile App"},"content":{"rendered":"<h2><strong>Introduction:<\/strong><\/h2>\n<p style=\"text-align: justify;\">Recently, we had a business requirement where we need to filter the List View on the entity form of Resco mobile app. Generally, when you add a List View on an entity form, it will show all related records in that list. But we can filter the Views in Resco mobile app to show only necessary data.<\/p>\n<p style=\"text-align: justify;\">For example, on <strong>Account<\/strong> entity form if you want to display <strong>Contacts <\/strong>from the same city of that <strong>Account <\/strong>while adding it in Primary Contact Lookup, then you can simply create a new lookup view of <strong>Contacts<\/strong> and add that view on \u201cPrimary Contact\u201d field of <strong>Account<\/strong> entity form. For this to work you will need to double-click on \u201cPrimary Contact\u201d lookup field as shown below,<\/p>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"aligncenter  wp-image-13245\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/10\/1Working-with-Filters-of-views-in-Resco-Mobile-App.png\" alt=\"Working with Filters of views in Resco Mobile App\" width=\"387\" height=\"511\" \/><\/p>\n<p style=\"text-align: justify;\">After double clicking on \u201cPrimary Contact\u201d lookup field, the window \u201cLookup Item Properties\u201d will appear. Here you will need to set the newly created \u201cContact Lookup View\u201d and then click on the \u201cEdit Filter\u201d button as shown below,<\/p>\n<p><img decoding=\"async\" class=\"aligncenter  wp-image-13246\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/10\/2Working-with-Filters-of-views-in-Resco-Mobile-App.png\" alt=\"Working with Filters of views in Resco Mobile App\" width=\"448\" height=\"463\" \/><\/p>\n<p style=\"text-align: justify;\">After clicking the \u201cEdit Filter\u201d button the filter window will appear, here you will need to put filters on the fields that are required. Here you\u2019ll have to add a filter condition first then, you can use fields of <strong>Account<\/strong> record to filter view using \u201cSet Variable\u201d button as shown below,<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-13247 \" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/10\/3Working-with-Filters-of-views-in-Resco-Mobile-App.png\" alt=\"Working with Filters of views in Resco Mobile App\" width=\"475\" height=\"487\" \/><\/p>\n<p style=\"text-align: justify;\">After clicking the Set Variable button, a window of <strong>Account<\/strong> fields will appear. Here you\u2019ll need to select an appropriate field to which will satisfy the condition and then click OK button as shown below,<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-13248\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/10\/4Working-with-Filters-of-views-in-Resco-Mobile-App.png\" alt=\"Working with Filters of views in Resco Mobile App\" width=\"487\" height=\"500\" \/><\/p>\n<p>You can also put hardcoded values in these filters as shown below,<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-13249 \" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/10\/5Working-with-Filters-of-views-in-Resco-Mobile-App.png\" alt=\"Working with Filters of views in Resco Mobile App\" width=\"489\" height=\"502\" \/><\/p>\n<p style=\"text-align: justify;\">The above process will show all the active <strong>Contacts<\/strong> having same \u201cAddess1:City\u201d field as <strong>Account\u2019s <\/strong>\u201cAddess1:City\u201d field.<\/p>\n<p style=\"text-align: justify;\">You can use any field to filter List View if you are putting a hardcoded value. But if you want to put a generic value then you can use \u201cSet Variable\u201d option in filter. These variables contain the field values of the record itself.<\/p>\n<h2 style=\"text-align: justify;\"><strong>Conclusion: <\/strong><\/h2>\n<p style=\"text-align: justify;\">Instead of showing all the records in List View you can prefer filters in List View\/Lookup View to display only related and necessary records.<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.maplytics.com\/miscellaneous\/effective-sales-territory-management-using-map-visualization-dynamics-crm\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"aligncenter wp-image-13252\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/10\/Effectively-Manage-Sales-Territories-on-a-map-within-Microsoft-Dynamics-CRM.png\" alt=\"Effectively-Manage-Sales-Territories-on-a-map-within-Microsoft-Dynamics-CRM\" width=\"824\" height=\"206\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction: Recently, we had a business requirement where we need to filter the List View on the entity form of Resco mobile app. Generally, when you add a List View on an entity form, it will show all related records in that list. But we can filter the Views in Resco mobile app to show\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2018\/10\/working-with-filters-of-views-in-resco-mobile-app\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":13250,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[16,18,19,48],"tags":[1445,1447,1449],"class_list":["post-13244","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-365","category-dynamics-365-v9-2","category-dynamics-crm","category-resco-mobile-crm","tag-resco-mobile-app","tag-resco-mobile-crm","tag-resco-mobile-dynamics-crm"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/13244","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=13244"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/13244\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media\/13250"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=13244"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=13244"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=13244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}