> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Alexander Blauvelt
> Sent: Tuesday, June 22, 1999 6:23 AM
> To: emerald@iea-software.com
> Subject: [Emerald] Query / rebatch
>
>
> Hi Dale and crew,
>
> I need a query that will pull the username (login + "@olg.com" type
> thing) and full name of everyone in the batch screen with failed
> transactions. I don't want the expired cards (E1), just ones that are
> ND and NR.
>
> The query I came up with is this:
>
> select sa.login + '@olg.com', ma.firstname + ' ' + ma.lastname
> from ExternalTrans e, MasterAccounts ma, SubAccounts sa, invoices i
> WHERE ma.customerid = sa.customerid
> AND e.InvoiceID = i.InvoiceID
> AND ma.CustomerId = i.CustomerID
> and (e.response = "ND" or e.response = "NR")
> and e.transtype != 8 and e.transtype != 7
> and sa.sendbill=1
>
>
> However, this pulls 518+- customers and the batch list only has 300
> failed transactions, including the expired cards. What other criteria
> am I missing? What criteria is used to display the transactions in the
> batch window ? I need that query with a small modification to remove
> expired cards from the list.
>
> Alex
> Online Gateway, Inc.
>