1 Reply Latest reply on Mar 23, 2015 9:55 AM by philmodjunk

    FilterElements Problem

    Gilo

      Title

      FilterElements Problem

      Post

      Hi

      I have a field which can get 0 or 1 as value. Right now I'm using this formula, which works nearly ok:

      Falls(NICHT IstLeer ( FilterElemente ( Liste ( tous contrats ménage::contrats_type ) ; "Opus Life - Equatoria" ) ) = 1; "1";
      NICHT IstLeer ( FilterElemente ( Liste ( tous contrats ménage::contrats_type ) ; "Opus Life - Azzura" ) ) = 1; "1";
      NICHT IstLeer ( FilterElemente ( Liste ( tous contrats ménage::contrats_type ) ; "VivaZen" ) ) = 1; "1";

      0)

      Sorry that's in german, but i should be about: 

      Let (NOT ISEMPTY (FilterElements (List (table:fieldA); "ProductA")) = 1 ; "1";
      NOT ISEMPTY (FilterElements (List (table:fieldA); "ProductB")) = 1 ; "1";
      "0")

      This works for fieldA but I need now, that FieldA corresponds to "productA" or "productB" but also that fieldB = "in stock".

      I've tried with AND but did not get it to work. Can someone help?

       

        • 1. Re: FilterElements Problem
          philmodjunk

          In English, it would be FilterValues rather than FilterElements.

          Using just List, you'd have to use a calculation field defined in the related table that is empty if the product is not in stock. But you can also get the results you want using ExecuteSQL().