5 Replies Latest reply: Jul 19, 2016 5:01 AM by Nishanthi Rajendran RSS

    Dynamic Field value in the where condition

    Nishanthi Rajendran

      I have two table where month and year is used. I have attached the sample coding of that below :


      Map_load:
      Mapping load
      "ID" ,
      'Assigned' as PrjAssignment
      Resident Assign
      where Month_Year='Jun-2016';

      //Assignment_Status:
      join (Employees)
      Load
      "ID",
      ApplyMap('Map_load',"ID",'Not Assigned') as Status

      Resident Employees
      where Month_Year='Jun-2016';

              Here the month and year should be dynamic for example if I have march,april,may it should take it dynamically without specifying in where clause like how it is done above. Any possible solutions for this ?