Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Using "Schema=" to return specific data


Overview

The special filter field "Schema=" can be used to o verride the default database schema (that will be used in the query) with the one specified in the Filter parameter following "Schema="

This special filter is designed to be used with NL() functions that return specific values. In NL() functions where the "Field" parameter is either left blank or contains a specified field cache, "Schema=" will return the correct data, but any NF() functions that reference that field cache cannot recognize the "Schema=" restriction.


Design

To accomplish the desired results, it is a simple matter to make a slight design change in a report.

Instead of attempting to use an NF() function to reference an NL() function which utilizes the "Schema=" filter field...



You can either have the NL() function return the value directly...



Or have the NL() function return a reference-able value and then use an NL("First") [or similar] function to reference the value returned by the first NL() function, in order access the desired data...



Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments