| docs/index.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' as component;
WITH RECURSIVE breadcrumbs AS (
SELECT
COALESCE(abbreviated_caption, caption) AS title,
COALESCE(url, path) AS link,
parent_path, 0 AS level,
namespace
FROM sqlpage_aide_navigation
WHERE namespace = 'prime' AND path='docs/index.sql'
UNION ALL
SELECT
COALESCE(nav.abbreviated_caption, nav.caption) AS title,
COALESCE(nav.url, nav.path) AS link,
nav.parent_path, b.level + 1, nav.namespace
FROM sqlpage_aide_navigation nav
INNER JOIN breadcrumbs b ON nav.namespace = b.namespace AND nav.path = b.parent_path
)
SELECT title ,
sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/'||link as link
FROM breadcrumbs ORDER BY level DESC;
-- not including page title from sqlpage_aide_navigation
WITH navigation_cte AS (
SELECT COALESCE(title, caption) as title, description
FROM sqlpage_aide_navigation
WHERE namespace = 'prime' AND path = 'docs'||'/index.sql'
)
SELECT 'list' AS component, title, description
FROM navigation_cte;
SELECT caption as title, sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' || COALESCE(url, path) as link, description
FROM sqlpage_aide_navigation
WHERE namespace = 'prime' AND parent_path = 'docs'||'/index.sql'
ORDER BY sibling_order;
|
2025-04-11 07:54:36 |
| docs/release-notes.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' as component;
WITH RECURSIVE breadcrumbs AS (
SELECT
COALESCE(abbreviated_caption, caption) AS title,
COALESCE(url, path) AS link,
parent_path, 0 AS level,
namespace
FROM sqlpage_aide_navigation
WHERE namespace = 'prime' AND path='docs/release-notes.sql'
UNION ALL
SELECT
COALESCE(nav.abbreviated_caption, nav.caption) AS title,
COALESCE(nav.url, nav.path) AS link,
nav.parent_path, b.level + 1, nav.namespace
FROM sqlpage_aide_navigation nav
INNER JOIN breadcrumbs b ON nav.namespace = b.namespace AND nav.path = b.parent_path
)
SELECT title ,
sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/'||link as link
FROM breadcrumbs ORDER BY level DESC;
-- not including page title from sqlpage_aide_navigation
SELECT 'title' AS component, 'Release Notes for surveilr Versions' as contents;
SELECT 'foldable' as component;
SELECT 'v1.7.25' as title, '# `surveilr` v1.7.13 Release Notes
This release aims to improve the `surveilr osquery-ms` server; no new features or bug fixes were added.' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.7.16' as title, '# `surveilr` v1.7.16 Release Notes
## Bug Fixes
1. Enhanced the CSV transform functionality to correctly include partyID for each ingested CSV table when provided.
2. Resolved an issue where ingesting multiple CSV files with the same name from different folders resulted in data loss. Now, all files are consolidated into a single table while preserving distinct data sources with the partyID field.' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.7.13' as title, '# `surveilr` v1.7.13 Release Notes
This release aims to improve the `surveilr osquery-ms` server; no new features or bug fixes were added.' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.7.12' as title, '# `surveilr` v1.7.12 Release Notes
## 🚀 What''s New
### 1. `surveilr osquery-ms` Server
The server has been fully setup, configured with boundaries and the corresponding WebUI, fully configurable with `code_notebooks`.' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.7.11' as title, '# `surveilr` v1.7.11 Release Notes
## 🚀 What''s New
### 1. Upgraded SQLPage
SQLPage has been updated to version 0.33.1, aligning with the latest releases.
## Bug Fixes
### 1. `surveilr admin merge`
- Added recent and new tables to the merge structure ensuring all tables in each RSSD are present in the final merged RSSD.' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.7.10' as title, '# `surveilr` v1.7.10 Release Notes
## 🚀 What''s New
### 1. Enhancing `surveilr`''s osQuery Management Server
- Added support for boundaries to enable grouping of nodes for better viewing
' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.7.9' as title, '# `surveilr` v1.7.9 Release Notes
## 🚀 What''s New
### 1. Enhancing `surveilr`''s osQuery Management Server
- Introduced a new flag `--keep-status-logs` to indicate whether the server should store status logs received from osQuery in the RSSD.' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.7.8' as title, '# `surveilr` v1.7.8 Release Notes
This release focuses on enhancing the `surveilr osquery-ms` UI by adding new tables and optimizing data management. No bugs were fixed or new features introduced. Please review the Web UI for updates.
' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.7.7' as title, '# `surveilr` v1.7.7 Release Notes
This release aims to improve the `surveilr osquery-ms` server; no new features or bug fixes were added.' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.7.6' as title, '# `surveilr` v1.7.6 Release Notes
---
## 🚀 Bug Fixes
### 1. `surveilr` Bootstrap SQL
This release fixes the "no such table: device" error introduced in the previous version by propagating any erroors during the SQL initialization of the RSSD with `surveilr`.' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.7.5' as title, '# `surveilr` v1.7.5 Release Notes
---
### 🆕 **New Features**
- **osQuery Management Server Integration**:
- `surveilr` now acts as a management layer for osQuery, enabling secure and efficient monitoring of infrastructure.
- Supports remote configuration, logging, and query execution for osQuery nodes.
- **Behavior & Notebooks Support**:
- Introduced **Notebooks**, which store predefined queries in the `code_notebook_cell` table.
- **Behaviors** allow defining and managing query execution for different node groups.
- **Secure Node Enrollment**:
- Nodes authenticate using an **enrollment secret key** (`SURVEILR_OSQUERY_MS_ENROLL_SECRET`).
- Secure communication via **TLS certificates** (`cert.pem`, `key.pem`).
- **Automated Query Execution**:
- Default queries from **"osQuery Management Server (Prime)"** execute automatically.
- Custom notebooks and queries can be added dynamically via SQL.
- **Centralized Logging & Config Fetching**:
- Osquery logs and configurations are fetched via TLS endpoints (`/logger`, `/config`).
- All communication is secured using **server-side TLS certificates**.
- **Web UI for Query Results Visualization**:
- `surveilr web-ui` provides an intuitive dashboard to inspect query results across enrolled nodes.
- Simply start with `surveilr web-ui -p 3050 --host <server-ip>`.' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.7.1' as title, '# `surveilr` v1.7.1 Release Notes
---
## 🚀 What''s New
### 1. Enhancing `surveilr`''s osQuery Management Server
- Introduced a new flag--behavior` or `-b` to specify behavior name to queries to run automatically enrolled nodes.
- a new SQLite function called `surveilr_osquery_ms_create_behaviour` to facilitate the creation of behaviors, making process smooth and easy.
### Example
When starting the `surveilr osquery-ms` server without passing a behavior, a default behavior with the following query configuration is created:
```json
{
"surveilr-cli": {
...
"osquery_ms": {
"tls_proc": {
"query": "select * from processes",
"interval": 60
}
}
}
}
```
To use a behavior with the `surveilr` osQuery management server first create a behavior using the new function:
```bash
surveilr shell --cmd "select surveil_osquery_ms_create_behaviour(''-behaviour'', ''{\"tls_proc\": {\"query\": \"select * from processes\", \"interval\": 60}, \"routes\": {\"query\": \"SELECT * FROM routes WHERE destination = ''''::1''''\", \"interval\": 60}}'');"
```
Then, pass that behavior to the server by:
```bash
surveilr osquery-ms --cert ./cert.pem --key ./key.pem --enroll-secret "<secret>" -b "initial-behaviour"
```' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.7.0' as title, '# `surveilr` v1.7.0 Release Notes
---
## 🚀 What''s New
### **1. `surveilr` OSQuery Management Server**
Introducing Osquery Management Server using `surveilr`, enabling secure and centralized monitoring of your infrastructure. The setup ensures secure node enrollment through TLS authentication and secret keys, allowing only authorized devices to connect. Users can easily configure and manage node behaviors dynamically via `surveilr`’s behavior tables.
### **2. OpenDAL Dropbox Integration**
The `surveilr_udi_dal_dropbox` SQLite function, is a powerful new virtual table module that enables seamless interaction with Dropbox files directly within your SQL queries. This module allows users to access and query comprehensive file metadata, including name, path, size, last modified timestamp, content, and more, within specified directories.' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.6.0' as title, '# `surveilr` v1.6.0 Release Notes
---
## 🚀 What''s New
### **1. SQLPage**
- Updated SQLPage to the latest version, ensuring compatibility and access to the newest features and bug fixes.' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.5.11' as title, '# `surveilr` v1.5.11 Release Notes
---
### Overview
This release includes updates to dependencies, bug fixes, and performance improvements to enhance stability and functionality.' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.5.10' as title, '# `surveilr` v1.5.9 Release Notes
---
## 🚀 Bug Fixes
### **1. WebUI Page for About**
- A dedicated About page has been added in the WebUI to visualize the response of `surveilr doctor`:
- **Dependencies Table**:
- The display of versions and their generation process has been fixed.
- **Diagnostic Views**:
- A new section has been added to display the contents and details of all views prefixed with `surveilr_doctor*`, facilitating the of details and logs for diagnostics.' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.5.8' as title, '# `surveilr` v1.5.8 Release Notes 🎉
---
### **1. WebUI Page for About**
- Added a dedicated About page in the WebUI visiualizing the response of `surveilr doctor`:
- **Dependencies Table**:
- Displays the versions of `sqlpage`, `rusqlite`, and `pgwire` in a table.
- **Extensions List**:
- Lists all synamic and static extensions .
- **Capturable executables**:
- Lists all capturable executables that were found in the `PATH`.
- **Env variables**
- Captures all environment variables starting with `SURVEILR_` and `SQLPAGE_`.' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.5.6' as title, '# `surveilr` v1.5.6 Release Notes 🎉
---
## 🚀 What''s New
### **1. Enhanced Diagnostics Command**
- **`surveilr doctor` Command Improvements**:
- **Dependencies Check**:
- Verifies versions of critical dependencies: `Deno`, `Rustc`, and `SQLite`.
- Ensures dependencies meet minimum version requirements for seamless functionality.
- **Capturable Executables Detection**:
- Searches for executables in the `PATH` matching `surveilr-doctor*.*`.
- Executes these executables, assuming their output is in JSON format, and integrates their results into the diagnostics report.
- **Database Views Analysis**:
- Queries all views starting with the prefix `surveilr_doctor_` in the specified RSSD.
- Displays their contents in tabular format for comprehensive insights.
---
### **2. JSON Mode**
- Added a `--json` flag to the `surveilr doctor` command.
- Outputs the entire diagnostics report, including versions, extensions, and database views, in structured JSON format.
---
### **3. WebUI Page for Diagnostics**
- Added a dedicated page in the WebUI for the `surveilr doctor` diagnostics:
- **Versions Table**:
- Displays the versions of `Deno`, `Rustc`, and `SQLite` in a table.
- **Extensions List**:
- Lists all detected extensions.
- **Database Views Content**:
- Automatically identifies and displays the contents of views starting with `surveilr_doctor_` in individual tables.' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.5.5' as title, '# `surveilr` v1.5.5 Release Notes 🎉
---
## 🚀 What''s New
### Virtual Table: `surveilr_function_docs`
**Description**
The `surveilr_function_docs` virtual table offers a structured method to query metadata about `surveilr` SQLite functions registered in the system.
**Columns**
- `name` (`TEXT`): The function''s name.
- `description` (`TEXT`): A concise description of the function''s purpose.
- `parameters` (`JSON`): A JSON object detailing the function''s parameters, including:
- `name`: The name of the parameter.
- `data_type`: The parameter''s expected data type.
- `description`: An explanation of the parameter''s role.
- `return_type` (`TEXT`): The function''s return type.
- `introduced_in_version` (`TEXT`): The version in which the function was first introduced.
**Use Cases**
- Utilized in the Web UI for generating documentation on the functions.
---
### Virtual Table: `surveilr_udi_dal_fs`
**Description**
The `surveilr_udi_dal_fs` virtual table acts as an abstraction layer for interacting with the file system. It enables users to list and examine file metadata in a structured, SQL-friendly manner. This table can list files and their metadata recursively from a specified path.
**Columns**
- `name` (`TEXT`): The file''s name.
- `path` (`TEXT`): The complete file path.
- `last_modified` (`TEXT`): The file''s last modified timestamp, when available.
- `content` (`BLOB`): The content of the file (optional).
- `size` (`INTEGER`): The size of the file in bytes.
- `content_type` (`TEXT`): The MIME type of the file or an inferred content type (e.g., based on the extension).
- `digest` (`TEXT`): The MD5 digest of the file, if available.
- `arg_path` (`TEXT`, hidden): The base path for querying files, specified in the `filter` method.
**Key Features**
- Lists files recursively from a specified directory.
- Facilitates metadata extraction, such as file size, last modified timestamp, and MDhash).
---
### Virtual Table: `surveilr_udi_dal_s3`
**Description**
The `surveilr_udi_dal_s3` virtual table is an abstraction layer that interacts with the S3 bucket in a given region. It allows listing and inspecting file metadata in a structured, SQL-accessible way.
**Columns**
- `name` (`TEXT`): The name of the file.
- `path` (`TEXT`): The full path to the file.
- `last_modified` (`TEXT`): The last modified timestamp of the file, if available.
- `content` (`BLOB`): The file''s content (optional).
- `size` (`INTEGER`): The file size in bytes.
- `content_type` (`TEXT`): The file''s MIME type or inferred content type (e.g., based on the extension).
- `digest` (`TEXT`): The file''s MD5 digest, if available.
- `arg_path` (`TEXT`, hidden): The base path to query files from, specified in the `filter` method.
**Key Features**
- Supports metadata extraction (e.g., file size, last modified timestamp, MD5 hash).
---
## Example Queries
### Querying Function Documentation
```sql
SELECT * FROM surveilr_function_docs WHERE introduced_in_version = ''1.0.0'';
```' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.5.3' as title, '# `surveilr` v1.5.3 Release Notes 🎉
---
## 🚀 What''s New
### 1. **Open Project Data Extension**
`surveilr` now includes additional data from Open Project PLM ingestion. Details such as a work package''s versions and relations are now encapsulated in JSON format in a new `elaboration` column within the `ur_ingest_session_plm_acct_project_issue` table. The JSON structure is as follows, with the possibility for extension:
```json
elaboration: {"issue_id": 78829, "relations": [...], "version": {...}}
```
### 2. **Functions for Extension Verification**
Two new functions have been introduced to verify and ensure the presence of certain intended functions and extensions before their use:
- The `select surveilr_ensure_function(''func'', ''if not found msg'', ''func2'', ''if func2 not found msg'')` function can be used to declaratively specify the required function(s), and will produce an error with guidance on how to obtain the function if it is not found.
- The `select surveilr_ensure_extension(''extn.so'', ''../bin/extn2.so'')` function allows for the declarative indication of necessary extensions, and will dynamically load them if they are not already available.' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.5.2' as title, '# `surveilr` v1.5.2 Release Notes 🎉
---
## 🚀 What''s New
### 1. **`surveilr` SQLite Extensions**
`surveilr` extensions are now statically linked, resolving all extensions and function usage issues. The following extensions are included by default in `surveilr`, with additional ones planned for future releases:
- [`sqlean`](https://github.com/nalgeon/sqlean)
- [`sqlite-url`](https://github.com/asg017/sqlite-url)
- [`sqlite-hashes`](https://github.com/nyurik/sqlite-hashes)
- [`sqlite-lines`](https://github.com/asg017/sqlite-lines)' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.4.3' as title, '# `surveilr` v1.4.2 Release Notes 🎉
---
## 🚀 What''s New
### 1. Utilizing Custom Extensions with `surveilr`
In the previous release, we introduced the feature of automatically loading extensions from the default `sqlpkg` location. However, this posed a security risk, and we have since disabled that feature. To use extensions installed by `sqlpkg`, simply pass `--sqlpkg`, and the default location will be utilized. If you wish to change the directory from which extensions are loaded, use `--sqlpkg /path/to/extensions`, or specify the directory with the new `SURVEILR_SQLPKG` environment variable.' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.4.2' as title, '# `surveilr` v1.4.2 Release Notes 🎉
---
## 🚀 What''s New
### 1. Utilizing Custom Extensions with **`surveilr`**
Loading extensions is now straightforward with the `--sqlite-dyn-extn` flag. As long as your extensions are installed via [`sqlpkg`](https://sqlpkg.org/), `surveilr` will automatically detect the default location of `sqlpkg` and all installed extensions. Simply install the extension using `sqlpkg`. To specify a custom path for `sqlpkg`, use the `--sql-pkg-home` argument with a directory containing the extensions, regardless of depth, and `surveilr` will locate them. Additionally, the `SURVEILR_SQLITE_DYN_EXTNS` environment variable has been introduced to designate an extension path instead of using `--sqlite-dyn-extn`.
**Note**: Using `--sqlite-dyn-extn` won''t prevent `surveilr` from loading extensions from `sqlpkg`''s default directory. To disable loading from `sqlpkg`, use the `--no-sqlpkg` flag.
Here''s a detailed example of using `surveilr shell` and `surveilr orchestrate` with dynamic extensions.
**Using `sqlpkg` defaults**
- Download the [`sqlpkg` CLI](https://github.com/nalgeon/sqlpkg-cli?tab=readme-ov-file#download-and-install-preferred-method).
- Download the [text extension](https://sqlpkg.org/?q=text), which offers various text manipulation functions: `sqlpkg install nalgeon/sqlean`
- Run the following command:
```bash
surveilr shell --cmd "select text_substring(''hello world'', 7, 5) AS result" # surveilr loads all extensions from the .sqlpkg default directory
```
**Including an additional extension with `sqlpkg`**
Combine `--sqlite-dyn-extn` with `surveilr`''s ability to load extensions from `sqlpkg`
- Add the `path` extension to `sqlpkg`''s installed extensions: `sqlpkg install asg017/path`
- Execute:
```bash
surveilr shell --cmd "SELECT
text_substring(''hello world'', 7, 5) AS substring_result,
math_sqrt(9) AS sqrt_result,
path_parts.type,
path_parts.part
FROM
(SELECT * FROM path_parts(''/usr/bin/sqlite3'')) AS path_parts;
" --sqlite-dyn-extn .extensions/math.so
```
**Specify a Custom Directory to Load Extensions From**
A `--sqlpkg-home` flag has been introduced to specify a custom path for extensions. They do not need to be installed by `sqlpkg` to be used. `surveilr` will navigate the specified folder and load all compatible extensions for the operating system—`.so` for Linux, `.dll` for Windows, and `.dylib` for macOS. (If you installed with `sqlpkg`, you don''t need to know the file type).
```bash
surveilr shell --cmd "SELECT text_substring(''hello world'', 7, 5) AS substring_result, math_sqrt(9) AS sqrt_result" --sqlpkg-home ./src/resource_serde/src/functions/extensions/
```
### 2. Upgraded SQLPage
SQLPage has been updated to version 0.31.0, aligning with the latest releases.' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.4.1' as title, '# `surveilr` v1.4.1 Release Notes 🎉
---
## 🚀 Bug Fixes
### 1. **`surveilr` SQLite Extensions**
To temporarily mitigate the issue with `surveilr` intermittently working due to the dynamic loading of extensions, `surveilr` no longer supports dynamic loading by default. It is now supported only upon request by using the `--sqlite-dyn-extn` flag. This flag is a multiple option that specifies the path to an extension to be loaded into `surveilr`. To obtain the dynamic versions (`.dll`, `.so`, or `.dylib`), you can use [`sqlpkg`](https://sqlpkg.org/) to install the necessary extension.
For instance, to utilize the `text` functions:
- Install the extension with [`sqlpkg`](https://sqlpkg.org/?q=text): `sqlpkg install nalgeon/text`
- Then execute it:
```bash
surveilr shell --cmd "select text_substring(''hello world'', 7, 5);" --sqlite-dyn-extn ./text.so
```' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.3.1' as title, '# `surveilr` v1.3.1 Release Notes 🎉
---
## 🚀 Bug Fixes
### 1. **`surveilr` SQLite Extensions**
This release fixes the `glibc` compatibility error that occured with `surveilr` while registering function extensions.' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.3.0' as title, '# `surveilr` Release Announcement: Now Fully Compatible Across All Distros 🎉
We are thrilled to announce that `surveilr` is now fully compatible with all major Linux distributions, resolving the longstanding issue related to OpenSSL compatibility! 🚀
## What''s New?
- **Universal Compatibility**: `surveilr` now works seamlessly on **Ubuntu**, **Debian**, **Kali Linux**, and other Linux distributions, across various versions and architectures. Whether you''re using Ubuntu 18.04, Debian 10, or the latest Kali Linux, `surveilr` is ready to perform without any hiccups.
- **Resolved OpenSSL Bug**: We’ve fixed the recurring OpenSSL-related issue that caused headaches for users on older and varied systems. With this update, you no longer need to worry about OpenSSL version mismatches or missing libraries.
' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.2.0' as title, '# `surveilr` v1.2.0 Release Notes 🎉
## What''s New?
This update introduces two major additions that streamline file system integration and ingestion session management.
---
### New Features
#### 1. `surveilr_ingest_session_id` Scalar Function
The `surveilr_ingest_session_id` function is now available, offering robust management of ingestion sessions. This function ensures efficient session handling by:
- Reusing existing session IDs for devices with active sessions.
- Creating new ingestion sessions when none exist.
- Associating sessions with metadata for improved traceability.
#### 2. `surveilr_udi_dal_fs` Virtual Table Function
The `surveilr_udi_dal_fs` virtual table function provides seamless access to file system resources directly within your SQL queries. With this feature, you can:
- Query file metadata, such as names, paths, sizes, and timestamps.
- Retrieve file content and calculate digests for integrity checks.
- Traverse directories recursively to handle large and nested file systems effortlessly.
' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.1.0' as title, '# `surveilr` v1.1.0 Release Notes 🎉
## 🚀 New Features
### 1. **Integrated Documentation in Web UI**
This release introduces a comprehensive update to the RSSD Web UI, allowing users to access and view all `surveilr`-related SQLite functions, release notes, and internal documentation directly within the interface. This feature enhances user experience by providing integrated, easily navigable documentation without the need to leave the web environment, ensuring that all necessary information is readily available for efficient reference and usage.
### 2. **`uniform_resource` Graph Infrastructure**
The foundational framework for tracking `uniform_resource` content using graph representations has been laid out in this release. This infrastructure allows users to visualize `uniform_resource` data as connected graphs in addition to the traditional relational database structure. To facilitate this, three dedicated views—`imap_graph`, `plm_graph`, and `filesystem_graph`—have been created. These views provide a structured way to observe and interact with data from different ingestion sources:
- **`imap_graph`**: Represents the graphical relationships for content ingested through IMAP processes, allowing for a visual mapping of email and folder structures.
- **`plm_graph`**: Visualizes content from PLM (Product Lifecycle Management) ingestion, showcasing project and issue-based connections.
- **`filesystem_graph`**: Illustrates file ingestion paths and hierarchies, enabling users to track and manage file-based data more intuitively.
This release marks an important step towards enhancing data tracking capabilities, providing a dual approach of relational and graphical views for better data insights and management.
' as description_md;
SELECT 'foldable' as component;
SELECT 'v1.0.0' as title, '# `surveilr` v1.0.0 Release Notes 🎉
We’re thrilled to announce the release of `surveilr` v1.0, a significant milestone in our journey to deliver powerful tools for continuous security, quality and compliance evidence workflows. This release introduces a streamlined migration system and a seamless, user-friendly experience for accessing the `surveilr` Web UI.
---
## 🚀 New Features
### 1. **Database Migration System**
This release introduces a comprehensive database migration feature that allows smooth and controlled updates to the RSSD structure. Our migration system includes:
- **Structured Notebooks and Cells**: A structured system organizes SQL migration scripts into modular code notebooks, making migration scripts easy to track, audit, and execute as needed.
- **Idempotent vs. Non-Idempotent Handling**: Ensures each migration runs in an optimal and secure manner by tracking cell execution history, allowing for re-execution where safe.
- **Automated State Tracking**: All state changes are logged for complete auditing, showing timestamps, transition details, and the results of each migration step.
- **Transactional Execution**: All migrations run within a single transaction block for seamless rollbacks and data consistency.
- **Dynamic Migration Scripts**: Cells marked for migration are dynamically added to the migration script, reducing manual effort and risk of errors.
This system ensures safe, controlled migration of database changes, enhancing reliability and traceability for every update.
### 2. **Enhanced Default Command and Web UI Launch**
The surveilr executable now starts the Web UI as the default command when no specific CLI commands are passed. This feature aims to enhance accessibility and ease of use for new users and teams. Here’s what happens by default:
- **Automatic Web UI Startup**: By default, running surveilr without additional commands launches the surveilr Web UI.
- **Auto-Browser Launch**: Opens the default browser on the workstation, pointing to the Web UI’s URL and port, providing a user-friendly experience right from the first run.' as description_md;
|
2025-04-11 07:54:36 |
| docs/functions.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' as component;
WITH RECURSIVE breadcrumbs AS (
SELECT
COALESCE(abbreviated_caption, caption) AS title,
COALESCE(url, path) AS link,
parent_path, 0 AS level,
namespace
FROM sqlpage_aide_navigation
WHERE namespace = 'prime' AND path='docs/functions.sql'
UNION ALL
SELECT
COALESCE(nav.abbreviated_caption, nav.caption) AS title,
COALESCE(nav.url, nav.path) AS link,
nav.parent_path, b.level + 1, nav.namespace
FROM sqlpage_aide_navigation nav
INNER JOIN breadcrumbs b ON nav.namespace = b.namespace AND nav.path = b.parent_path
)
SELECT title ,
sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/'||link as link
FROM breadcrumbs ORDER BY level DESC;
-- not including page title from sqlpage_aide_navigation
-- To display title
SELECT
'text' AS component,
'Surveilr SQLite Functions' AS title;
SELECT
'text' AS component,
'Below is a comprehensive list and description of all Surveilr SQLite functions. Each function includes details about its parameters, return type, and version introduced.'
AS contents_md;
SELECT
'list' AS component,
'Surveilr Functions' AS title;
SELECT name AS title,
NULL AS icon, -- Add an icon field if applicable
'functions-inner.sql?function=' || name || '#function' AS link,
$function = name AS active
FROM surveilr_function_doc
ORDER BY name;
|
2025-04-11 07:54:36 |
| docs/functions-inner.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
-- not including breadcrumbs from sqlpage_aide_navigation
-- not including page title from sqlpage_aide_navigation
select
'breadcrumb' as component;
select
'Home' as title,
sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' as link;
select
'Docs' as title,
sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/docs/index.sql' as link;
select
'SQL Functions' as title,
sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/docs/functions.sql' as link;
select
$function as title,
sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/docs/functions-inner.sql?function=' || $function AS link;
SELECT
'text' AS component,
'' || name || '()' AS title, 'function' AS id
FROM surveilr_function_doc WHERE name = $function;
SELECT
'text' AS component,
description AS contents_md
FROM surveilr_function_doc WHERE name = $function;
SELECT
'text' AS component,
'Introduced in version ' || version || '.' AS contents
FROM surveilr_function_doc WHERE name = $function;
SELECT
'title' AS component,
3 AS level,
'Parameters' AS contents
WHERE $function IS NOT NULL;
SELECT
'card' AS component,
3 AS columns
WHERE $function IS NOT NULL;
SELECT
json_each.value ->> '$.name' AS title,
json_each.value ->> '$.description' AS description,
json_each.value ->> '$.data_type' AS footer,
'azure' AS color
FROM surveilr_function_doc, json_each(surveilr_function_doc.parameters)
WHERE name = $function;
-- Navigation Buttons
SELECT 'button' AS component, 'sm' AS size, 'pill' AS shape;
SELECT name AS title,
NULL AS icon, -- Add an icon field if needed
sqlpage.link('functions-inner.sql', json_object('function', name)) AS link
FROM surveilr_function_doc
ORDER BY name;
|
2025-04-11 07:54:36 |
| console/content/table/sqlean_define.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'sqlean_define table' as title, '#' AS link;
SELECT 'title' AS component, 'sqlean_define (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM sqlean_define);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[sqlean_define (table) Schema](console/info-schema/table.sql?name=sqlean_define&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM sqlean_define
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/assurance_schema.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'assurance_schema table' as title, '#' AS link;
SELECT 'title' AS component, 'assurance_schema (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM assurance_schema);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[assurance_schema (table) Schema](console/info-schema/table.sql?name=assurance_schema&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM assurance_schema
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/code_notebook_kernel.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'code_notebook_kernel table' as title, '#' AS link;
SELECT 'title' AS component, 'code_notebook_kernel (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM code_notebook_kernel);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[code_notebook_kernel (table) Schema](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM code_notebook_kernel
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/code_notebook_cell.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'code_notebook_cell table' as title, '#' AS link;
SELECT 'title' AS component, 'code_notebook_cell (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM code_notebook_cell);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[code_notebook_cell (table) Schema](console/info-schema/table.sql?name=code_notebook_cell&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM code_notebook_cell
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/code_notebook_state.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'code_notebook_state table' as title, '#' AS link;
SELECT 'title' AS component, 'code_notebook_state (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM code_notebook_state);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[code_notebook_state (table) Schema](console/info-schema/table.sql?name=code_notebook_state&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM code_notebook_state
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/surveilr_function_doc.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'surveilr_function_doc table' as title, '#' AS link;
SELECT 'title' AS component, 'surveilr_function_doc (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM surveilr_function_doc);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[surveilr_function_doc (table) Schema](console/info-schema/table.sql?name=surveilr_function_doc&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM surveilr_function_doc
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/sqlpage_files.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'sqlpage_files table' as title, '#' AS link;
SELECT 'title' AS component, 'sqlpage_files (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM sqlpage_files);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[sqlpage_files (table) Schema](console/info-schema/table.sql?name=sqlpage_files&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM sqlpage_files
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/surveilr_table_size.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'surveilr_table_size table' as title, '#' AS link;
SELECT 'title' AS component, 'surveilr_table_size (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM surveilr_table_size);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[surveilr_table_size (table) Schema](console/info-schema/table.sql?name=surveilr_table_size&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM surveilr_table_size
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/sqlpage_aide_navigation.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'sqlpage_aide_navigation table' as title, '#' AS link;
SELECT 'title' AS component, 'sqlpage_aide_navigation (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM sqlpage_aide_navigation);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[sqlpage_aide_navigation (table) Schema](console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM sqlpage_aide_navigation
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/party_type.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'party_type table' as title, '#' AS link;
SELECT 'title' AS component, 'party_type (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM party_type);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[party_type (table) Schema](console/info-schema/table.sql?name=party_type&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM party_type
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/party.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'party table' as title, '#' AS link;
SELECT 'title' AS component, 'party (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM party);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[party (table) Schema](console/info-schema/table.sql?name=party&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM party
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/party_relation_type.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'party_relation_type table' as title, '#' AS link;
SELECT 'title' AS component, 'party_relation_type (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM party_relation_type);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[party_relation_type (table) Schema](console/info-schema/table.sql?name=party_relation_type&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM party_relation_type
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/party_relation.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'party_relation table' as title, '#' AS link;
SELECT 'title' AS component, 'party_relation (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM party_relation);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[party_relation (table) Schema](console/info-schema/table.sql?name=party_relation&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM party_relation
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/gender_type.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'gender_type table' as title, '#' AS link;
SELECT 'title' AS component, 'gender_type (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM gender_type);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[gender_type (table) Schema](console/info-schema/table.sql?name=gender_type&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM gender_type
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/sex_type.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'sex_type table' as title, '#' AS link;
SELECT 'title' AS component, 'sex_type (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM sex_type);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[sex_type (table) Schema](console/info-schema/table.sql?name=sex_type&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM sex_type
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/person_type.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'person_type table' as title, '#' AS link;
SELECT 'title' AS component, 'person_type (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM person_type);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[person_type (table) Schema](console/info-schema/table.sql?name=person_type&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM person_type
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/person.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'person table' as title, '#' AS link;
SELECT 'title' AS component, 'person (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM person);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[person (table) Schema](console/info-schema/table.sql?name=person&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM person
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/organization.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'organization table' as title, '#' AS link;
SELECT 'title' AS component, 'organization (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM organization);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[organization (table) Schema](console/info-schema/table.sql?name=organization&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM organization
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/organization_role_type.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'organization_role_type table' as title, '#' AS link;
SELECT 'title' AS component, 'organization_role_type (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM organization_role_type);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[organization_role_type (table) Schema](console/info-schema/table.sql?name=organization_role_type&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM organization_role_type
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/organization_role.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'organization_role table' as title, '#' AS link;
SELECT 'title' AS component, 'organization_role (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM organization_role);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[organization_role (table) Schema](console/info-schema/table.sql?name=organization_role&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM organization_role
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/device.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'device table' as title, '#' AS link;
SELECT 'title' AS component, 'device (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM device);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[device (table) Schema](console/info-schema/table.sql?name=device&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM device
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/device_party_relationship.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'device_party_relationship table' as title, '#' AS link;
SELECT 'title' AS component, 'device_party_relationship (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM device_party_relationship);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[device_party_relationship (table) Schema](console/info-schema/table.sql?name=device_party_relationship&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM device_party_relationship
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/behavior.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'behavior table' as title, '#' AS link;
SELECT 'title' AS component, 'behavior (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM behavior);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[behavior (table) Schema](console/info-schema/table.sql?name=behavior&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM behavior
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/ur_ingest_resource_path_match_rule.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_resource_path_match_rule table' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_resource_path_match_rule (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_resource_path_match_rule);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[ur_ingest_resource_path_match_rule (table) Schema](console/info-schema/table.sql?name=ur_ingest_resource_path_match_rule&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_resource_path_match_rule
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/ur_ingest_resource_path_rewrite_rule.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_resource_path_rewrite_rule table' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_resource_path_rewrite_rule (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_resource_path_rewrite_rule);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[ur_ingest_resource_path_rewrite_rule (table) Schema](console/info-schema/table.sql?name=ur_ingest_resource_path_rewrite_rule&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_resource_path_rewrite_rule
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/ur_ingest_session.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session table' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[ur_ingest_session (table) Schema](console/info-schema/table.sql?name=ur_ingest_session&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/ur_ingest_session_fs_path.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_fs_path table' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_fs_path (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_fs_path);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[ur_ingest_session_fs_path (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_fs_path&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_fs_path
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/uniform_resource.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'uniform_resource table' as title, '#' AS link;
SELECT 'title' AS component, 'uniform_resource (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM uniform_resource);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[uniform_resource (table) Schema](console/info-schema/table.sql?name=uniform_resource&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM uniform_resource
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/uniform_resource_transform.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'uniform_resource_transform table' as title, '#' AS link;
SELECT 'title' AS component, 'uniform_resource_transform (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM uniform_resource_transform);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[uniform_resource_transform (table) Schema](console/info-schema/table.sql?name=uniform_resource_transform&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM uniform_resource_transform
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/ur_ingest_session_fs_path_entry.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_fs_path_entry table' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_fs_path_entry (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_fs_path_entry);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[ur_ingest_session_fs_path_entry (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_fs_path_entry&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_fs_path_entry
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/ur_ingest_session_task.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_task table' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_task (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_task);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[ur_ingest_session_task (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_task&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_task
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/ur_ingest_session_imap_account.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_imap_account table' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_imap_account (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_imap_account);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[ur_ingest_session_imap_account (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_imap_account&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_imap_account
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/ur_ingest_session_imap_acct_folder.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_imap_acct_folder table' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_imap_acct_folder (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_imap_acct_folder);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[ur_ingest_session_imap_acct_folder (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_imap_acct_folder&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_imap_acct_folder
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/ur_ingest_session_imap_acct_folder_message.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_imap_acct_folder_message table' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_imap_acct_folder_message (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_imap_acct_folder_message);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[ur_ingest_session_imap_acct_folder_message (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_imap_acct_folder_message&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_imap_acct_folder_message
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/ur_ingest_session_plm_account.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_plm_account table' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_plm_account (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_plm_account);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[ur_ingest_session_plm_account (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_plm_account&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_plm_account
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/ur_ingest_session_plm_acct_project.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_plm_acct_project table' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_plm_acct_project (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_plm_acct_project);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[ur_ingest_session_plm_acct_project (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_plm_acct_project&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_plm_acct_project
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/ur_ingest_session_plm_acct_project_issue.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_plm_acct_project_issue table' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_plm_acct_project_issue (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_plm_acct_project_issue);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[ur_ingest_session_plm_acct_project_issue (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_plm_acct_project_issue&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_plm_acct_project_issue
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/ur_ingest_session_plm_acct_label.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_plm_acct_label table' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_plm_acct_label (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_plm_acct_label);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[ur_ingest_session_plm_acct_label (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_plm_acct_label&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_plm_acct_label
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/ur_ingest_session_plm_milestone.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_plm_milestone table' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_plm_milestone (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_plm_milestone);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[ur_ingest_session_plm_milestone (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_plm_milestone&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_plm_milestone
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/ur_ingest_session_plm_acct_relationship.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_plm_acct_relationship table' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_plm_acct_relationship (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_plm_acct_relationship);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[ur_ingest_session_plm_acct_relationship (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_plm_acct_relationship&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_plm_acct_relationship
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/ur_ingest_session_plm_user.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_plm_user table' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_plm_user (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_plm_user);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[ur_ingest_session_plm_user (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_plm_user&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_plm_user
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/ur_ingest_session_plm_comment.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_plm_comment table' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_plm_comment (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_plm_comment);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[ur_ingest_session_plm_comment (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_plm_comment&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_plm_comment
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/ur_ingest_session_plm_reaction.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_plm_reaction table' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_plm_reaction (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_plm_reaction);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[ur_ingest_session_plm_reaction (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_plm_reaction&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_plm_reaction
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/ur_ingest_session_plm_issue_reaction.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_plm_issue_reaction table' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_plm_issue_reaction (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_plm_issue_reaction);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[ur_ingest_session_plm_issue_reaction (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_plm_issue_reaction&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_plm_issue_reaction
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/ur_ingest_session_plm_issue_type.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_plm_issue_type table' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_plm_issue_type (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_plm_issue_type);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[ur_ingest_session_plm_issue_type (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_plm_issue_type&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_plm_issue_type
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |
| console/content/table/ur_ingest_session_attachment.auto.sql |
SELECT 'dynamic' AS component, sqlpage.run_sql('shell/shell.sql') AS properties;
SELECT 'breadcrumb' AS component;
SELECT 'Home' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/' AS link;
SELECT 'Console' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console' AS link;
SELECT 'Content' as title,sqlpage.environment_variable('SQLPAGE_SITE_PREFIX') || '/console/content' AS link;
SELECT 'ur_ingest_session_attachment table' as title, '#' AS link;
SELECT 'title' AS component, 'ur_ingest_session_attachment (table) Content' as contents;
SET total_rows = (SELECT COUNT(*) FROM ur_ingest_session_attachment);
SET limit = COALESCE($limit, 50);
SET offset = COALESCE($offset, 0);
SET total_pages = ($total_rows + $limit - 1) / $limit;
SET current_page = ($offset / $limit) + 1;
SELECT 'text' AS component, '[ur_ingest_session_attachment (table) Schema](console/info-schema/table.sql?name=ur_ingest_session_attachment&stats=yes)' AS contents_md
SELECT 'text' AS component,
'- Start Row: ' || $offset || '
' ||
'- Rows per Page: ' || $limit || '
' ||
'- Total Rows: ' || $total_rows || '
' ||
'- Current Page: ' || $current_page || '
' ||
'- Total Pages: ' || $total_pages as contents_md
WHERE $stats IS NOT NULL;
-- Display uniform_resource table with pagination
SELECT 'table' AS component,
TRUE AS sort,
TRUE AS search,
TRUE AS hover,
TRUE AS striped_rows,
TRUE AS small;
SELECT * FROM ur_ingest_session_attachment
LIMIT $limit
OFFSET $offset;
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE '' END) || ' ' ||
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
(SELECT CASE WHEN $current_page < $total_pages THEN '[Next](?limit=' || $limit || '&offset=' || ($offset + $limit) || ')' ELSE '' END)
AS contents_md; |
2025-04-11 07:57:31 |