LIST CALLS '123456' EMP.NAME EMP.LOCATION DATE.CALL GE "2012-06-01" AND LE "2012-06-30" DURATION TOLL
? > From mark.hennessey > > 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 _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
