Open ITSM Hub
Deutsch

Rolfs-TableSearch

Free

by Rolf Schmidtindividual

Zammad extension for generic REST API searches in database tables, ideal for reporting and data exports.

Rolfs-TableSearch is a Zammad extension that adds generic REST API endpoints for searching and querying database tables directly. It is designed to facilitate custom reporting and data exports by allowing administrators to query tables using flexible conditions and operators. The package includes functionality to list all available tables, retrieve column information, and perform paginated searches. Access is secured via a dedicated permission. Note: This package is specifically designed for PostgreSQL databases and does not support MySQL.

Features

  • Generic Table Search

    Query any Zammad database table directly via a generic REST API interface.

  • Advanced Query Operators

    Supports various operators and conditions for precise data filtering.

  • Pagination Support

    Efficiently handle large datasets with support for offset and limit parameters.

  • Schema Inspection

    Endpoints to list all tables and inspect column definitions and data types.

  • Permission-Based Access

    Secure access restricted to administrators with the specific 'admin.table_search' permission.

Categories

APIDatabase SearchpostgresqlReporting & AnalyticsData ExportIntegrations & API

Related packages

OTOBO Rocket.Chat Integration

Seamlessly integrates Rocket.Chat with OTOBO for real-time communication directly from the ticket.

OTOBO
Free

addchat-laravel

AddChat Laravel is a Laravel chat package. Live chat widget for Laravel that also includes multi-user chat, group permissions, customer support chat & more.

Free

agent-desk

Open-source AI customer support system. AI-first support, human-ready operations.

Free