User-friendly Oracle APEX App for teams to report bugs/enhancements, communicate resolutions, and test your organization's APEX App Issues, of a given APEX Workspace.

• License
• Demo App
• Features
• Install
• Usage Guide
• Settings
• Version History
• Known Issues
• About Author
• About SOTFUL
• Become a Contributor
• Comercial Support
• Contributors

Apache 2.0

URL: https://apex.oracle.com/pls/apex/r/s_e/testboard

Username: contact@sotful.com

Password: orclapex1

• Create Issues and assign it to APEX Developers from a given Workspace.
• Update Issues values in Interactive Grid or Form.
• Add screenshots to a given issue.
• Add comments to a given issue.
• Add Tests to a given issue.
• View and filter Issues in View mode.
• View and filter Issues in Board mode.
• Manage LOVs values in Settings.

In SQL Developer open and run _instal.sql located in the folder DATABASE.

In your APEX Builder import the APEX App TestBoard.sql located in the folder APP.

The SOTFUL APEX TestBoard app uses the APEX Users Repository for the authentication and authorization. This means we have three permission levels: Workspace Administrator, Developer and End User. We the level of a given user checking the table APEX_WORKSPACE_APEX_USERS and the columns IS_ADMIN and IS_DEVELOPER. We can see the user level on the page Authorizations. These Authorizations can be updated in APEX Builder clicking on Administration > Manage Users and Groups.

• Administrator

Can access Admin pages.

• Developer

Can create new LOVs.

Can update existing LOVs.

• End User

Can update existing LOVs.

The values of the existing LOVs can be easily managed by the end user. New LOVs can be created by APEX Developers or by APEX Workspace Administrators.

The Read Only Fields are easily distinguished with the use of a Custom CSS in Theme Roller, as shown here:

.a-GV-cell:is(.is-readonly) { background-color: #DFE1E4 !important; }

.display_only { background-color: #DFE1E4 !important; }

Main

• Added Board View (read only for now).
• Preview.
• Demo App.
• Updated Readme.

Main

• Create Admin pages.
• Add Filter Items: Issue Id, Title.
• Create Lockup Table and LOV Admin.
• Get Workspace Id.
• Add Region Help from question icon.
• Updated Readme.

UI

• Add TestBoard on all Page Names.
• Icons in Buttons.
• Admin Card Links.
• Format Read Only Fields in Interactive Grid and Forms.
• Match Fields Position in Issues page and Edit Issue page.

Permissions

• Apply Author Permissions.
• Apply Administrator and Developer Permissions.

None at this time.

We encourage you to become a contributor, by fixing bugs and developing extra features. Comment one of the opened issues or register a new one, to let others know what you are working on. When you finish, create a new pull request. We will review your code and add the changes to the repository.

By contributing to this repository, you help to build a strong APEX community. We will prioritize any issues raised by you.

If you need support for this App, please contact us at apex@sotful.com. We can assign a dedicated Senior Oracle APEX Developer to your project.

None at this time.