Forum Discussion
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....
Hi,
In the third table, there is no Student/Subject column. So then how would we know what default/bonus column rule to apply.
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)
Can anyone achieve this?