Non Selection of Empty Fields in Routine
- emushaija
- Topic Author
- Offline
- Senior Member
-
Less
More
- Posts: 57
- Thank you received: 4
14 years 3 months ago - 14 years 3 months ago #8690
by emushaija
Non Selection of Empty Fields in Routine was created by emushaija
Helow Good People
I have a routine and want to filter non-value fields from appearing in the results
CRITERIA='LIQ'
OVR.STATUS='CUR'
EMPTY=''
SEL.LD.CMD = "SSELECT ":FN.LD:" WITH STATUS EQ ":CRITERIA:" AND WITH OVERDUE.STATUS NE ":OVR.STATUS:" AND WITH OVERDUE.STATUS NE ":EMPTY
It brings me 0 results(if i remove last statement WITH OVERDUE.STATUS NE ":EMPTY it brings results)
Any ideas?
I have a routine and want to filter non-value fields from appearing in the results
CRITERIA='LIQ'
OVR.STATUS='CUR'
EMPTY=''
SEL.LD.CMD = "SSELECT ":FN.LD:" WITH STATUS EQ ":CRITERIA:" AND WITH OVERDUE.STATUS NE ":OVR.STATUS:" AND WITH OVERDUE.STATUS NE ":EMPTY
It brings me 0 results(if i remove last statement WITH OVERDUE.STATUS NE ":EMPTY it brings results)
Any ideas?
Last edit: 14 years 3 months ago by emushaija.
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2860
- Thank you received: 650
14 years 3 months ago #8694
by jpb
Replied by jpb on topic Re: Non Selection of Empty Fields in Routine
use
EMPTY='""'
EMPTY='""'
Please Log in or Create an account to join the conversation.
- emushaija
- Topic Author
- Offline
- Senior Member
-
Less
More
- Posts: 57
- Thank you received: 4
14 years 3 months ago #8696
by emushaija
Replied by emushaija on topic Re: Non Selection of Empty Fields in Routine
Hi JPB
It has been a long time hope you are doing great!
I have tried it but is not working.Am missing something somewere?
It has been a long time hope you are doing great!
I have tried it but is not working.Am missing something somewere?
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2860
- Thank you received: 650
14 years 3 months ago #8698
by jpb
Replied by jpb on topic Re: Non Selection of Empty Fields in Routine
Thanks a lot, I'm fine.
I know it's a stupid question, but are you sure you have LD's with OVERDUE.STATUS set to smoething?
Try LIST Fxxx.LD.LOANS.AND.DEPOSITS WITH STATUS EQ "LIQ" AND WITH OVERDUE.STATUS NE "CUR" OVERDUE.STATUS
I know it's a stupid question, but are you sure you have LD's with OVERDUE.STATUS set to smoething?
Try LIST Fxxx.LD.LOANS.AND.DEPOSITS WITH STATUS EQ "LIQ" AND WITH OVERDUE.STATUS NE "CUR" OVERDUE.STATUS
Please Log in or Create an account to join the conversation.
- emushaija
- Topic Author
- Offline
- Senior Member
-
Less
More
- Posts: 57
- Thank you received: 4
14 years 3 months ago #8699
by emushaija
Replied by emushaija on topic Re: Non Selection of Empty Fields in Routine
Hello JPB
It is not stupid question at all! there are loans with that criteria.
I think made mistake when executing the command you sent earlier .It is working fine by putting
EMPTY="''"
Thanks a lot!
It is not stupid question at all! there are loans with that criteria.
I think made mistake when executing the command you sent earlier .It is working fine by putting
EMPTY="''"
Thanks a lot!
Please Log in or Create an account to join the conversation.
Time to create page: 0.031 seconds