Is there any significance of testing the BO report by getting the Dataprovider SQL and running it against the DB to check whether the report and the DB gives the same data?
Is it like integrity check? Will we be able to find out any mis-match with the help of this?Kindly help me out in this.
RE: Is there any significance of testing the BO report by getting the Dataprovider SQL and running it against the DB to check whether the report and the DB gives the same data?
Both Data Provider SQL from report and SQL pasted in TOad tend to give the same results.But only thing is you can change the paraeters passed instatntly and get the output fast if u want to test huge amount of date
RE: Is there any significance of testing the BO report by getting the Dataprovider SQL and running it against the DB to check whether the report and the DB gives the same data?
In the query panel go to SQL button -> there you can find the SQL query generated for that particular data provider. use the same sql query and run it in the backend. the results should match with the report data or when you see Data -> view data -> results tab.
RE: Is there any significance of testing the BO report by getting the Dataprovider SQL and running it against the DB to check whether the report and the DB gives the same data?
Hi
The most difficult thing in BO is to Test since we dont have any backtrace mechanism.
So to test the report the most important thing to know is the Logic of the report i.e Business logic behind the report. Thats y BO is called as analysis tool also.
By running the reports query in backend will not give u the answer whether ur reports funcitionality is perfect or not its Illogical to run the query generated by BO itself at backend since it will give u same result.
Hence
To check whether ur reports data is perfect or ur report gives u the data same as the clients requirement u need to test the report by creating Ur on logic query as per the queries requirment at backend. and for this u need to know the Business ligic and requirment of report.
