{"id":11342,"date":"2018-03-14T18:13:25","date_gmt":"2018-03-14T12:43:25","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=11342"},"modified":"2018-03-14T18:13:25","modified_gmt":"2018-03-14T12:43:25","slug":"working-with-crm-view-query-on-dynamics-365-app-for-tablets","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2018\/03\/working-with-crm-view-query-on-dynamics-365-app-for-tablets\/","title":{"rendered":"Working with CRM View Query on Dynamics 365 App for Tablets"},"content":{"rendered":"<p style=\"text-align: justify;\">Sometimes we come across a scenario where we need to display sub grid depending upon some run time scenario or display details that are not possible to achieve using OOB condition like display Activities where regarding is contacts which are related to account on account form.<\/p>\n<p style=\"text-align: justify;\">This is not possible through options available with OOB and to achieve this we need to write a Plugin on Pre-Operation of retrieve multiple request. This is one of the popular option to achieve this.<\/p>\n<p style=\"text-align: justify;\">But One of the issue for this solution is it won\u2019t work for tablet. We look into it to find the cause of it and after some research and play round we find below solution using for tablet.<\/p>\n<p style=\"text-align: justify;\">While working we noticed that Dynamics CRM uses query in the format of <strong>Query Expression<\/strong> for browser and we need to update that as required. Whereas for tablet client it won\u2019t work, since for tablet client CRM does not use <strong>Query Expression<\/strong> and Query is converted to Query type <strong>Fetch Expression <\/strong>internally.<\/p>\n<p style=\"text-align: justify;\">So before proceeding we need to check whether retrieved Expression is <strong>Query Expression<\/strong> or <strong>Fetch Expression<\/strong> and proceed with it, as shown in the screenshot below.<\/p>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-11344\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2018\/03\/Working-with-CRM-View-Query-on-Dynamics-365-App-for-Tablets.png\" alt=\"Working with CRM View Query on Dynamics 365 App for Tablets \" width=\"558\" height=\"178\" \/><\/p>\n<p style=\"text-align: justify;\">Later we can update query as per our requirement. We can also change the type run type i.e. replacing <strong>Query Expression<\/strong> with <strong>Fetch Expression<\/strong>.<\/p>\n<p style=\"text-align: justify;\">Hope this helps!<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.inogic.com\/product\/productivity-pack\/click-2-export-microsoft-dynamics-crm-reports\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"aligncenter  wp-image-10864\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2017\/12\/Click2Export-banner.png\" alt=\"Export Dynamics CRM Reports\" width=\"828\" height=\"207\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sometimes we come across a scenario where we need to display sub grid depending upon some run time scenario or display details that are not possible to achieve using OOB condition like display Activities where regarding is contacts which are related to account on account form. This is not possible through options available with OOB\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2018\/03\/working-with-crm-view-query-on-dynamics-365-app-for-tablets\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":11343,"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,17],"tags":[418,419,420],"class_list":["post-11342","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-365","category-dynamics-365-mobiles-tablets","tag-crm-view-query","tag-crm-view-query-on-dynamics-365-app","tag-crm-view-query-on-dynamics-365-app-tablets"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/11342","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=11342"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/11342\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media\/11343"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=11342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=11342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=11342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}