Consultingwerk.SmartFrameworkMcpServer.Database.IDatabaseMcpService

Options	Name	Purpose
+	Progress.Json.ObjectModel.JsonArray GetConnectedDatabases ()	Returns a JSON array with the logical names of all connected databases Notes : Uses num-dbs and ldbname() @return JsonArray containing the connected database names */
+	Progress.Json.ObjectModel.JsonObject GetDatabaseTableDetails (character, character)	Returns details about a database table (fields and indexes)
+	Progress.Json.ObjectModel.JsonArray GetDatabaseTables (character)	Returns a JSON array with details about all non-hidden tables of a connected database Notes : The result includes the frameworks view on the table when available (TableDatasetModel) @param pcDatabaseName The logical database name @return JsonArray containing one JsonObject per table */
+	Progress.Json.ObjectModel.JsonArray SearchDatabaseTables (character)	Searches for database tables across all connected databases Notes : A table is included when its name or description matches the filter, or when the framework description matches @param pcFilter Filter text used in a MATCHES pattern @return JsonArray containing one JsonObject per matching table */

Options

Name

Purpose

Progress.Json.ObjectModel.JsonArray GetConnectedDatabases ()

Returns a JSON array with the logical names of all connected databases Notes : Uses num-dbs and ldbname() @return JsonArray containing the connected database names */

Progress.Json.ObjectModel.JsonObject GetDatabaseTableDetails (character, character)

Returns details about a database table (fields and indexes)

Progress.Json.ObjectModel.JsonArray GetDatabaseTables (character)

Returns a JSON array with details about all non-hidden tables of a connected database Notes : The result includes the frameworks view on the table when available (TableDatasetModel) @param pcDatabaseName The logical database name @return JsonArray containing one JsonObject per table */

Progress.Json.ObjectModel.JsonArray SearchDatabaseTables (character)

Searches for database tables across all connected databases Notes : A table is included when its name or description matches the filter, or when the framework description matches @param pcFilter Filter text used in a MATCHES pattern @return JsonArray containing one JsonObject per matching table */

Top

PUBLIC Progress.Json.ObjectModel.JsonArray GetConnectedDatabases ()

Purpose:	Returns a JSON array with the logical names of all connected databases
	Notes : Uses num-dbs and ldbname()

Returns	Progress.Json.ObjectModel.JsonArray
	JsonArray containing the connected database names

Top

PUBLIC Progress.Json.ObjectModel.JsonObject GetDatabaseTableDetails (character, character)

Purpose:	Returns details about a database table (fields and indexes)
Notes:

Parameters:
pcDatabaseName	CHARACTER
	The logical database name
pcTableName	CHARACTER
	The database table name
Returns	Progress.Json.ObjectModel.JsonObject
	JsonObject containing a "fields" and "indexes" JsonArray

Top

PUBLIC Progress.Json.ObjectModel.JsonArray GetDatabaseTables (character)

Purpose:	Returns a JSON array with details about all non-hidden tables of a connected database
	Notes : The result includes the frameworks view on the table when available (TableDatasetModel)

Parameters:
pcDatabaseName	CHARACTER
	The logical database name
Returns	Progress.Json.ObjectModel.JsonArray
	JsonArray containing one JsonObject per table

Top

PUBLIC Progress.Json.ObjectModel.JsonArray SearchDatabaseTables (character)

Purpose:	Searches for database tables across all connected databases
	Notes : A table is included when its name or description matches the filter, or when the framework description matches

Parameters:
pcFilter	CHARACTER
	Filter text used in a MATCHES pattern
Returns	Progress.Json.ObjectModel.JsonArray
	JsonArray containing one JsonObject per matching table