/ Forums / Advansys Formativ / Creating Solutions with Formativ / Assistance needed with a filter statement

  • Creator
    Topic
  • December 7, 2001 at 5:57 am #3845
    dstrickler
    Participant

      I’m having trouble with a filter expression, and was wondering if you could help. Since this is really an ObjAPI question, feel free to defer…

      I am trying to find all Read or Opened mail that does not have “X” in a custom field called ABC.

      I have included what I have below. I am having trouble with the “not” qualifyer. It works find (but doesn’t return what I want) without the “not.

      (READ AND MAIL AND (Not <ABC, String> MATCHES “X”)) OR (OPENED AND MAIL AND (Not <ABC, String> MATCHES “X”))

      Thanks,

    • Creator
      Topic
    • Author
      Replies
    • December 9, 2001 at 10:33 pm #6381
      Support 1a
      Participant

        You may wish to try the following syntax:

        (MAIL) AND (READ OR OPENED) AND (<ABC, String> DOESNOTCONTAIN “”X””)

        This may or may not work, depending on your application – this does a ‘not contains’, as opposed to ‘does not equal’, which I’m not sure is possible with the filter syntax.

        If this is not acceptable, you may need to perform two processes: one to filter on MAIL and READ or OPENED, then iterate through the resulting message list and process only those messages that do not contain a single ‘X’ in the ABC field.

        I hope this helps.

        Advansys Support

      • Author
        Replies
      Viewing 1 replies (of 1 total)
      • You must be logged in to reply to this topic.