This may be a silly question, but does this function work in 8.5? Or is there a limit of select statements:
My select statements as follows worked just fine:
IsNull ({TRANSACTIONS.CANCELLED_DATE}) and
IsNull ({TRANSACTIONS.DISB_DATE}) and
{@App_Status} <> '2' and
{@App_Status} <> '3' and
{@App_Status}<> '4'
When I added the statement below, the first statement above regarding cancelled date was then ignored:
and
({TRANSACTIONS.REG_DATE} in dateadd("yyyy",-1,currentdate) to currentdate or {TRANSACTIONS.CPERM_LOAN} = 'y')
I'm using a SQL server database. I am trying to pull records where the disb date and cancelled date are null; the app status is anything except for 2, 3, or 4; and the reg date is within the last year OR the c perm field is y.
When I added the last section, in the reverse order,
({TRANSACTIONS.CPERM_LOAN} = 'y' or {TRANSACTIONS.REG_DATE} in dateadd("yyyy",-1,currentdate) to currentdate )
it ignored the reg date field selection and pulled only records where the disb date and cancelled date are null; the app status is anything except for 2, 3, or 4; and the cperm field was y. When I swapped the arguments, it then began ignoring the cancelled date argument.