☰
Current Page
Main Menu
Home
Home
Editing Injecting-where-clause-into-queries
Edit
Preview
H1
H2
H3
default
Set your preferred keybinding
default
vim
emacs
markdown
Set this page's format to
AsciiDoc
Creole
Markdown
MediaWiki
Org-mode
Plain Text
RDoc
Textile
Rendering unavailable for
BibTeX
Pod
reStructuredText
Help 1
Help 1
Help 1
Help 2
Help 3
Help 4
Help 5
Help 6
Help 7
Help 8
Autosaved text is available. Click the button to restore it.
Restore Text
#Injecting a "Where" Clause Into Queries [[_TOC_]] ##Question Can I inject a customized SQL "Where Clause" or other expression into my queries? ##Answer Yes, you can perform this in a couple of ways. Lets say you have the following situation: You have 2 views: invoices and payments. But when you run a report where the invoice date is a range and you want to display any blank payments also included in this report, you will have an issue where the payment date will show blanks if the payment amount is blank. There are 2 basic ways to address this problem. **Method 1:** In your filter, select **[[Use Previous Or|http://wiki.izenda.com/FAQ/Questions/How-is-Use-Previous-OR-used-in-Filters]]** to bring in payments. **Method 2:** You can also use the SQL Override property in the [[PreExecuteReportSet|]] method to inject a 'Where' clause. Please see the hidden filter with Sql Override section in [[this article|http://wiki.izenda.com/FAQ/applying-hidden-filter-using-inner-query]].
Uploading file...
Header
 **This documentation is for the legacy Izenda 6 product. Documentation for the new Izenda 7 product can be found at [[https://www.izenda.com/docs/|https://www.izenda.com/docs/]]**
Sidebar
 --- * [[Izenda 7 Series Documentation|https://www.izenda.com/docs/]] * [[Release Notes]] * [[Upgrade Best Practices|FAQ/Izenda-Update-Best-Practices]] * [[FAQ]] * [[Tutorials]] * [[The Izenda API|/API/AdHocConfig]] * [[The AdHocSettings class|/API/AdHocSettings]] * [Developer Links and Guides](/Guides/Developer-Links-and-Guides) * [[Known Issues]] --- * <a href="http://www.izenda.com" rel="nofollow" target="_blank">Izenda Website</a> * [Product Video](https://www.youtube.com/watch?v=X3-yWFq0w5A) * <a href="http://www.izenda.com/blog" rel="nofollow" target="_blank">Izenda Blog</a> * <a href="http://www.izenda.com/company/" rel="nofollow" target="_blank">About Us</a> * <a href="http://www.izenda.com/contact-us/" rel="nofollow" target="_blank">Contact Us</a> --- * [Guide To Report Design](/Guides/ReportDesign) * [Making Custom Forms Video](http://www.youtube.com/watch?v=5b2axJlgdFs) --- * [[Acknowledgements]]
Edit message:
Cancel