1 Reply Latest reply: May 14, 2014 1:18 PM by user9976634 RSS

    LBYPROC Filter Not Returning Correct Results

    255be6e2-bad8-40d5-ba63-3d93ec9afd2e

      I'm trying to use the LBYPROC with a filter script to only retrieve certain faps that will be promoted to a different environment. No matter what I try I get back a huge number of results, even though I can use the Documaker app, go to the Library and enter the description and only 2 results show. I've tried saving the script from Documaker and it still doesn't work. Here is the filter:

       

      <DOCUMENT TYPE="RPWIP" VERSION="11.5">

      <LBYSCRIPT>

      <FILTER>

      <LIBRARY VALUE="SQLTEST_ABC"/>

      <LO VALUE="0"/>

      <NAME VALUE=""/>

      <TYPE VALUE=""/>

      <DESC VALUE="ABCDEF - Executive Assurance - PHASE 100 - SFM 99999 - EXEASSURANCE MAIN PAGE TSB 5555B"/>

      <VERSION VALUE="all"/>

      <REVISION VALUE="last"/>

      <USERID VALUE=""/>

      <SECURED VALUE=""/>

      <EFFDATE VALUE=""/>

      <EFFDATE2 VALUE=""/>

      <MODTIME VALUE=""/>

      <MODTIME2 VALUE=""/>

      <MODE VALUE=""/>

      <STATUS VALUE=""/>

      <CLASS VALUE=""/>

      <PROJECT VALUE=""/>

      <OBJECTTYPE VALUE=""/>

      <OBJECTNAME VALUE=""/>

      <OBJECTTEXT VALUE=""/>

      <OBJECTTEXTCASE VALUE=""/>

      </FILTER>

      </LBYSCRIPT>

      </DOCUMENT>

       

      I am calling it in a .bat file that has the following:

       

      LBYPROC.EXE /I=E:\ABC\ABCProdAutoPromote\filter5.LSC /INI=E:\ABC\DC0SQL\mstrres\SQLSTG\FSIUSER.INI /TEST /P /S

       

      What am I doing wrong?

       

      Thanks for any help!

      Ken