Query folder to find topics with a blank Description field

I am trying to create a query folder to find all topics that contain certain text in the title (RETIRE TEST CLEAN) AND a Decscription field that is empty/blank. Can this be done. I have tried:

<ishfolderquery>
<ishobjecttypes>
<ishobjecttype ishtype="ISHModule" />
</ishobjecttypes>
<ishfields>
<ishfield name="FTITLE" level="logical" ishoperator="like">%RETIRE TEST CLEAN%</ishfield>
<ishfield name="FDESCRIPTION" level="logical"></ishfield>
</ishfields>
</ishfolderquery>

AND

<ishfolderquery>
<ishobjecttypes>
<ishobjecttype ishtype="ISHModule" />
</ishobjecttypes>
<ishfields>
<ishfield name="FTITLE" level="logical" ishoperator="like">%RETIRE TEST CLEAN%</ishfield>
<ishfield name="FDESCRIPTION" level="logical" ishoperator="like">%%</ishfield>
</ishfields>
</ishfolderquery>

AND

<ishfolderquery>
<ishobjecttypes>
<ishobjecttype ishtype="ISHModule" />
</ishobjecttypes>
<ishfields>
<ishfield name="FTITLE" level="logical" ishoperator="like">%RETIRE TEST CLEAN%</ishfield>
<ishfield name="FDESCRIPTION" level="logical" ishoperator="like"></ishfield>
</ishfields>
</ishfolderquery>

Is there a way to designate an empty field?

  • Hi Maria,

    I would try:

    <ishfolderquery>

       <ishobjecttypes>

          <ishobjecttype ishtype="ISHModule" />

       </ishobjecttypes>

       <ishfields>

          <ishfield name="FTITLE" level="logical" ishoperator="like">%RETIRE TEST CLEAN%</ishfield>

          <ishfield name="FDESCRIPTION" level="logical" ishoperator="empty" />

       </ishfields>

    </ishfolderquery>

    Documentation can be found here