{"id":24405,"date":"2020-08-14T13:29:05","date_gmt":"2020-08-14T13:29:05","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=24405"},"modified":"2020-08-14T13:29:05","modified_gmt":"2020-08-14T13:29:05","slug":"how-to-work-with-combined-filters-of-fetch-function-in-resco-mobile-app","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2020\/08\/how-to-work-with-combined-filters-of-fetch-function-in-resco-mobile-app\/","title":{"rendered":"How to work with Combined Filters of Fetch Function in Resco Mobile App"},"content":{"rendered":"

Introduction<\/strong><\/h2>\n

Recently, we had a business requirement where we had to retrieve entity records by satisfying a combination of conditions in the script and perform operations on them in Resco Mobile App.<\/p>\n

For example, on Account<\/strong> entity form we added a custom button. And on click of that button we wanted to retrieve active Work Order <\/strong>records associated with that Account <\/strong>having \u2018System Status = Open \u2013 Unscheduled\u2019 and \u2018Work Order Type = Maintenance \/ Inspection\u2019 and populate \u2018Work Order Instructions\u2019 on them from the Account <\/strong>record.<\/p>\n

So first, we added a custom button \u2018Process Work Orders\u2019 on the Account <\/strong>entity form and then added a HTML File in \u2018Offline HTML\u2019 of Resco Project with below code snippet.<\/p>\n

Code Snippet:<\/p>\n

\/\/Event of CustomCommand<\/p>\n

MobileCRM.UI.EntityForm.onCommand(“custom_ProcessWorkOrders”, function (entityForm) {<\/p>\n

\/\/FetchXML Entity for retrieving Work Order records<\/p>\n

var entity = new MobileCRM.FetchXml.Entity(“msdyn_workorder”);<\/p>\n

entity.addAttribute(“msdyn_workorderid”);<\/p>\n

entity.addAttribute(“msdyn_name”);<\/p>\n

\/\/Sub filter with AND clause<\/p>\n

var subFilter1 = new MobileCRM.FetchXml.Filter();<\/p>\n

subFilter1.type = “and”;<\/p>\n

subFilter1.where(“msdyn_serviceaccount”, “eq”, entityForm.entity.id); \/\/Service Account<\/p>\n

subFilter1.where(“msdyn_systemstatus”, “eq”, 690970000); \/\/Open – Unscheduled<\/p>\n

subFilter1.where(“statecode”, “eq”, 0); \/\/Active<\/p>\n

\/\/Sub filter with OR clause<\/p>\n

var subFilter2 = new MobileCRM.FetchXml.Filter();<\/p>\n

subFilter2.type = “or”;<\/p>\n

subFilter2.where(“msdyn_workordertype”, “eq”, “ad2d8b0a-2fe7-e611-8110-e0071b66bf01”); \/\/Inspection<\/p>\n

subFilter2.where(“msdyn_workordertype”, “eq”, “69a69cba-bad3-ea11-a812-000d3a569dff”); \/\/Maintenance<\/p>\n

\/\/Main Filter i.e. group of subfilters<\/p>\n

var mainFilter = new MobileCRM.FetchXml.Filter();<\/p>\n

mainFilter.type = “and”;<\/p>\n

mainFilter.filters = [subFilter1, subFilter2]; \/\/sub filters<\/p>\n

\/\/Add Main Filter in Entity Filter<\/p>\n

entity.filter = mainFilter;<\/p>\n

var fetch = new MobileCRM.FetchXml.Fetch(entity);<\/p>\n

\/\/fetching data of entity<\/p>\n

fetch.execute(“DynamicEntities”, function (result) {<\/p>\n

\/\/validate result<\/p>\n

if (typeof (result) != “undefined” && result.length > 0) {<\/p>\n

\/\/Here you can perform operation on the retireve records.<\/p>\n

\/\/You will get the retrieved records in the \u201cresult\u201d object<\/p>\n

}<\/p>\n

}, function (error) {<\/p>\n

MobileCRM.bridge.alert(“An Error Has occurred ” + error);<\/p>\n

});<\/p>\n

});<\/p>\n

Note: We need to add all \u2018sub filters\u2019 in the \u2018main filter\u2019 and then associate that \u2018main filter\u2019 to the \u2018FetchXML Filter\u2019 to make it work.<\/strong><\/p>\n

Next, we added this Html file in the \u2018Iframe\u2019 of the Account <\/strong>entity form and published the Resco Project. Then after publishing Resco Project we synced the Resco Mobile App with that environment and navigated to the Account <\/strong>record. Next, we clicked on the \u2018Process Work Orders\u2019 for retrieveing and updating the Work<\/strong> Order<\/strong> records based on the conditions.<\/p>\n

Now after the execution of this function, only the active Work Order <\/strong>records associated with that Account <\/strong>having \u2018System Status = Open \u2013 Unscheduled\u2019 and \u2018Work Order Type = Maintenance \/ Inspection\u2019 was retrieved and processed.<\/p>\n

Please refer below screenshot:<\/p>\n

\"Resco\"<\/p>\n

Conclusion<\/strong><\/h2>\n

In this way, instead of performing multiple Fetch Functions or Fetch XML for retrieving entity records of the same entity, we can use \u2018Combined Filter\u2019<\/strong> in a single Fetch Function for retrieving the records of same entity based on multiple conditions.<\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction Recently, we had a business requirement where we had to retrieve entity records by satisfying a combination of conditions in the script and perform operations on them in Resco Mobile App. For example, on Account entity form we added a custom button. And on click of that button we wanted to retrieve active Work\u2026 Read More: How to work with Combined Filters of Fetch Function in\u2026 »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":24407,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[48],"tags":[1445],"class_list":["post-24405","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-resco-mobile-crm","tag-resco-mobile-app"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t