AI Data Management Page
Common data management pages typically provide CRUD (Create, Read, Update, Delete) functionality, including filter conditions, sorting, pagination, toolbar buttons, action column buttons, and other common interface elements and features. JitAI directly provides an AI data management page to help developers quickly complete data management functionality development, and supports users to perform data management tasks using AI.
Creating AI Data Management Page
Enter the developer portal and create it by following these steps:
Click + → UI Pages → AI Data Management Page, open the page information form, and click the Confirm button after filling out the form to create the page.
After the page is created, it will automatically enter the visual editor.
Developers typically don't need to perform any additional configuration, and the page can be used directly. Of course, developers can also modify the configuration according to actual needs.
Manageable Data Scope
In actual business scenarios, it may be necessary to limit the data that can be queried and displayed in the page table. For example, only displaying data from the past year. By setting data filter conditions, data security can be effectively ensured, user efficiency can be improved, and irrelevant data interference with business operations can be avoided.
Limit the data queried by the page table through default filter conditions. JitAI's Filter supports various filter condition settings for different types of fields such as text, numbers, date and time, which can meet almost all filtering requirements.
Developers can configure Data Filtering in the page editor, and click the plus button on the right side of each filter condition to add multiple conditions.
In addition to configuring default filter conditions in the page, developers can also perform fine-grained control over data query and operation permissions for different user roles within the application. This is a more advanced configuration method, and developers can refer to the role permission documentation.
The configuration in role permissions will be combined with the conditions configured in the page and take effect, which is an AND relationship.
Configure Default Data Sort Rules
The display order of data tables often affects user work efficiency. For example, sales personnel want to see the latest orders first, while financial personnel may pay more attention to transactions with larger amounts. Reasonably setting default data sort rules allows users to see the most important or relevant data at first glance when entering the page, improving data search and processing efficiency.
Developers can configure Data Sorting in the page editor, and click the plus button on the right side of each sort condition to add multiple sort conditions.
Specify Field Columns Displayed in Table
In actual business scenarios, it may be necessary to hide some fields. For example, users don't need to see fields like Creation Time and Update Time. By hiding fields, irrelevant data interference to users can be reduced, improving page cleanliness and usage efficiency.
Developers can configure this in Display in Table in the page editor. Check to display the corresponding field, uncheck to hide the corresponding field.
Configure Fields Supporting Conditional Filtering
Not all fields need to support conditional filtering. For example, remark fields typically don't need to support conditional filtering.
Developers can configure this in Support Filtering in the page editor. Uncheck fields that don't need to participate in conditional filtering, check to support conditional filtering.
Configure Fields Allowed for Viewing and Editing in Form
When users add or edit data, primary key IDs typically don't need to be visible to users in the form, and creation time doesn't need to be edited by users in the form, but is automatically generated by the system. By analogy, JitAI supports configuring viewing and editing permissions for all fields in the form.
Developers can configure this in Allow Viewing in Form/Allow Editing in Form in the page editor. Uncheck fields that don't need to be visible or editable by users in the form, check to allow viewing and editing.
Not allowing viewing and editing in the form does not take effect for Batch Edit Form.
Configure Fields Displayed in Batch Edit Form
Batch editing is typically used to select multiple data records in the table and then perform batch modifications on these data. However, not all fields are suitable for batch modification. For example, highly distinctive fields such as phone numbers and email addresses are typically not suitable for batch modification.
Developers can configure this in Display in Batch Edit Form in the page editor. Check to display the corresponding field in the batch edit form, uncheck to not display the corresponding field. Additionally, the batch form requires at least one display field to be configured.
AI Data Management Assistant
Enable AI Data Management Assistant
The AI data management page has a built-in universal AI Data Management Assistant. Users can use this assistant to complete CRUD operations on data through natural language dialogue. For example, if a user inputs: "Enter 5 random test data records", the AI assistant will automatically enter 5 data records and refresh the table.
This assistant is not enabled by default in the page and needs to be manually enabled. The enabling method is as follows:
Switch to AI Assistant Configuration at the top of the visual editor, then turn on the Use AI Data Management Assistant switch.
Configure Large Language Model
The AI data management assistant needs to access the system database and call functions on the page to draw charts during runtime. We need to configure a Large Language Model that supports tool calling for it. We recommend using qwen-max-latest from Alibaba Cloud Bailian platform. Apply for API Key
Assistant Advanced Configuration
- Supports custom Welcome Message and Opening
- Supports custom Output Process Log, which outputs brief process logs by default.
For more information about AI assistants, please read the AI Assistant related documentation.
Runtime Effect
Click the 
button in the top right corner of the visual editor to see the effect!
When users access the page, they will see a fully functional data management interface, including data table, filter conditions, pagination, add/batch modify/batch delete/import in the toolbar, edit/delete in the action column, and clicking column headers for sorting. After enabling the AI data management assistant, an AI dialog box will be displayed on the right side of the page, allowing users to interact with the assistant through this dialog to operate data.
Convert to Regular Page for Modification
The AI data management page is a built-in page type provided by JitAI out of the box, which developers can quickly create and use. When developers want to make more refined custom modifications based on the default implementation, they can convert the page to a regular page for unlimited modification.
Developers can click the 
button in the top right corner of the page editor to convert the page to a regular page. For regular page development methods, refer to Component-based Page Development.
After converting to a regular page, it cannot be restored to the original AI Data Management Page type.
Quick Create
In addition to creating in the developer portal, you can also quickly create in the regular portal. The creation method is as follows:
Click Create New → AI Data Management Functions.This operation will create a new AI data Management page and simultaneously create a menu in the portal and bind it to the newly added page.
You need to be granted quick create permissions to see the quick create entry.