Sign Up for Training |
Jet Global Company Site
Community
Downloads
Submit a Request
Give Feedback

Using "Schema=" to return specific data


Overview

The special filter field "Schema=" can be used to override 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...

 

Either:

  1. change your NL() function to return the specific field for which you were using the NF function:

  2. Or have the NL() function return a reference-able value and then use an NL("First") function to return the desired field (referencing the value returned by the first NL() function as a filter):

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

Comments