on 04-28-2008 11:15 PM
Post Author: Kathleen
CA Forum: Data Connectivity and SQL
The purpose of the attamy is to pull up any client that was served in a time range. So we have been using the Intake "{CLIENT.InDateStart}" and the {CLIENT.InDateEnd} as agency open and close dates. So for instance I want to know this for 1/1/07 - 12/31/07, the open date could be anything and the close could be blank or between those date.
We have worked throught the select formula, and have came to the conclusion that the end date is giving us problems. Certain people are not showing up that should. We looked in the SQL table to see what exactly is storing in the blank end dates, and found clients that were transferred in to casper are showing blank but new clients that I've had to enter since the transfer are storing "NULL". Those clients that are have "NULL" in the end dates are not showing up on the report. So the issue is how do I get blank and "NULL" values to show on my report?
We are having the same issue in a second report where we are tracking medical appointments. We have a report that runs by appointment date. We show the date, person's name, doctor's name and comments that the doctor had during the appointment. If the comments are blank, we know that an appointment was missed. However, in the report, if there are no comments, the entire entry does not show up on the report. This is defeating the purpose of the report entirely. Please help!
Post Author: Marcotte
CA Forum: Data Connectivity and SQL
Can you post your SQL statement?
What you probably want to do is include an OR in the WHERE clause along the lines of ...
SELECT <fields> FROM <table>
WHERE <condition1> and ({CLIENT.InDateEnd} = "" OR {CLIENT.InDateEnd} IS NULL)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
11 | |
11 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.