Custom Sorting Rules for Multi-Tenant Database Records
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Multi-tenant cloud-based database systems have inflexible search features and sorting functionalities, limiting developers' and users' ability to customize sorting rules, which can result in an unsatisfactory user experience and hinder productivity.
Innovation Solution
Implementing user-configurable custom sorting rules that allow users to select and configure specific fields and sort orders for records, enabling customizable sorting on user-, organization-, or tenant-specific fields and records, with the ability to define and apply custom sorting rules through a graphical user interface.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If predefined sorting rules are used in multi-tenant cloud-based database systems, then the system maintains simplicity and ease of operation, but the adaptability and customization capability are limited
Solution Approach 1:
The system allows dynamic configuration of sorting rules where users can define custom sort orders, selected fields, and sort directions. The sorting mechanism transitions from static predefined rules to dynamic user-defined rules, enabling adaptability without requiring system redesign. Users can configure sorting parameters through intuitive interfaces, and the system executes these custom sorts efficiently.
2Adaptability or versatility
If custom sorting rules are implemented, then the adaptability and user experience are improved, but the ease of operation may be reduced due to increased configuration requirements
Solution Approach 1:
The system enables users to self-configure sorting rules through intuitive graphical interfaces without requiring technical expertise. Users can select fields, define sort orders, and set directions through user-friendly controls, and the system automatically generates and executes the appropriate sort operations. This self-service capability maintains ease of operation while providing extensive customization flexibility.
Data Source
AI summary
Devices, systems and methods are provided for ordering records at a database system. An instance of a virtual application presented at a client device coupled to the database system over a network provides a graphical user interface (GUI) element populated using a sorting rule table that maintains user-configured sorting rule criteria for each custom sorting rule of a plurality of different sorting rules configured at the database system. In response to the user selection of a first custom sorting rule via the GUI element, the virtual application provides graphical indication of an ordered listing of the records at the database system ordered by a user-configured field of the records associated with the first custom sorting rule in accordance with a user-configured sort order associated with the first custom sorting rule using a search index built in accordance with the user-configured sorting rule criteria for the custom sorting rules.