{"id":30382,"date":"2022-01-24T16:05:01","date_gmt":"2022-01-24T10:35:01","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=30382"},"modified":"2022-10-14T12:11:12","modified_gmt":"2022-10-14T06:41:12","slug":"dataverse-search-easier-than-before-to-find-data-in-dynamics-365-crm-dataverse","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2022\/01\/dataverse-search-easier-than-before-to-find-data-in-dynamics-365-crm-dataverse\/","title":{"rendered":"Dataverse Search \u2013 Easier than before to find data in Dynamics 365 CRM \/ Dataverse"},"content":{"rendered":"

Amongst the various options to quickly lookup or search data in Dataverse \/ Dynamics 365, the most popular remain<\/p>\n

1<\/strong>. Search box in the view \u2013 search within the view being listed<\/p>\n

2<\/strong>. Advanced find search \u2013 you can setup your detailed search criteria for specific tables and columns and get the desired results<\/p>\n

3<\/strong>. Dataverse search aka Relevance search \u2013 Global search box that lets you type a keyword and get the results by scanning records across entities and fields.<\/p>\n

In this article, we focus on the update that Relevance search received in the last update cycle.<\/p>\n

Let us start with what got me exploring this feature in depth<\/p>\n

I see a search bar and type Mumbai \u2013 to see if it will search for records in Mumbai and as I type, the search list starts displaying matches as can be seen in the screenshot below with the option to show more results\u2026<\/p>\n

\"Dataverse<\/p>\n

And I click show more and this is what I see<\/p>\n

\"Dataverse<\/p>\n

Could be a bug, if it shows in the drop-down, it should list them as well. And this is how it started\u2026<\/p>\n

How does it know which columns and tables to look for?<\/strong><\/p>\n

Quick View \u2013 is a special kind of view that is available for every table that you add to Dataverse.<\/p>\n

Add the table\/entity to the solution and then navigate to the view section of the selected table<\/p>\n

\"Dataverse<\/p>\n

Edit the Quick Find view to configure the find by section, which is where you provide the list of fields that should be searched as part of relevance search. Note this is also used when you type in the search box of a view<\/p>\n

\"Dataverse<\/p>\n

As can be seen the address 1 city field is not selected in the search field list, and yet when I did a search, it did search for the entered keyword in this column as well.<\/p>\n

Why?<\/strong><\/p>\n

This column though not included in the search field list, was included as part of the columns in the view to show the search results<\/p>\n

\"Dataverse<\/p>\n

Take this column off the view and save and publish the view. Now search for the keyword Mumbai and it does not find any match<\/p>\n

\"Dataverse<\/p>\n

This means the search is performed not only on the search columns specified in find by but also the columns included in the view to show the results.<\/p>\n

Configure Dataverse search to improve search results and performance – Power Platform | Microsoft Docs<\/a><\/p>\n

Per the above article the fields that are present in the filter conditions, view columns and find by columns are included in the Dataverse search index.<\/p>\n

Search Index<\/strong><\/p>\n

The relevance search is powered by the Dataverse Search Index. You can manage and configure the index from the Overview section of a solution as shown below<\/p>\n

\"Dataverse<\/p>\n

Manage Search Index is where you will see all the tables listed<\/p>\n

\"Dataverse<\/p>\n

It will list all the tables present in the current solution. You can enable or disable indexing on these tables from here.<\/p>\n

In the above example, I uncheck the Account table and save the changes. Now if you search for a keyword that you know for certain is available as Account, you will still not find it listed in the search results<\/p>\n

\"Dataverse<\/p>\n

While Quick Find view lets you configure the tables and fields that should be used for search. It won\u2019t be included as part of Dataverse search until it has been indexed.<\/p>\n

If you select show more results in the above list, you get the following screen with the results categorized by table\/entity type.<\/p>\n

\"Dataverse<\/p>\n

The columns for each of these entity results are picked up from the view column configured in the Quick Find View.<\/p>\n

You can further filter results using the filter pane<\/p>\n

\"Dataverse<\/p>\n

The columns available for filter are the date, numeric\/currency and lookup attributes available in the results view for that table.<\/p>\n

Quick Actions<\/strong><\/p>\n

The search results in the list show call to action buttons against each of the result for quick access to operations that you commonly use.<\/p>\n

\"Dataverse<\/p>\n

This list is configurable. As you can see there is no quick action button available for the quotes table. Let us see how this can be enabled.<\/p>\n

Here we will be enabling OOB Assign button for quick action on Quote. As you can check in below screenshot currently there is no option available.<\/p>\n

We will update Assign button on Quote entity using Ribbon workbench. For the same, you have to create an unmanaged solution and add Quote entity within solution. Then open same solution using Ribbon workbench.<\/p>\n

You have to Add custom button or customize OOB button from Home area as shown below so buttons can be available for Quick action. Here we choose Customize Command for ASSIGN button.<\/p>\n

\"Dataverse<\/p>\n

Then we have to add Enable Rule for button command as below.<\/p>\n

\"Dataverse<\/p>\n

Add Enable rule with below properties.<\/p>\n

Id : Mscrm.ShowOnQuickAction<\/p>\n

Un-customised (IsCore): True<\/p>\n

\"Dataverse<\/p>\n

You need to add same Enable rule for your custom button to be available for Quick Action. Details about the new enable rules available to support are provided here<\/a><\/p>\n

With this modification, now the search list will show the assign quick action against the search results for quotes.<\/p>\n

\"Dataverse<\/p>\n

If you would like to use the relevance search functionality programmatically to support your own custom canvas app, you can refer this<\/a> blog on how to go about with it.<\/p>\n

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

With the new updates, it is not just easy to find data but with the call-to-action or quick action buttons added, it helps minimize the clicks required to get there<\/p>\n

Save 1-2 hours or $800 monthly on scheduling and managing business travel with a geo-mapping App!<\/div><\/div><\/h2>\n

Maplytics<\/a> <\/strong>\u2013 Integrate Map with Dynamics 365 CRM and visualize data on the map, manage sales territories, auto-schedule appointments, get optimized travel routes, track field reps in real-time, and more<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

Amongst the various options to quickly lookup or search data in Dataverse \/ Dynamics 365, the most popular remain 1. Search box in the view \u2013 search within the view being listed 2. Advanced find search \u2013 you can setup your detailed search criteria for specific tables and columns and get the desired results 3.\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"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":[2354,16,38,2361],"tags":[2545],"class_list":["post-30382","post","type-post","status-publish","format-standard","hentry","category-dataverse","category-dynamics-365","category-microsoft-powerapps","category-technical","tag-dataverse-search"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/30382","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=30382"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/30382\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=30382"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=30382"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=30382"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}