The target audience of this blog post is for people who are absolute beginners to advanced finds. Many new users find advanced finds intimidating, but through this post, I hope to prove that anyone can make purposeful advanced find queries in a matter of minutes.
I recommend by starting from whatever entity you are looking to do an advanced find on. In my example below, I am doing an advanced find on Accounts—specifically, I want to get a query of all of my accounts based out of Minnesota.
To do this, click the advanced find icon in the top right, this will load in all criteria and columns from the view that was open (Active Accounts in my example below). Once the advanced find window is open, click Details, this will allow us to edit the filter criteria of the advanced find:
On the next available row, click select, and select the field you want to filter on. All fields available on the selected entity will show up on this list. In my example, we wanted to find all Accounts in Minnesota, so I need our Address 1: State/Province field. I will then leave the filter criteria as Equals, and type “MN” in the third column:
Next, we need to review the columns in our query. By default, the Active Accounts view does not have a “State” column, so we need to add it. Start by clicking Edit Columns, then Add Columns, and select Address 1: State/Province, and click add.
Once the column is added, single click it, and use the arrow keys to position it wherever you want it in the column order. Double click a column header to adjust the column width and then click OK when you are done making changes.
At this point, you are ready to see your query. Click results, and you should see all records that meet the designed criteria and interact with the records same as you would any other view, including exporting to excel, etc.
Finally, if the advanced find you created is one you want to view frequently, you can save it, and it will be added to your personal views.
Want to see these processes in action? Watch our quick introduction videos,
About Ryan Talsma: