- Sortable HTML Table w/Prompt

Sortable HTML Table w/Prompt

Step 1:

A) create an Operation

• • set the Operation Type to: the type needed. Can also create Association Operations with a Parent Operation as well.

  • in the Operation Code: you can create any type of SQL statement needed but in this sample, we are ORDERING BY the same field that we will edit the FD in later.

  • in the WHERE statement, there is a ‘?’ that allows the filter to display on the end results. This Parameter passed is giving the end user the ability to type in what they are searching for.

B) set the following properties

• • (Optional) fill in the DisplayColumn{ results:<fields_to_display>; details: ; } property in Properties for the desired fields to be shown to the end user. In order to choose which fields to show, the Operation Code must include at least these fields. Here is where you can hide fields you don’t want to show end users by not adding it to the results section of the Display property. Separate fields by a comma.

  • example: DisplayColumn{ results: ID, Display_Order, Column_Name; details: ; }

C) set the following properties:

• • JSP File to: Sortable Results

D) click the Insert Operation button when complete.

Note: examples of the running Application below.

A) choose an Operation to run.

B) enter in field to search then click the Search button

C) displays the results of the search

D) dragging a row

E) dropping the row in the desired position