Some One Purpose Servlets

A collection of utility servlets, each designed for a specific purpose in TRIRIGA operations.

Content to Base64

This servlet encodes binary field content to Base64. GET requests accept recordId and fieldName parameters, returning the encoded content suitable for integrations.

Decode Base64 and Attach to Document

The inverse operation: decodes Base64 content, retrieves a document recordId, and uploads the decoded content to that document record.

SQL Runner

Enables running SQL SELECT queries from browsers or API clients, providing results with appropriate exception handling and response headers showing result counts.

Note: Use with caution and ensure proper access controls are in place.

Log out all users

Attempts to replicate the Admin console's logout functionality. The implementation deleted all active user rows from the database table to force logouts. While uncertain about safety, it functioned within seconds, triggering logout popups for active users.

Warning: This is a potentially dangerous operation and should be used carefully.

Check if user is Admin

A straightforward servlet checking whether the executing user holds admin privileges using database queries—though this approach lacks efficiency.

Recommendation: Instead use a CURRENT_USER UX datasource API call, which requires no custom code and is more efficient.

Lock and Unlock

Manages TRIRIGA system locks without accessing the admin console. Useful for developers who need to manage locks programmatically.