# PN5_60802

Updated: 1/18/2022, 5:31:44 PM
Created: 1/18/2022, 5:31:44 PM
Last Updated By: dependabot[bot]
Read Time: 1 minute(s)

# Description

jQL: No output using controlling/dependent associations with a limiting expression

# Previous Release Behavior

No data was displayed for:

SORT filename WITH PDATE2 GE "26/5/07" AND LE "26/5/07" TOTAL PAYMENTS2 PDATE2 GE "26/5/07" AND LE "26/5/07" PDESC2 PAYMENTS2
1

This was basically due to jQL not handling the limiting expression correctly as well as the the structure of the jQL statement.

# Current Release Behavior

As long as the statement is restructured to place the limiting expression at the end of the statement then there will be no issue, e.g.

SORT WCOMPS TOTAL PAYMENTS2 PDATE2 GE "26/5/07" AND LE "26/5/07" PDESC2 PAYMENTS2 WITH PDATE2 GE "26/5/07" AND LE "26/5/07"
1

Back to 5.7.1 Release Notes