0 Replies Latest reply: Sep 8, 2017 11:17 AM by André Sousa Silva RSS

    Set current selections by date

    André Sousa Silva

      Hi guys,

       

      I am not able to filter in my mashup by date through javascript. I've tried several solutions

       

      app.field ("YYYYMM"). selectValues (["2011-01"], true, true);

      app.field("YYYYMM").selectValues(["40544"],true, true);

      app.field("YYYYMM").selectValues(["2012-May"],true, true);

       

      app.field("YYYYMM.autoCalendar.YearMonth").selectValues(["2012-May"], true, true); 

      app.field("YYYYMM.autoCalendar.YearMonth").selectValues(["40544"],true, true);

      app.field("YYYYMM.autoCalendar.YearMonth").selectValues(["2011-01"],true, true);


      app.field("=Dual(Year([YYYYMM])&'-'&Month([YYYYMM]),MonthStart([YYYYMM]))").selectValues(["2012-May"], true, true);

      app.field("=Dual(Year([YYYYMM])&'-'&Month([YYYYMM]),MonthStart([YYYYMM]))").selectValues(["40544"], true, true);

      app.field("=Dual(Year([YYYYMM])&'-'&Month([YYYYMM]),MonthStart([YYYYMM]))").selectValues(["2011-01"], true, true);

       

       

      Manually in chart working very well:

      Print1.png

      Print2.png

      Log CurrentSelectionsList:

      Print3.png