一种通过用户配置生成子查询的方法与装置

Method and device for generating sub-queries through user configuration

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.
本发明公开了一种通过用户配置生成子查询的方法,所述的通过用户配置生成子查询的方法,该方法通过界面配置可生成对数据库表进行按条件分列处理的视图或子查询,生成的视图或子查询可以作为报表开发步骤“选择报表所需数据库表”时的特殊待选数据库表,故该方法可以作为报表开发系统的前置处理装置,避免了开发人员去处理复杂的查询和数据整理,易于修改和维护。

Claims

Description

Topics

Download Full PDF Version (Non-Commercial Use)

Patent Citations (0)

    Publication numberPublication dateAssigneeTitle

NO-Patent Citations (0)

    Title

Cited By (0)

    Publication numberPublication dateAssigneeTitle