Forum Discussion

Hariharan_R's avatar
Hariharan_R
Icon for Solution Sage rankSolution Sage
7 years ago

Filter and Dynamic Result

Hi      I have below tables and i need to get "Default/Bonus" (red colour columns) column on Trans table. Also mentioned the logic for the columns.     We will be using RLS to filter the student....
Need Help
Hariharan_R's avatar
Hariharan_R
Icon for Solution Sage rankSolution Sage
7 years ago

Hi 

 

  dates are in mm/dd/yyyy format.

 

Thanks

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

In the third table, there is no Student/Subject column.  So then how would we know what default/bonus column rule to apply.

  • Hariharan_R's avatar
    Hariharan_R
    Icon for Solution Sage rankSolution Sage
    7 years ago

    Hi

     

       Third tables datetime column should compare with score table.

     

    For example, if third table's datetime value is between the score.StartDate and Score.EndDate then Bonus value else default value. It also should consider the year of third table and year of score table.

     

    condition - if(CourseDateTime>Score.StartDate
    && CourseDateTime<Score.EndDate, Bonus, Default)

  • Hariharan_R's avatar
    Hariharan_R
    Icon for Solution Sage rankSolution Sage
    7 years ago

    Can anyone achieve this?