Open ITSM Hub
Deutsch

ligero.DynamicFieldRemoteDB

Free

by LigeroSmartcommunity

Dynamic Field backend to retrieve values from external databases for LigeroSmart and Znuny.

The ligero.DynamicFieldRemoteDB package is an extension for LigeroSmart and Znuny that introduces a new type of dynamic field. Unlike standard fields, values are not stored statically but are retrieved at runtime from an external (remote) database. This allows for seamless integration of third-party systems such as ERP, CRM, or inventory databases directly into the ticketing interface. Configuration is flexible per field, including SQL statements and filter rules (constrictions) that can reference other ticket or customer data.

Features

  • External Database Connectivity

    Enables connection to external SQL databases such as MySQL, PostgreSQL, or Oracle to use data directly in ticket fields.

  • Dynamic Value Lists

    Populates dropdown or multiselect fields dynamically with results from SQL queries.

  • Context-aware Filtering

    Filters retrieved data based on ticket attributes or customer information (constrictions).

  • Caching Support

    Supports caching of query results to reduce database load and improve performance.

Categories

Dynamic FieldRemoteDBSQLIntegrationDatabaseIntegrations & APIDynamic Fields

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