find_fields
Locate database fields in EMS systems using keyword search, hierarchical browsing, or deep traversal to identify data elements for querying and analysis.
Instructions
Find fields in a database. Three modes available:
search: Fast keyword search (default). Requires search_text. Does NOT work on entity-type databases.
browse: Navigate field group hierarchy. Use group_id to drill down.
deep: BFS traversal across all field groups. Requires search_text. Works on ALL databases including entity-type. Slower (multiple API calls).
Results show numbered references [N] that can be used directly in query_database, get_field_info, etc. Field names also work.
Args: ems_system_id: EMS system ID. database_id: Database ID or name (e.g. "FDW Flights"). mode: "search" (fast keyword), "browse" (navigate groups), or "deep" (BFS). search_text: Search keyword (required for search and deep modes). group_id: Field group ID to navigate into (browse mode only). max_results: Maximum results (search/deep modes, default: 50). max_depth: Maximum traversal depth (deep mode, default: 5, max: 10). max_groups: Maximum API calls (deep mode, default: 50, max: 200). show_ids: If True, show full IDs inline instead of numbered references.
Returns: Fields with names, types, and IDs (or numbered references).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| ems_system_id | Yes | ||
| database_id | Yes | ||
| mode | No | search | |
| search_text | No | ||
| group_id | No | ||
| max_results | No | ||
| max_depth | No | ||
| max_groups | No | ||
| show_ids | No |