Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sue70
Starting Member
3 Posts |
 Posted - 2012-09-21 : 14:16:47
|
| Hi all,I am trying to write test cases for the following rules but they are a bit confusing. Please help. The rules are as follows:RULE 1: If the lower range rule is ‘Less Than’ or ‘Less Than or Equal’ and an upper range rule is entered the criteria will effectively read:Lower Value <= value OR Upper Value ……RULE 2: If the lower range rule is ‘Equal’, ‘Greater Than’ or ‘Greater Than or Equal’ and an upper range rule is entered the criteria will effectively readLower Value >= value AND Upper Value ……Many thanks in anticipation of your help.Sue |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-21 : 14:26:14
|
| so is lower range parameter a text based field?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-09-21 : 14:28:11
|
| Are you trying to write rules in SQL, or are you trying to develop test cases (before writing them in SQL or some other language)?Can you post some examples of what you have tried, even if they are not complete or correct? |
|
|
|
Sue70
Starting Member
3 Posts |
Posted - 2012-09-22 : 07:50:35
|
quote:
Originally posted by sunitabeck
Are you trying to write rules in SQL, or are you trying to develop test cases (before writing them in SQL or some other language)?Can you post some examples of what you have tried, even if they are not complete or correct?
Yes I am trying to develop test cases for the front end of a report and convert this test cases into SQL Queries for the back end validation of an application, However, because the developer is on vacation I am unable to confirm what these rules mean. For starters, I need help with the interpretation of the rules and secondly need help for how to write the sql queries.My interpretations of the rules are as follows: RULE 1: Does that mean that report will be generated for <= value OR Upper Value (1 set of report: EITHER/OR)FOR RULE 2: Does that mean that report will be generated for <= value AND Upper Value (2 sets of reports: 'AND')The information I gave above is a functional requirement of a report for a system used in finding the totals of aggregate score, Lower and Upper score of pupils performance that met a certain criteria when the report is run. E.g Upper Score = 360, Lower Score= 118 some of the test cases I have written are as follows:Rule 1( 118 <= OR Upper Value 360)meaning 118<=0R 360Rule 2( 118>= AND Upper Value 360) meaning 118>=AND 360I HOPE I have made a bit of sense, any help will be appreciated. |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-09-22 : 08:52:42
|
| Hard to say what the rules mean without knowing the business requirements. But, the way it is written, for example Lower Value <= value OR Upper Value it seems what they mean is that the report will be generated for:a) values less than or equal to the Lower Value (regardless of whether the upper value is provided or not)ORb) if there is an upper value (regardless of the value provided) |
|
|
|
Sue70
Starting Member
3 Posts |
Posted - 2012-09-25 : 03:56:27
|
Thankssunitabeck for your feedback, Its really appreciated. I will have to clarify the requirement with the DeveloperRegardsSue70quote:
Originally posted by sunitabeck
Hard to say what the rules mean without knowing the business requirements. But, the way it is written, for example Lower Value <= value OR Upper Value it seems what they mean is that the report will be generated for:a) values less than or equal to the Lower Value (regardless of whether the upper value is provided or not)ORb) if there is an upper value (regardless of the value provided)
|
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-09-25 : 07:35:09
|
You are welcome (even though I suspect I was not of much help  ) |
|
|
|
|
|
|
|
|
Translation