infoset error

 0 Replies
 0 Subscribed to this topic
 14 Subscribed to this forum
Sort:
Author
Messages
AJ
Basic Member
Posts: 6
Basic Member
    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.