You can do just about anything by calling a subroutine from an I-type dictionary item. On 3 July 2012 05:41, Mecki Foerthmann <mec...@gmx.net> wrote:
> 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<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<http://listserver.u2ug.org/mailman/listinfo/u2-users> > -- Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand Phone: + 64 9 360 5310 Mobile: + 64 21 400 486 Email: k...@walstan.com _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users