As part of our IQA training, we would like to offer the students some useful queries they can take back to the office. Please submit any ideas you may have. Provide a brief description and the criteria, such as joins and parameters. Thanks.
Useful IQA queries
Recreation of iMIS 10 Product Search
On June 1st, 2006 Brent Sitton says:
In an IQA Discovery or innovations session, I demonstrated how to recreate the iMIS 10 product search and place it in the Appeal Product List tab as a find option.
The powerpoint is IQA.zip located here:
http://www.advsol.com/source/Communities/documentArchive.cfm?section=Com....
Recreating any of the iMIS 10 contact searches would be a huge hit!
Some Queries I Write Regularly
For the Advanced Customer Find windwo... A search of Contact, Activities with parameters on different address components...we can build the basic query and then layer up the advanced features.
Billings Queries:
1. List of unrenewed members - basic
2. Counts of unrenewed members by member type and category - advanced
Events Queries
1. List of event registrants - basic
2. Add function information for a list of registrants by function - basic
3. Counts of active events and # registrants at the event level - advanced