Business Layer Training - Querying the finPOWER Connect Database
This Business Layer training session is broken in to two parts, looking at the different ways to query the finPOWER Connect Database. Part 1 covers the Run Query utility and how it can be used to load/save frequently used queries in finPOWER Connect, as well as starting to explore the ISSelectQueryBuilder Business Layer object. Part 2 further delves into the Query Builder and looks at ways to implement it in a finPOWER Connect Script. We also cover topics such as Scalar Queries and converting XML stored in the database into Business Layer objects without needing to load Account/Client etc.. objects.
Watch the video for part 1 here.
Watch the video for part 2 here.
Supporting Files
To download the Scripts that are referenced throughout the video, click the download link below.
Other Resources
The developer page on our website contains lots of useful information for customising finPOWER Connect. From this page, you can also access the developer downloads page which hosts documentation and guides that can be downloaded in pdf format.
Our context sensitive Business Layer help is available from the Scripts Page in the finPOWER Connect application. For more information on accessing and using the help, see our previous blog post here.
Code Snippets are also available via the Scripts Page in the finPOWER Connect application. For more information on accessing and using the Code Snippets, see our previous blog post here.
Feedback
Any questions, comments or feedback relating to the training content, should be directed to the Intersoft Code Support team via email at codesupport@intersoft.co.nz.