Since we don't have outer joins I would build a work file starting with
selecting all employees, then select the calls and merge them together
in a loop. How you do it depends on how you want to present the data.
If you're happy with showing the calls as multi values you can build the
records that way and if you like one row per call you should probably
have one row per call.
Then report on the work file.
That is the easiest way I can see to include employees who didn't make
any calls.
I can also think of a few approaches involving stored parameters and
dictionaries or a dictionary in the employee file that builds the call
info in a subroutine as multivalues using an index by employee on the
calls file.
In any case you will most likely need to base your report on the
employees file not the calls.
On 02/07/2012 14:53, Hennessey, Mark F. wrote:
I need to do a UniVerse LIST statement that would only populate a column if the
contents met certain criteria.
For example, suppose we have a file with details of telephone usage and that 3 associated
mulitvalued fields contain date call was made, duration and if the call was a toll call.
Is it possible to limit the output of the "date call made" and associated
columns to a date range without that being a select criteria? If I were to do something
like:
LIST CALLS EMP.NAME EMP.LOCATION WITH DATE.CALL GE "2012-06-01" AND WITH DATE.CALL LE
"2012-06-30" DURATION TOLL WITH @ID EQ '123456'
I would get zero record if employee 123456 did not make any calls in June. What
I would like to see is the employer name and location returned with the date,
duration and toll columns empty. I'm trying to do this in a LIST statement as
it will be run by U2 Web Services (and for the time being a subroutine is off
the table...)
Any advice, or an authoritative "NO, It can not be done" would be greatly
appreciated.
Mark Hennessey
State of Connecticut
Department of Social Services
Information Technology Services
Child Support Systems
Voice: 860-424-5261
Fax: 860-424-4813
CONFIDENTIAL INFORMATION: The information contained in this e-mail may be
confidential and protected from general disclosure. If the recipient or reader
of this e-mail is not the intended recipient or a person responsible to receive
this e-mail for the intended recipient, please do not disseminate, distribute
or copy it. If you received this e-mail in error, please notify the sender by
replying to this message and delete this e-mail immediately. We will take
immediate and appropriate action to see to it that this mistake is
corrected.[*LD*]
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
