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

  • Creator
    Topic
  • #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,

  • Author
    Replies
  • #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

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