Member Junction
    Preparing search index...

    Class RunAdhocQueryAction

    Action that executes read-only SQL SELECT queries for research purposes with security validation.

    Security Features:

    • SELECT-only enforcement (rejects INSERT, UPDATE, DELETE, DROP, etc.)
    • Dangerous operation detection (EXEC, xp_, sp_, dynamic SQL, etc.)
    • Query timeout protection
    • Audit logging of all queries
    • Result size limiting

    Performance Features:

    • Configurable row limits to prevent overwhelming results
    • Execution time tracking
    • Validation warnings for potentially slow queries

    Note: SQL syntax validation is handled by SQL Server during execution. This provides more accurate error messages than a JavaScript parser.

    // Simple SELECT query
    await runAction({
      ActionName: 'Run Ad-hoc Query',
      Params: [{
        Name: 'Query',
        Value: 'SELECT TOP 100 * FROM Customers WHERE Country = ''USA'''
      }]
    });

    // Query with timeout
    await runAction({
      ActionName: 'Run Ad-hoc Query',
      Params: [{
        Name: 'Query',
        Value: 'SELECT COUNT(*) FROM Orders GROUP BY CustomerID'
      }, {
        Name: 'Timeout',
        Value: 60
      }]
    });

    Hierarchy (View Summary)

    Index

    Constructors

    constructor

    Methods

    InternalRunAction Run

    Constructors

    Methods

    Settings

    Member Visibility

    On This Page

    Constructors
    Methods