PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 08/10/2012 3:56 PM by  AJ
infoset error
 0 Replies
Sort:
You are not authorized to post a reply.
Author Messages
AJ
Systems Analyst
EDMC
Basic Member
(10 points)
Basic Member
Posts:6


Send Message:

--
08/10/2012 3:56 PM
    I am trying to build an infoset that touches multiple tables. I can preview the data of the infoset on the InfoSet Wizard and successfully produce data when going after 1 table and can even preview the data with selection criteria from 2 tables. The following query allows me to preview data:

    FILE=MAINVDTL&INDEX=MADSET1&FIELD=COMPANY;PO%2DNUMBER;PO%2DCODE;LINE%2DNBR;VENDOR;INVOICE;STATUS;ENTERED%2DQTY;MAAOCDTL%2EAOC%2DCODE;APINVOICE%2EINV%2DSTATUS;APINVOICE%2EDUE%2DDATE;POLINE%2ECXL%2DQTY;POLINE%2EMATCHED%2DNO%2DREC;POLINE%2EMATCHED%2DQTY;POLINE%2EQUANTITY;POLINE%2EREC%2DQTY;POLINE%2EBUYER%2DCODE;POLINESRC%2EREQUESTER;APINVOICE%2ETRAN%2DINV%2DAMT;APINVOICE%2EREC%2DSTATUS;REC%2DSOURCE&OTMMAX=60&OTMDELIM=%7E&DELIM=%09&SELECT=STATUS%3D0%26APINVOICE%2EREC%2DSTATUS%3D0&BEGIN=60%3D+++355528%3D843542%3D0%3D+++++++9001041%3D0%3Dspaces%3D13%3D13&OUT=CSV&NOHEADER=TRUE&NEXT=TRUE

    However, when I add %26MAAOCDTL%2EAOC%2DCODE%3DMC into the query I am getting an INVALID ONE TO MANY FILTERING error. The query below produces the error:

    FILE=MAINVDTL&INDEX=MADSET1&FIELD=COMPANY;PO%2DNUMBER;PO%2DCODE;LINE%2DNBR;VENDOR;INVOICE;STATUS;ENTERED%2DQTY;MAAOCDTL%2EAOC%2DCODE;APINVOICE%2EINV%2DSTATUS;APINVOICE%2EDUE%2DDATE;POLINE%2ECXL%2DQTY;POLINE%2EMATCHED%2DNO%2DREC;POLINE%2EMATCHED%2DQTY;POLINE%2EQUANTITY;POLINE%2EREC%2DQTY;POLINE%2EBUYER%2DCODE;POLINESRC%2EREQUESTER;APINVOICE%2ETRAN%2DINV%2DAMT;APINVOICE%2EREC%2DSTATUS;REC%2DSOURCE&OTMMAX=60&OTMDELIM=%7E&DELIM=%09&SELECT=STATUS%3D0%26APINVOICE%2EREC%2DSTATUS%3D0%26MAAOCDTL%2EAOC%2DCODE%3DMC&BEGIN=60%3D+++355528%3D843542%3D0%3D+++++++9001041%3D0%3Dspaces%3D13%3D13&OUT=CSV&NOHEADER=TRUE&NEXT=TRUE

    Any help would be appreciated. Thanks.
    You are not authorized to post a reply.