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.

  SELECT o.*, i.* FROM order o JOIN order_item i ON o.id = i.order_id

Viewing a List in Userview

aaa