jDataPortal()

Estimated reading time: 5 minutes

Function Summary

The jDataPortal function establishes a connection to an Interject Data Portal that will be used as the data source for the function it is embedded in. Data sets accessed utilizing the jDataPortal are stored in memory. This allows the data set to be accessed later without having to query the data again via the Data Portal.

For an example of this function, see Lab Dev: Customer Aging Detail.

For instructions on how to set up this function, see Setting Up the jDataPortal.

Function Arguments

Type String
Constraints Max 255 char
If Blank Function Error

Type Integer
Constraints
If Blank Will return the first data set

Type String
Constraints Max 255 char; valid SQL statement
If Blank Will not filter data

Type String
Constraints Max 255 char; valid SQL statement
If Blank Will not order data

Type String
Constraints Max 255 char
If Blank Will not override

Type String
Constraints Max 255 char
If Blank Will not override

Excel Formula Bar Example

=jDataPortal("NorthwindMultiRecord_Pull",2,"[CompanyName] Like '%s%'","[CustomerID] ASC")

Function Composition

Argument Name Example Mapping Explanation
Function Name =jDataPortal The name of this function.
Data Portal Name NorthwindMultiRecord_Pull This function will use the "NorthwindMultiRecord_Pull" Data Portal for the data source.
Data Result Number 2 This data connection will use the 2nd result set previously held in memory from previous calls.
Filter [CompanyName] Like ‘%s%’ This data connection will only return records whose CompanyName contains an 's' character.
OrderBy [CustomerID] ASC The data result will be ordered by the column CustomerID in ascending order.
CommandOverride   Left blank to indicate to not override the command.
ConnectionOverride   Left blank to indicate to not override the connection.

Usable In These Report Formulas