How to Provide where clause condition in Sql Query of a View
Hi Yellow Fin Team,
How can we specify a where clause condition while creating a View.
If you click on Model Tab of a View, will see all the Tables with there relations, Click on Table settings, we can make use of conditions but this is used only for particular Table not for the entire SQL statement.
Scenario : I have Table with status as Priority 1 (5 Records), Priority 2 (5 Records) and some data with Null (5 Records), The data with null value should be updated to Priority 2.
So when i make count while processing report it should show
Priority 1 (5 Records), Priority 2 (10 Records)
But its not possible directly if i use and Calculated fields then also its not able to sum.
Kindly required your help