skills.rest
caobingsheng
caobingshengCOMMUNITY
Explore all skills by this author →
GitHub

vk-basedao-gettabledata

Retrieve paginated multi-table data with vk.baseDao.getTableData.

1|Updated Mar 26, 2026
Search Tags:#database#aggregation#pagination#joins#data-query#getTableData#vk-baseDao
One-click install
npx skills add https://github.com/caobingsheng/skills --skill vk-basedao-gettabledata
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: vk-basedao-gettabledata
Source: https://github.com/caobingsheng/skills/tree/main/skills/vk-basedao-gettabledata
Command: npx skills add https://github.com/caobingsheng/skills --skill vk-basedao-gettabledata

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

vk.baseDao.getTableData provides a unified, powerful interface for querying data with advanced pagination, filtering, sorting, multi-table joins, and aggregation, reducing boilerplate and improving performance insights.

Core Features & Use Cases

  • Flexible pagination, filtering, sorting, and join capabilities via data, whereJson, and foreignDB.
  • Grouping and aggregation with groupJson to produce summarized results with performance considerations.
  • Ideal for admin dashboards using vk-data-table, cloud functions with complex data operations, and reporting workflows requiring structured outputs such as total, hasMore, and pagination.

Quick Start

Invoke vk.baseDao.getTableData with your target dbName and a data payload to fetch the first page of results.

Frequently Asked Questions about vk-basedao-gettabledata

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I perform multi-table joins with pagination in cloud functions?▼

Multi-table joins with pagination are handled by invoking vk.baseDao.getTableData with main and foreign table parameters, returning standardized rows, total, hasMore, and pagination metadata for cloud functions.

What is the best way to group and aggregate table data for admin dashboards?▼

Grouping and aggregating table data for admin dashboards uses the groupJson parameter to produce summarized results, reducing boilerplate while maintaining performance insights for reporting workflows.

Can I apply flexible filtering and sorting when querying data with vk.baseDao?▼

Yes, flexible filtering and sorting are configured through the data and whereJson parameters, enabling complex data retrieval operations with structured outputs like total counts and pagination metadata.

Does vk.baseDao.getTableData support foreign table parameters for complex queries?▼

Yes, it supports foreignDB parameters to execute multi-table queries, allowing you to retrieve paginated data across joined tables with flexible filtering, sorting, and grouping options.

How do I retrieve the first page of results from a database using getTableData?▼

To retrieve the first page of results, invoke vk.baseDao.getTableData with your target dbName and a data payload, which returns structured rows alongside hasMore and pagination metadata.

What standardized pagination metadata does vk.baseDao.getTableData return?▼

It returns a standardized result including rows, total, hasMore, and pagination metadata, providing performance-aware data access for admin dashboards and cloud function reporting tasks.

Related Skills

Explore More Data & Analytics Skills→
anukkrit149anukkrit149

query-writing

Translate database questions into executable SQL queries with formatted results.

Community
Intermediate
jiaiyanjiaiyan
21

el-infinite-scroll

Load more data automatically when users scroll to the bottom of Vue lists.

Community
Intermediate
caobingshengcaobingsheng
1

vk-data-table

Render and manipulate Vue data grids with JSON-configured columns and slots.

Community
Intermediate
Impertio-StudioImpertio-Studio
163

frappe-core-database

Guide Frappe database operations using ORM, Query Builder, and parameterized SQL.

Official
Advanced