Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and device for generating sub-queries through user configuration

A user configuration and sub-query technology, applied in special data processing applications, instruments, electrical digital data processing, etc., can solve the problems of increasing the complexity of report development and achieve the effect of easy modification and maintenance

Active Publication Date: 2014-03-19
YONYOU NETWORK TECH
View PDF5 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When the report requires a certain column of data information in the database table to be displayed according to conditions, developers need to complete the query and process data in the background development, which increases the complexity of report development

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for generating sub-queries through user configuration
  • Method and device for generating sub-queries through user configuration
  • Method and device for generating sub-queries through user configuration

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0066] In order to further explain the technical means and effects of the present invention to achieve the intended purpose of the invention, a configurable method for parsing multi-value matching fields proposed according to the present invention will be specifically implemented below in conjunction with the accompanying drawings and preferred embodiments Mode, feature and effect thereof are as follows in detail. In the following description, different "one embodiment" or "embodiment" do not necessarily refer to the same embodiment. Furthermore, the particular features, structures, or characteristics of one or more embodiments may be combined in any suitable manner.

[0067] figure 1 Shows a flow chart of generating a report according to an embodiment of the present invention, and describes the process in conjunction with the project example "loan details" report, which is used to use the database tables "loan contract table", "contract execution The information of "Contrac...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a method for generating sub-queries through user configuration. According to the method for generating the sub-queries through the user configuration, views or the sub-queries for list processing of database tables according to conditions can be generated through interface configuration, and the generated views or sub-queries can be used as special to-be-selected database tables of report development steps during selecting database tables required by reports, so that the method can be used as a preprocessing device of a report development system, developers are not required to process complex queries and cleanse data, and the modification and the maintenance are facilitated.

Description

technical field [0001] The invention relates to a method for generating a sub-query through user configuration. When the development of a report needs to display data in a certain column of a database table according to conditions, the method can provide a view or a sub-query in the middle layer. Background technique [0002] In the prior art, by selecting a database table required for a report, and setting connection relationships and other filtering conditions of the database table, fields are selected for displaying the report. When a report requires conditional display of a column of data information in a database table, developers are required to complete the query and process data in the background, which increases the complexity of report development. Contents of the invention [0003] In order to overcome the above-mentioned deficiencies in the prior art, the present invention proposes a method for generating sub-queries through user configuration. When a certain c...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30G06F17/24
CPCG06F16/2456G06F16/2457G06F16/248
Inventor 高铁牛
Owner YONYOU NETWORK TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com