JP2015053088A - Table data retrieval apparatus, table data retrieval method and table data retrieval program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a table data retrieval apparatus, a table data retrieval method and a table data retrieval program which can achieve data retrieval from a plurality of master tables in a business application while reducing development costs.SOLUTION: When receiving a retrieval instruction of a real data concerned with a specification item specified on a screen displayed in accordance with the operation of a business application, a retrieval screen for performing specification of a retrieval condition and display of a retrieved result is displayed on a monitor, and when the retrieval condition is specified, the real data matched with the retrieval condition is retrieved from a master table corresponding to the specification item and a retrieval result of the retrieved real data is displayed on the retrieval screen.

Description

  The present invention searches a master table in a database for actual data related to a specified item specified on a screen displayed in accordance with the operation of a business application (for example, sales management system, accounting business system, payroll business system, etc.). The present invention relates to a table data search device, a table data search method, and a table data search program.

  Conventionally, when retrieving data from a plurality of master tables in a business application such as a sales management system, an accounting business system, or a payroll business system, a search program has been developed for each master table. Patent Document 1 discloses a technique related to a search system that searches a database for items designated by a client and notifies display data to the client based on a search result on the client side.

Japanese Patent Laid-Open No. 10-247202

  However, conventionally, in order to realize data search from a plurality of master tables in a business application, one search program has been developed for one master table to be searched, so there is still room for reducing development costs. There was a problem that it was.

  The present invention has been made in view of the above, and is a table data search apparatus, a table data search method, and a table capable of realizing data search from a plurality of master tables in a business application while reducing development costs. The object is to provide a data search program.

  In order to solve the above-described problems and achieve the object, a table data search device according to the present invention is connected to a database storing a plurality of master tables holding actual data so as to be communicable, and a control unit And a display unit, and a table data search device that searches the actual data related to a specified item specified on a screen including at least one item displayed in accordance with an operation of a business application, wherein the control unit includes: Upon receiving a search instruction for the actual data related to the specified item specified on the screen displayed in accordance with the operation of the business application, a search screen for specifying a search condition and displaying a search result is displayed on the display unit. When the search execution means to be displayed and the search condition are designated, the search condition is retrieved from the master table corresponding to the designated item. Search means for searching for the relevant actual data, and the display execution means displays the search result of the actual data searched by the search means on the search screen, or for the operation of the business application. Upon receiving a search instruction for the actual data related to the specified item specified on the displayed screen, including a search condition, the master table corresponding to the specified item is adapted to the search condition. Search means for searching for actual data, and display execution means for displaying a search screen on which the search result of the actual data searched by the search means is displayed on the display unit.

  The table data search device according to the present invention is the table data search device described above, wherein the display execution unit is configured to store the entire search screen based on preset size information related to the size of the entire search screen. The size is judged and the search screen is displayed.

  The present invention also relates to a table data search method. The table data search method according to the present invention is connected to a database storing a plurality of master tables holding actual data so as to be communicable with a control unit. A table data search method for searching for actual data related to a specified item specified on a screen including at least one item displayed in accordance with an operation of a business application, executed by an information processing apparatus including a display unit. In response to a search instruction for the actual data related to the specified item specified on the screen displayed in accordance with the operation of the business application executed by the control unit, the search condition is specified and the search result is displayed. A screen display execution step for displaying a search screen for performing on the display unit, and when the search condition is specified, A search step for searching the actual data that matches the search condition from the master table corresponding to the specified item, and a result display execution step for displaying a search result of the actual data searched in the search step on the search screen; Or a search instruction for the actual data related to the specified item specified on the screen displayed in accordance with the operation of the business application, including a search condition, corresponds to the specified item. A search step for searching the actual data that matches the search condition from the master table, and a display execution step for displaying a search screen on which the search result of the actual data searched in the search step is displayed on the display unit. , Including.

  In addition, the present invention relates to a table data search program, and the table data search program according to the present invention is connected to a database storing a plurality of master tables holding actual data so as to be able to communicate with a control unit. A table data search program for searching for actual data related to a specified item specified on a screen including at least one item displayed in accordance with an operation of a business application, which is executed by an information processing apparatus including a display unit. In response to a search instruction for the actual data related to the specified item specified on the screen displayed along with the operation of the business application to be executed by the control unit, specification of search conditions and search results A screen display execution step of displaying a search screen for performing display on the display unit; When the search condition is specified, a search step for searching the actual data that matches the search condition from the master table corresponding to the specified item, and the search result of the actual data searched in the search step A result display execution step to be displayed on the screen, or a search instruction for the actual data related to the specified item specified on the screen displayed along with the operation of the business application, including a search condition A search step for searching the actual data that matches the search condition from the master table corresponding to the specified item, and a search screen on which a search result of the actual data searched in the search step is displayed. And a display execution step of displaying on the display unit.

  According to the present invention, actual data relating to a specified item specified on a screen (a screen including at least one item) displayed in accordance with an operation of a business application (for example, a sales management system, an accounting business system, a payroll business system, etc.) Search from the master table stored in the database that is connected to communicate. Specifically, the present invention provides a search for specifying a search condition and displaying a search result when an actual data search instruction regarding a specified item specified on a screen displayed in accordance with the operation of a business application is received. When the screen is displayed on the display unit and the search condition is specified, the actual data matching the search condition is searched from the master table corresponding to the specified item, and the search result of the searched actual data is displayed on the search screen. Specifically, the present invention responds to a designated item when it receives a search instruction of actual data regarding a designated item designated on a screen displayed in accordance with the operation of a business application and includes a retrieval condition. The actual data matching the search condition is searched from the master table to be displayed, and a search screen on which the search result of the searched actual data is displayed is displayed on the display unit. As a result, it is possible to achieve data retrieval from a plurality of master tables in a business application (for example, sales management system, accounting business system, payroll business system, etc.) while reducing development costs.

  The present invention also displays the search screen by determining the size of the entire search screen based on preset size information relating to the size of the entire search screen. Thereby, the size of the entire search screen can be optimized, and an easy-to-see search screen can be displayed.

FIG. 1 is a block diagram illustrating an example of the configuration of the information processing apparatus. FIG. 2 is a diagram illustrating an example of a search target master table and an example of a search screen for a person-in-charge master table started from an order entry screen. FIG. 3 is a diagram illustrating an example of a search extraction target master table and an example of a search screen for a person-in-charge master table started from an order entry screen. FIG. 4 is a flowchart illustrating an example of the table data search process. FIG. 5 is a diagram showing an example of a search screen for a transaction category master table activated from the order entry screen. FIG. 6 is a diagram illustrating an example of a search screen for a transaction category master table activated from the sales input screen. FIG. 7 is a diagram illustrating an example of a search screen for a transaction category master table activated from the remaining order details screen. FIG. 8 is a diagram showing an example of a customer master table search screen activated from the order entry screen. FIG. 9 is a diagram showing an example of a customer master table search screen activated from the sales input screen. FIG. 10 is a diagram illustrating an example of a delivery master table search screen activated from the order entry screen and a supplier master table search screen activated from the sales input screen. FIG. 11 is a diagram illustrating an example of a warehouse master table search screen activated from the order entry screen and a product master table search screen activated from the order input screen. FIG. 12 is a diagram illustrating an example of a search screen for the business establishment master table activated from the order backlog detail screen. FIG. 13 is a diagram showing an example of a department master table search screen activated from the order backlog table screen. FIG. 14 is a diagram illustrating an example of a search screen for a person-in-charge master table activated from the remaining order details screen.

  Embodiments of a table data search device, a table data search method, and a table data search program according to the present invention will be described below in detail with reference to the drawings. In addition, this invention is not limited by this embodiment.

[1. Constitution]
The configuration of the information processing apparatus according to the present embodiment including the table data search apparatus of the present invention (hereinafter may be abbreviated as PC, which is an abbreviation for personal computer) is described with reference to FIG. 1, FIG. 2, and FIG. This will be described in detail. FIG. 1 is a block diagram illustrating an example of the configuration of the information processing apparatus.

  As shown in FIG. 1, the PC 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. These units can communicate via an arbitrary communication path. It is connected to the.

  The communication interface unit 104 connects the PC 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. That is, the communication interface unit 104 has a function of communicating data with other devices via a communication line.

  Here, the network 300 has a function of connecting the PC 100 and the database 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

  The database 200 is connected to the PC 100 via the network 300 so as to be able to communicate with each other, and stores a plurality of master tables holding actual data. For the master table to be searched, a definition based on a view (View) is performed on the database 200 in advance. The database 200 includes, for example, a transaction category master table (including transaction category and transaction category name) and a customer master table (including customer code, customer name, customer name, customer company code, etc.), delivery Destination master table (including delivery destination code, delivery destination name, delivery destination Kana name and company contact person code), supplier master table (supplier code, supplier name, supplier name, supplier name, and contact person) Code), warehouse master table (including warehouse code, warehouse name and business location code), product master table (including product code, product name, product name and standard), business location master table (business Office code, office name and office name), department master table (including department code, department name, department name and office code, etc.) ) And the person in charge master table (the person in charge code, contact name, including the person in charge Kana name and department code) are stored, and the like.

  The input / output interface unit 108 is connected to the input device 112 and the output device 114. Here, in addition to a monitor (including a home television), a speaker or a printer can be used as the output device 114 (hereinafter, the output device 114 may be described as the monitor 114). As the input device 112, a monitor that realizes a pointing device function in cooperation with a mouse can be used in addition to a keyboard, a mouse, and a microphone.

  The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 is a storage unit, and for example, a memory device such as a RAM / ROM, a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used. The storage unit 106 stores computer programs for giving instructions to the CPU and performing various processes in cooperation with an OS (Operating System). The storage unit 106 stores a search target master table 106a and a search extraction target master table 106b.

  The search target master table 106a stores a search target table and basic information for search screen display (for example, screen name, screen size, number of display digits, etc.). Here, an example of the search target master table 106a will be described in detail with reference to FIG. FIG. 2 is a diagram illustrating an example of the search target master table.

  As shown in FIG. 2, the search target master table 106a includes a search target table ID, a search branch number, a search screen name, a condition item display maximum number of lines, an extraction result display maximum number of lines, and an extraction result display maximum width. Holds data type, number of digits, and estimated size.

  The search target table ID is a table or view ID. The search branch number is a number corresponding to one table / multiple search registration. The search screen name is a caption of the search screen. The condition item display maximum number of lines is the maximum number of condition items to be displayed on the search screen (if the maximum number of lines is exceeded, the condition items are scroll-displayed). The extraction result display maximum number of lines is the maximum number of extraction results (search results) displayed on the search screen (when the maximum number of lines is exceeded, the extraction results are scrolled). The extraction result display maximum width is the maximum width of the extraction result displayed on the search screen.

  Here, FIG. 2 shows a search screen MA as an example of a search screen together with the search target master table 106a. The search screen MA is a search screen for a person-in-charge master table activated from an order entry screen displayed in accordance with an operation of an order entry program that is an example of a business application. Search screen MA mainly includes an area MA1 for displaying search conditions (including condition items, operators, and condition values) in a settable manner, and an area MA2 for displaying search results in a selectable manner. It is out.

  The name of the search screen displayed at the top of the search screen MA is defined by the search screen name of the search target master table 106a. The area MA1 is defined by the maximum number of condition item display rows in the search target master table 106a. When the number of condition item lines displayed in area MA1 exceeds the maximum number of condition item display lines, a scroll bar is displayed in area MA1. The area MA2 is defined by the extraction result display maximum number of rows and the extraction result display maximum width of the search target master table 106a. When the number of extraction result lines displayed in the area MA2 exceeds the extraction result display maximum line number, a scroll bar is displayed in the area MA2. The size of the entire screen of the search screen MA is determined from the designated number of lines and the number of displayed characters, and is automatically optimized.

  Returning to FIG. 1, the search extraction target master table 106 b stores definitions such as search items and display items of extraction results. For example, the specification of the item name defined in the view, the definition of the data type, the number of display digits, the display order, etc. are stored. Here, an example of the search extraction target master table 106b will be described in detail with reference to FIG. FIG. 3 is a diagram illustrating an example of the search extraction target master table.

  As shown in FIG. 3, the search extraction target master table 106b extracts the search target table ID, the search branch number, the item ID, the display item name, the number of digits, the data type, the column number, the column width, the display order, and the display position. The data type, the number of digits, and the estimation size are stored for the line number, extraction method, return value flag, search activation table ID, and search activation branch number.

  The search target table ID is a table or view ID. The search branch number is a number corresponding to one table / multiple search registration. The item ID is an ID of an item defined in the database. The display item name is the name of an item displayed on the search screen. The number of digits is the number of bytes for input control. Data type is 0 indicating “character”, 1 indicating “numerical value”, 2 indicating “quantity”, 3 indicating “unit price”, 4 indicating “amount”, 5 indicating “date”, “year / month” 6 indicating 7 and 7 indicating “slip number”. The column number is the number of the column order displayed in the extraction result list. The column width is the column width displayed in the extraction result list. The display order is the sort order of the extraction results. The display position is one of 0 indicating “left”, 1 indicating “right”, and 2 indicating “middle”. The extraction line number is the number of the line order displayed in the extraction condition list. The extraction method is one of 0 indicating “match”, 1 indicating “ambiguous”, and 2 indicating “range specification”. The return value flag is one of 0 indicating “not applicable” and 1 indicating “return value”. The search activation table ID is a search target table ID when further calling a search screen. The search activation branch number is a search branch number when further calling a search screen.

  Here, FIG. 3 shows a search screen MA, which is an example of a search screen, together with the search extraction target master table 106b. The area MA1 is defined by the display item name, the number of digits, the data type, the extracted line number, and the extraction method of the search extraction target master table 106b. The area MA2 is defined by the display item name, the number of digits, the data type, the column number, the column width, the display order, and the display position of the search extraction target master table 106b.

  If only the search result (extraction result) is to be displayed on the search screen, it is possible to leave the search condition side (extraction line number) unset. Specifically, if it is desired to display only the search result without displaying the extraction condition on the search screen, it is not necessary to set a value for the extracted line number (Null setting). Further, when only the search (extraction) is executed and the search result is not displayed on the search screen, the values need not be set in the display order (Null setting). In addition, when searching with a fixed search condition value, a search condition (extraction condition) is defined in advance, and then a parent program (for example, a table data search processing execution program to be described later) is called. Set the defined condition value in the argument on the side of the order entry program etc.) and start the search screen. However, the user cannot specify search conditions on the search screen. Further, when searching with a fixed search condition value, when there is only one extraction condition, a search screen including the search execution result is displayed.

  Returning to FIG. 1, the control unit 102 is a CPU (Central Processing Unit) or the like that comprehensively controls the PC 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, and necessary data, and executes various information processing based on these programs. The control unit 102 includes a display execution unit 102a and a search unit 102b in terms of functional concept.

  The display execution unit 102a displays a screen (in accordance with the operation of a business application (for example, a sales management system, an accounting business system, a payroll business system, etc. (specifically, a parent program such as the above-described order entry program)) ( Specifically, when an actual data search instruction regarding a specified item specified on the order entry screen described above is received from the business application side, a search screen for specifying search conditions and displaying search results (specifically Specifically, the above-described search screen MA or the like is displayed on the monitor 114. The display execution unit 102a displays the search result of the actual data searched by the search unit 102b on the search screen.

  When the search condition is specified on the search screen, the search unit 102b searches the master table corresponding to the specified item for actual data that matches the search condition. When the search unit 102b receives a search instruction for actual data related to the specified item specified on the screen displayed in accordance with the operation of the business application and includes a search condition, the search unit 102b searches the master table corresponding to the specified item for the search. Search actual data that meets the conditions.

[2. processing]
A table data search process performed by the PC 100 having the above-described configuration will be described in detail with reference to FIGS. 2, 3, and 4. FIG. 4 is a flowchart illustrating an example of the table data search process. Here, the actual data regarding the designated item “person in charge” designated by the user on the order entry screen displayed in accordance with the operation of the order entry program is retrieved from the person-in-charge master table stored in the database 200. The case will be described as an example.

  First, when the display execution unit 102a receives an instruction to search for actual data related to the designated item “person in charge” designated on the order entry screen displayed in accordance with the operation of the order entry program from the order entry program side, the search condition 2 and FIG. 3 for displaying the search result is displayed on the monitor 114 (step SA1). Here, since the search screen MA is activated from the order entry screen for searching for the person in charge, the screen name of the search screen MA is “order entry. Person in charge” as shown in FIGS. "Search" is set. In step SA1, if a fixed search condition is included in the actual data search instruction related to the designated item “person in charge”, the display execution unit 102a displays the search condition without displaying the search screen MA. To the search unit 102b.

  On the search screen MA displayed on the monitor 114, the user sets a desired search condition (condition item, operator and condition value) in the area MA1, and functions key F6 which functions to instruct display of the search result. Press. In the search screen MA shown in FIG. 2 and FIG. 3, nothing is set in the condition value column, but by setting in this way, data search of all cases included in the person-in-charge master table can be performed. It becomes possible.

  Upon receiving the press, the search unit 102b searches for the actual data that matches the search condition set in the area MA1 of the search screen MA from the person-in-charge master table that is the master table corresponding to the designated item “person in charge”. (Extract) (Step SA2). In step SA1, if a fixed search condition is included in the search instruction for the actual data related to the designated item “person in charge”, the search unit 102b is a master table corresponding to the designated item “person in charge”. From the person-in-charge master table, actual data that matches the search conditions passed from the display execution unit 102a is searched (extracted).

  The display execution unit 102a displays the actual data searched in step SA2 as a list in the area MA2 of the search screen MA (step SA3). Note that, in step SA1, if a fixed search condition is included in the search instruction for the actual data related to the specified item “person in charge”, the display execution unit 102a displays the search screen displaying the actual data searched in step SA2. The MA is displayed on the monitor 114.

[3. Search screen display pattern]
An example of the display pattern of the search screen displayed by the above-described table data search process will be described in detail with reference to FIGS.

  First, an example of a search screen in a case where search conditions (extraction conditions) are fixedly passed from the business application side and search results based on the search conditions are displayed when the search screen is displayed are shown in FIGS. 5, 6, and 7. Show.

  FIG. 5 shows a transaction category master table search screen MB started from the order entry screen displayed in accordance with the operation of the order entry program. The search screen MB mainly includes an area MB1 (cannot be changed) for displaying search conditions and an area MB2 for displaying search results in a selectable manner. The search screen MB displays a single search result for a fixed search condition (condition item: “data category”, operator: “equal”, condition value: “20”) for the transaction category master table, on the order entry program side. This is the display pattern when passing to.

  FIG. 6 shows a transaction category master table search screen MC started from the sales input screen displayed in accordance with the operation of the sales input program. The search screen MC mainly includes an area MC1 (cannot be changed) for displaying search conditions and an area MC2 for displaying search results in a selectable manner. The search screen MC displays a single search result for a fixed search condition (condition item: “data category”, operator: “equal”, condition value: “40”) for the transaction category master table. This is the display pattern when passing to.

  FIG. 7 shows a search screen MD of a transaction category master table activated from the remaining order details screen screen displayed in accordance with the operation of the remaining order details input program. The search screen MD mainly displays an area MD1 (cannot be changed) for displaying a search condition, an area MD2 for displaying a search result so as to be selectable, and a search result selected from the area MD2. And an area MD3 for performing the above. The search screen MD displays a plurality of arbitrarily selected search results from fixed search conditions (condition item: “data category”, operator: “equal”, condition value: “20”) for the transaction category master table. It is a display pattern in the case of passing to the order backlog input program side.

  In this way, the search program (execution program for the table data search process described above) called from the parent program (order input, sales input, order backlog, etc.) and the display pattern of the search screen are the same, but the parent program By specifying the method of argument set at the time of starting the search program (fixed condition value, whether the search result is returned as a single value or multiple arbitrary values, etc.), FIG. Various search screens as shown in FIGS. 6 and 7 can be displayed.

  Next, an example of the search screen in the case where the user specifies the search condition on the search screen and the search result under the specified search condition is displayed on the search screen by pressing the display button on the search screen is shown in FIG. 9, FIG. 10 and FIG.

  FIG. 8 shows a customer master table search screen ME activated from the order entry screen displayed in accordance with the operation of the order entry program. The search screen ME mainly includes an area ME1 for displaying a search condition so as to be settable, and an area ME2 for displaying a search result so as to be selectable. When the search screen ME is displayed on the monitor 114, the user sets a desired search condition in the area ME1 and presses the function key F6 that functions to instruct display of the search result. After receiving the press, the customer master table is searched (the table data search process described above), and the search result is displayed in the area ME2 as shown.

  FIG. 9 shows a customer master table search screen MF started from the sales input screen displayed in accordance with the operation of the sales input program. The search screen MF mainly includes an area MF1 for displaying a search condition so as to be settable, and an area MF2 for displaying a search result so as to be selectable. When the search screen MF is displayed on the monitor 114, the user sets a desired search condition in the area MF1, and presses the function key F6 that functions to instruct display of the search result. After receiving the press, the customer master table is searched, and the search result is displayed in the area MF2 as shown.

  In this way, one search setting (search condition regarding the specified item “customer”) can be used in common for a plurality of parent programs (order input, sales input, etc.). Therefore, even if the parent program to be started is different, a similar search screen as shown in FIGS. 8 and 9 can be displayed. 8 and 9, the name of the title part of the search screen is different from “order entry.customer search” and “sales input.customer search”. Are the same.

  FIG. 10 shows a delivery master table search screen MG started from the order entry screen displayed in accordance with the operation of the order entry program. The search screen MG mainly includes an area MG1 for displaying a search condition so as to be settable, and an area MG2 for displaying a search result so as to be selectable. When the search screen MG is displayed on the monitor 114, the user sets a desired search condition in the region MG1, and presses the function key F6 that functions to instruct display of the search result. After receiving the press, a search for the delivery destination master table is executed, and the search result is displayed in the area MG2 as shown in the figure.

  FIG. 10 shows a supplier master table search screen MH started from a sales input screen displayed in accordance with the operation of the sales input program. The search screen MH mainly includes an area MH1 for displaying a search condition so as to be settable, and an area MH2 for displaying a search result so as to be selectable. When the search screen MH is displayed on the monitor 114, the user sets a desired search condition in the area MH1, and presses the function key F6 that functions to instruct display of the search result. After receiving the press, the supplier master table is searched, and the search result is displayed in the area MH2 as shown.

  Here, the search screen MG and the search screen MH shown in FIG. 10 have different sizes because the settings of the number of display rows of the search results are different.

  FIG. 11 shows a warehouse master table search screen MI activated from the order entry screen displayed in accordance with the operation of the order entry program. The search screen MI mainly includes an area MI1 for displaying a search condition so as to be settable, and an area MI2 for displaying a search result so as to be selectable. When the search screen MI is displayed on the monitor 114, the user sets a desired search condition in the area MI1 and presses the function key F6 that functions to instruct display of the search result. After receiving the press, a search for the warehouse master table is executed, and the search result is displayed in the area MI2 as shown.

  Further, FIG. 11 shows a product master table search screen MJ started from the order entry screen displayed in accordance with the operation of the order entry program. The search screen MJ mainly includes an area MJ1 for displaying a search condition so as to be settable and an area MJ2 for displaying a search result so as to be selectable. When the search screen MJ is displayed, the user sets a desired search condition in the area MJ1, and presses the function key F6 that functions to instruct display of the search result. After receiving the press, the product master table is searched, and the search result is displayed in the area MJ2 as shown.

  Here, since the search screen MJ shown in FIG. 11 has more search result display items than the search screen MI, the left and right screen sizes of the search screen MI and the search screen MJ are different as shown in the figure.

  In this way, the number of display rows of search results can be specified by individual search settings. Therefore, in a search pattern that is assumed to have many search results, the number of display rows is set in advance. In this case, the upper and lower screen sizes (screen length) are automatically changed according to the setting. In addition, since the number of display items and display width can also be specified in individual search settings, if the number of display items and display width are also changed and set in advance, the left and right screen sizes (screen width) can also be set. It is automatically changed according to the setting.

  Next, FIG. 12, FIG. 13 and FIG. 14 show examples of search screens when search conditions are the same and search result selection methods (whether they are returned in a single or multiple (at random)) are different.

  FIG. 12 shows an office master table search screen ML started from the remaining order details screen screen MK displayed in accordance with the operation of the remaining order details input program. The search screen MK mainly includes an area MK1 (non-changeable) for displaying the search result so as to be selectable. The search screen MK is a display pattern in the case where a single search result for all items searched without specifying a search condition for the business establishment master table is returned to the remaining order entry program.

  In addition, FIG. 12 shows a search screen MM for the office master table activated from the remaining order details screen screen MK. The search screen MM mainly includes an area MM1 (cannot be changed) for displaying the search result in a selectable manner and an area MM2 for displaying the search result selected in the area MM1 in a selectable manner. . The search screen MM is a display pattern in the case where a plurality of search results searched without specifying search conditions for the business establishment master table are returned to the order backlog input program side. The user moves desired data to be returned to the parent program among the search results displayed in the area MM1 to the area MM2.

  FIG. 13 shows a department master table search screen MN activated from the order backlog table screen MK. The search screen MN mainly includes an area MN1 for displaying a search condition so as to be settable and an area MN2 for displaying a search result so as to be selectable. The search screen MN is a display pattern in a case where a single search result for all items searched without specifying a search condition for the department master table is returned to the order backlog input program side. When the search screen MN is displayed on the monitor 114, the user presses the function key F6 that functions to instruct display of the search result without setting the search condition in the area MN1. After receiving the press, the department master table is searched, and the search results (search results for all cases) are displayed in the area MM2 as shown.

  FIG. 13 shows a department master table search screen MO activated from the remaining order details screen MK. The search screen MO mainly displays an area MO1 for displaying search conditions in a settable manner, an area MO2 for displaying search results in a selectable manner, and a search result selected in the area MO2 in a selectable manner. And a region MO3 for the purpose. The search screen MO is a display pattern in the case where a plurality of search results searched without specifying a search condition for the department master table are returned to the order backlog input program side. When the search screen MO is displayed on the monitor 114, the user presses the function key F6 that functions to instruct display of the search result without setting the search condition in the area MO1. After receiving the press, the department master table is searched, and the search results (search results for all cases) are displayed in the area MO2 as shown. The user moves desired data to be returned to the parent program among the search results displayed in the region MO2 to the region MO3.

  FIG. 14 shows a search screen MP of the person-in-charge master table activated from the remaining order details screen screen MK. The search screen MP mainly includes an area MP1 for displaying a search condition so as to be settable and an area MP2 for displaying a search result so as to be selectable. The search screen MP is a display pattern in the case where a single search result for all cases searched without specifying a search condition for the person-in-charge master table is returned to the order backlog input program side. When the search screen MP is displayed on the monitor 114, the user presses the function key F6 that functions to instruct display of the search result without setting the search condition in the area MP1. After receiving the press, a search is performed on the person-in-charge master table, and the search results (search results for all cases) are displayed in the area MP2 as shown.

  Further, FIG. 14 shows a search screen MQ of the person-in-charge master table activated from the remaining order details screen screen MK. The search screen MQ mainly displays an area MQ1 for displaying search conditions in a settable manner, an area MQ2 for displaying search results in a selectable manner, and a search result selected in the area MQ2 in a selectable manner. Region MQ3. The search screen MQ is a display pattern in the case where a plurality of search results searched without specifying a search condition for the person-in-charge master table are returned to the order backlog input program side. When the search screen MQ is displayed, the user presses the function key F6 that functions to instruct display of the search result without setting the search condition in the area MQ1. After receiving the press, a search is performed on the person-in-charge master table, and the search results (all search results) are displayed in the area MQ2 as shown. The user moves desired data to be returned to the parent program among the search results displayed in the area MQ2 to the area MQ3.

  In this way, by specifying whether single or plural search results are to be returned on the parent program side that starts the search screen, the display patterns can be separated as shown in FIGS. Is possible. In addition, the method of returning the search result to the parent program side (whether to return the search result in a single or multiple ways) differs depending on the mode at the time of starting the search screen on the parent program side. If no search condition is specified, all items can be searched from the search target master table. In addition, even if the same search condition is set in the argument setting on the parent program side that starts the search screen, a pattern that returns a single value and a pattern that returns an arbitrary plurality of values can be selected.

[4. Summary of this embodiment and other embodiments]
As described above, according to the present embodiment, various screens (for example, an order input screen, a sales input screen, an order received) displayed in accordance with the operations of various parent programs (for example, order input, sales input, and remaining order details input). The actual data related to the designated item designated on the remaining schedule table screen or the like is searched from the master table stored in the database 200. Specifically, when a search instruction for actual data related to a specified item is received from the parent program, a search screen is displayed on the monitor 114. When a search condition is specified by the user, the search condition is changed from the master table corresponding to the specified item. Applicable actual data is searched, and the search result of the searched actual data is displayed on the search screen. Specifically, when an actual data search instruction related to the specified item and including a search condition is received, the actual data that matches the search condition is searched from the master table corresponding to the specified item, and the searched actual data is searched. A search screen on which data search results are displayed is displayed on the monitor 114.

  As described above, in the present embodiment, in the search program in the business application (for example, sales management system, accounting business system, salary business system, etc.), the definition is set only by one search program. As described with reference, it is possible to search for arbitrary table data. That is, data search for a plurality of tables can be performed with a single search program having versatility. Therefore, data retrieval from a plurality of master tables in a business application can be realized while reducing development costs.

  Further, according to the present embodiment, as described with reference to FIGS. 10 and 11, the size information (specifically, the maximum condition item display) regarding the size of the search screen set in advance in the search target master 106a. The size of the entire search screen is determined based on the number of rows, the maximum number of extracted result display rows, the maximum extracted result display width, and the like, and the search screen is displayed. As a result, it is possible to optimize the size of the entire search screen and display a search screen in which search results are easy to see.

  Furthermore, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims, in addition to the above-described embodiments. For example, in the present embodiment, the case where the PC 100 performs processing in a stand-alone form has been described as an example. However, processing is performed in response to a request from a client terminal configured with a separate housing from the PC 100, and the processing result is displayed. You may comprise so that it may return to the said client terminal. Also, among the processes described in this embodiment, all or part of the processes described as being performed automatically can be performed manually, or the processes described as being performed manually can be performed. All or a part can be automatically performed by a known method. In addition, the specific form of device distribution / integration is not limited to that shown in the figure, and all or part of the device is functionally or physically distributed in arbitrary units according to various additions or according to functional load. -Can be integrated and configured. Further, the processing procedures, control procedures, specific names, screen examples, and the like shown in this specification and the drawings can be arbitrarily changed unless otherwise specified.

  In addition, regarding the PC 100, each illustrated component is functionally conceptual and does not necessarily need to be physically configured as illustrated. For example, the processing functions provided in each device of the PC 100, in particular, the processing functions performed by the control unit 102, are realized entirely or arbitrarily by a CPU and a program interpreted and executed by the CPU. Also good. The program is recorded on a recording medium to be described later, and is mechanically read by the PC 100 as necessary. In other words, the storage unit 106 such as a ROM or an HD stores a computer program for giving various instructions to the CPU in cooperation with the OS. This computer program is executed by being loaded into the RAM, and constitutes a control unit in cooperation with the CPU. The computer program may be stored in an application program server connected to the PC 100 via an arbitrary network, and may be downloaded in whole or in part as necessary. Various databases (search target master table 106a to search / extraction target master table 106b) stored in the storage unit 106 include memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks. Storage means for storing various programs, tables, databases, web page files, etc. used for various processes and website provision.

  Further, the PC 100 may be realized by installing software (including programs, data, and the like) that realizes the table data search method according to the present invention on the PC. The table data search program according to the present invention may be stored in a computer-readable recording medium, and can be configured as a program product. Here, the “recording medium” refers to any “portable physical medium” such as a flexible disk, magneto-optical disk, ROM, EPROM, EEPROM, CD-ROM, MO, DVD, LAN, WAN, or the Internet. A “communication medium” that holds a program in a short period of time is included, such as a communication line or a carrier wave in the case of transmitting a program via a representative network. The “program” is a data processing method described in an arbitrary language or description method, and may be in any format such as source code or binary code. Note that the “program” is not necessarily limited to a single configuration, and functions are achieved in cooperation with a separate configuration such as a plurality of modules and libraries or a separate program represented by the OS. Including things. Note that a well-known configuration and procedure can be used for a specific configuration for reading a recording medium, a reading procedure, an installation procedure after reading, and the like in each device described in the embodiment.

  As described above, the table data search device, the table data search method, and the table data search program according to the present invention are particularly useful for real data relating to designated items designated on various screens displayed in accordance with the operation of a business application. Suitable for searching.

100 Information processing apparatus 102 Control unit
102a Display execution unit
102b Search unit 104 Communication interface unit 106 Storage unit
106a Search target master table
106b Search extraction target master table 108 Input / output interface unit 112 Input device 114 Output device 200 Database 300 Network

Claims (1)

At least one item that is communicably connected to a database that stores a plurality of master tables that store actual data, includes a control unit, a display unit, and a storage unit, and is displayed as the business application operates. A table data search device for searching the actual data related to a specified item specified on a screen including:
The storage unit stores a search extraction target master table in which setting data regarding the search condition and / or the display state of the search result and / or the specification of the search condition is stored,
The controller is
Upon receiving a search instruction for the actual data related to the specified item specified on the screen displayed in accordance with the operation of the business application, a search screen for specifying a search condition and displaying a search result is displayed on the display unit. Display execution means for displaying the search data, and when the search condition is specified, search means for searching the actual data that matches the search condition from the master table corresponding to the specified item, the display execution means Displaying the search result of the actual data searched by the search means on the search screen;
Or
Upon receiving a search instruction for the actual data related to the specified item specified on the screen displayed along with the operation of the business application, including a search condition, the master table corresponding to the specified item Search means for searching for the actual data that matches a search condition; and display execution means for displaying a search screen on which the search result of the actual data searched by the search means is displayed on the display unit;
Features
The search means refers to the setting data stored in the search extraction target master table and executes a search for the actual data,
The display execution means refers to the setting data stored in the search extraction target master table and executes display of the search screen;
Table data search device characterized by the above.