Problem Statement
When a Datalist created is being viewed in an Userview's List, there are few things that will take place.
In this article, we will be using a custom query to build the data set for the Datalist. The custom query will be placed in JDBC Datalist Database Binder.
Let's set the stage first.
- There are 2 tables, order and order_item.
- order table has 1 million rows.
- order_item has 2 million rows.
- Every order has 2 order item.
This is the select query that we will use in the datalist binder.
QuerySELECT o.*, i.* FROM order o JOIN order_item i ON o.id = i.order_id
Viewing a List in Userview
aaa