There are a number of GP bloggers that often include SQL Query Language as part of their posts. This is a rich source of specific problem solvers.
SmartList Builder allows you to easily take advantage of these resources to provide data inquiry and reports.
These are the steps to use once you’ve found a SQL Query that would be useful:
- Create the new SQL View using the SQL Query
- Grant access to the new view
- Create the SmartList using the SQL View
I created this video to show you a simple example of how to do it.
Victoria Yudin is one GP Blogger that regularly includes SQL Queries in her posts. Check it out.
This is the specific post I referenced in the video.