View Source

With CRUD, one will not need to do all the manual wiring in constructing a CRUD entity. This element equips you with plenty of customization, making sure that you can achieve what you want.

You can configure the Performance settings in this Userview Element to cache existing content for improved performance and loading speed.

Knowledge Base for v6 > CRUD > hr_expense_screen2.jpg

Figure 1: Screenshot showing CRUD taken from the sample HR Expenses Claim app

In Joget Workflow v5, the delete function is now able to delete dependency data.

Knowledge Base for v6 > CRUD > screencapture-localhost-8080-jw-web-console-app-hr_expense-1-userview-builder-hr_expense_userview-1439888600333.png

Figure 2: CRUD Properties

Name

Description

Custom ID

Item link slug. Optional field.

Value defined here must be unique to the rest of the Userview Menus as the first matching name will be called upon.

Label

Menu label. Mandatory field.

List

Datalist to load. Mandatory field.

Form (Add)

Target form to open when adding new record. Optional field.

If this attribute is not mapped, then ability to Add is disabled.

Form (Edit)

Target form to open when editing existing record. Optional field.

If this attribute is not mapped, then ability to Edit is disabled.

Knowledge Base for v6 > CRUD > hr_expense_screen3.jpg

Figure 3: CRUD Properties - UI (List)

Name

Description

Show Number of Rows In Menu

Show Number of Rows In Menu.

Additional query will be performed to return record count every time the Userview loads.

Button Position

Top Left
Top Right
Bottom Left
Bottom Right
Top Left & Bottom Left
Top Right & Bottom Right

Selection Type

Multiple
Single

Selector Position

Left
Right
Both let & right
No

Edit Link Label

Edit Link Button Label to show in listing.

New Record Button Label

New Record Button Label to show in listing.

Delete Button Label

Delete Button Label to show in listing.

Show Delete Button?

When checked, the delete button will be shown, effectively enabling the deletion capability. If "Show Delete Button" is enabled, the following options will be shown:

Delete Associated Grid Data?

Delete Associated Child Form Data?

Delete Files?

Abort Related Running Processes?

Custom Header

Custom Header in HTML to show above the listing.

Custom Footer

Custom Footer in HTML to show below the listing.

Knowledge Base for v6 > CRUD > screencapture-localhost-8080-jw-web-console-app-hr_expense-1-userview-builder-hr_expense_userview-1439888655953.png

Figure 4: CRUD Properties - Actions (List)

Name

Description

More Actions

This attribute allows you to add more actions into the listing.

Name	Description
Label	Link label.
Hyperlink	Hyperlink URL.
Parameter Name	Parameter name to be part of the hyperlink.
Column Name	Parameter value to be assigned to the parameter name declared above by defining the column name from the Data List.
Confirmation Message	Confirmation message before opening the link.

Example:

Knowledge Base for v6 > CRUD > image2015-9-10 18:42:36.png

Knowledge Base for v6 > CRUD > screencapture-localhost-8080-jw-web-console-app-hr_expense-1-userview-builder-hr_expense_userview-1439888661584.png

Figure 5: CRUD Properties - UI (Add)

Name	Description
Cancel Button Label	Cancel Button Label to show in add new record form.
Save Button Label	Save Button Label to show in add new record form.
Custom Header	Custom Header in HTML to show in add new record form.
Custom Footer	Custom Footer in HTML to show in add new record form.

Knowledge Base for v6 > CRUD > screencapture-localhost-8080-jw-web-console-app-hr_expense-1-userview-builder-hr_expense_userview-1439888667940.png

Figure 6: CRUD Properties - Actions (Add)

Name

Description

Message to show after Form saved

Message to show after Form saved.

Action to perform after Form saved

Return to list
Continue on Adding Record
Display in Edit Mode
Redirection

After Form Saved - Redirection (Hyperlink)

Hyperlink URL.

This option is only active when "Action to perform after Form saved" is set to "Redirection".

userviewFormLink

After Form Saved - Redirection (Parameter Name)

Parameter to be appended as part of the link defined above.

id

After Form Saved - Redirection (Field Name)

Value to be assigned to the parameter defined above.

id

Knowledge Base for v6 > CRUD > screencapture-localhost-8080-jw-web-console-app-hr_expense-1-userview-builder-hr_expense_userview-1439888673968.png

Figure 7: CRUD Properties - UI (Edit)

Name	Description
Readonly	If checked, effectively, the form will be rendered as read only and not editable anymore.
Display Fields as Labels when in Readonly?	When the form is in read only form, determines if values should be displayed as it is (label form) instead of being bounded in original input form.
Back Button Label	Back Button Label Default value: Back
Save Button Label	Save Button Label Default value: Save
Record Traversing	Enable record traversing when viewing a individual record in its form.
First Record Button Label	First Record Button Label. Only applicable when Record Traversing is enabled. Default value: First Record
Previous Record Button Label	Previous Record Button Label. Only applicable when Record Traversing is enabled. Default value: Previous Record
Next Record Button Label	Next Record Button Label. Only applicable when Record Traversing is enabled. Default value: Next Record
Last Record Button Label	Last Record Button Label. Only applicable when Record Traversing is enabled. Default value: Last Record
Custom Header	Custom Header in HTML to show when editing an individual record in a form.
Custom Footer	Custom Footer in HTML to show when editing an individual record in a form.

Knowledge Base for v6 > CRUD > screencapture-localhost-8080-jw-web-console-app-hr_expense-1-userview-builder-hr_expense_userview-1439888679690.png

Figure 8: CRUD Properties - Actions (Edit)

Name

Description

Message to show after Form saved

Message to show after Form is saved

Action to perform after Form saved

Return to list
Continue on edit record
Continue on edit next record
Redirection

After Form Saved - Redirection (Hyperlink)

URL to redirect to after submission. Only applicable when Action to perform after Form saved is set to Redirection.

After Form Saved - Redirection (Parameter Name)

Parameter to be included. Only applicable when Action to perform after Form saved is set to Redirection.

After Form Saved - Redirection (Field Name)

Parameter value to be assigned to the parameter above by defining a field ID from the form. Only applicable when Action to perform after Form saved is set to Redirection.

More Actions

Include action buttons to be added into the bottom of the form.

Name	Description
Label	Action button label. Example: New Action Button
Hyperlink	URL
Parameter Name	Parameter name to be added to the URL defined above.
Field Name	Field ID correspondent to the form to retrieve value from and set to the parameter above.
Confirmation Message	Confirmation message to prompt before proceeding after clicking on the button.

Example:

Knowledge Base for v6 > CRUD > image2015-9-10 18:38:43.png

When such button is clicked, the form will not be saved.

Knowledge Base for v6 > CRUD > screencapture-localhost-8080-jw-web-console-app-hr_expense-1-userview-builder-hr_expense_userview-1439888685449.png

Figure 9: CRUD Properties - Advanced

Name	Description
Userview Key Name	Define a column name to pre-filter the datalist against using the userview key value.

Screenshots taken from http://localhost:8080/jw/web/console/app/expenseclaim/1/userview/builder/home