JP4411343B2 - Information processing apparatus, information processing method, and program - Google Patents

Description

The present invention relates to a technique for rearranging data by a plurality of items, and particularly to a technique for easily changing the priority of data rearrangement items .

  Generally, a list or an electronic mail application that searches a database and displays a list of search results has a sorting function so that the user can efficiently browse the search results.

  Generally, by selecting an item (sort key item) that is the key when sorting, and setting whether to sort the item in descending or ascending order, the results sorted based on that setting are displayed on the screen. Will be.

  At this time, the sort setting is devised so that a mark such as “「 ”indicating descending order or“ △ ”indicating ascending order is displayed on the sort item to allow the user to visually recognize it. In many cases, sorting is performed by designating item names with a pointing device such as a mouse. However, in many cases, sorting by multiple items cannot be performed.

  On the other hand, spreadsheet software such as Microsoft Excel (registered trademark) can sort data using a plurality of items as keys. In that case, select the sort key item, display the UI for setting the priority and sort direction, set the sort priority and sort direction of multiple items, and sort the data. Is possible. However, the sort key cannot be set in the list.

Patent Document 1 discloses a technique for sorting data based on a plurality of sort keys by performing an operation on a data list.
JP 2006-031084 A

However, Patent Document 1 does not disclose any priority changes Seo Toki.

The present invention has been made to solve the above problems, and provides a mechanism for easily changing the priority of data sorting items when sorting data by a plurality of items. For the purpose.

The present invention relates to an information processing apparatus for displaying data composed of a plurality of items , wherein a request for setting the data item as a sort key item is an item name in the list of data displayed on a display device. The first accepting means for accepting by the instruction for the area where is displayed, and the request for changing the sort priority of the sort key item, by the instruction for the area where the item name is displayed in the list of data displayed on the display device Second accepting means for accepting, and first control means for setting an item that has received a request to be set as a sort key item by the first accepting means as a sort key item, and determining a sort priority in accordance with the order of accepting the request When the determination determining the presence of a sort key item set as replacement candidates for sorting priority When receiving the sorted priority change request stage and the second receiving unit, already when the sort key item set as replacement candidates for sorting priority it does not exist, accepting the sort order change request If the sort key item is set as a sort priority replacement candidate and there is a sort key item set as a sort priority replacement candidate, the sort priority item and the sort priority replacement are accepted. Second control means for switching the sort priority with the sort key item set as a candidate, and a display for displaying data sorted according to the sort priority determined by the first and second control means on the display device And a control means.

According to the present invention, when sorting by a plurality of keys while referring to a data list, it is possible to easily change the priority of the sort keys.

  FIG. 1 is a system configuration diagram showing an example of the configuration of an information processing system according to the present invention.

  In FIG. 1, reference numeral 101 denotes a database server, which includes a database mechanism for recording and managing data such as a customer master and a sales master, and performs registration, update, deletion and search requests from the information processing apparatuses 102-1 and 102-2. And process them as required.

  The information processing apparatuses 102-1 and 102-2 (hereinafter collectively referred to as the information processing apparatus 102), with respect to the database server 101, newly register, change, and delete data in a table managed by the database server 101. A request such as a search is made based on a user instruction.

  A network 103 connects the database server 101 and the information processing apparatuses 102-1 and 102-2 to each other so that data communication can be performed.

  Next, the hardware configuration of the database server 101 and the information processing apparatus 102 will be described with reference to FIG.

  FIG. 2 is a block diagram illustrating an example of a hardware configuration of the database server 101 and the information processing apparatus 102.

  In FIG. 2, 201 is a CPU that controls the entire terminal (computer) using programs and data stored in a RAM 202 and a ROM 203, and a database server 101 or an information processing apparatus 102 to which this computer is applied. Each process to be described later is executed.

  A RAM 202 has an area for temporarily storing programs and data loaded from an HDD (Hard Disk Drive) 204 and a work area used by the CPU 201 to perform various processes.

  A ROM 203 stores various programs such as a computer boot program and BIOS. Reference numeral 204 denotes an HDD (Hard Disk Drive), which is an OS (Operating System), a database server 101 to which this computer is applied, or various data such as programs and data for causing the CPU 201 to execute processes described later performed by the information processing apparatus 102. These are read out to the RAM 202 and executed under the control of the CPU 201 as necessary.

  Reference numeral 205 denotes a recording medium drive, which includes a CD-ROM, CD-R / RW, DVD-ROM, DVD-R / RW, DVD-RAM, and the like.

  A keyboard 206 and a pointing device 207 can input various instructions to the CPU 201. These function as an input unit.

  Reference numeral 208 denotes a video I / F (interface), to which a display device 209 is connected. The display device 209 includes a CRT, a liquid crystal screen, and the like, and has a function of displaying information such as characters and images on a display screen based on a signal sent via the video I / F 208.

  Reference numeral 210 denotes a network I / F (interface) for connecting a computer to the network 103. The computer can perform data communication with other devices on the network via the network I / F 210.

  An external device I / F (interface) 211 is a port for connecting a peripheral device to the computer. The computer can transmit / receive data to / from peripheral devices via the external device I / F 211. It can be configured by various interfaces such as SCSI, USB, IEEE 1394, etc., and usually has a plurality of external device I / Fs 211. The connection form with the peripheral device may be wired or wireless.

  A system bus 212 functions as a bus that interconnects the various components described above.

  FIG. 3 is a block diagram illustrating a functional configuration of the information processing apparatus 102.

  In FIG. 3, reference numeral 301 denotes a control unit that instructs the data access unit 303 to extract list data.

  A display control unit 302 controls display of list data displayed on a display unit such as the display device 209 in accordance with an input instruction from the input control unit 305.

  A data access unit 303 creates a search statement such as SQL, accesses the database server 101 to perform data search, and obtains list data as a result from the database server 101.

  A data management unit 304 stores list data acquired by the data access unit 303 and a search statement used to acquire the list data.

  Reference numeral 305 denotes an input control unit, which displays a display control command from a user for a list displayed on a display unit such as the display device 209 via an input unit including a keyboard 206 and a pointing device 207. The display control unit 302 is notified.

  Note that the control unit 301, the display control unit 302, the data access unit 303, the data management unit 304, and the input control unit 305 are each realized by the CPU 201 loading a program stored in the HDD 204 into the RAM 202 and executing it. It corresponds to the part.

  This completes the description of the functional configuration of the information processing apparatus.

  Hereinafter, processing performed in the information processing apparatus 102 will be described with reference to FIGS.

  FIG. 4 is a flowchart showing master data editing processing managed by the database server 101 performed by the information processing apparatus 102. This process is realized by the CPU 201 of the information processing apparatus loading a program recorded in the HDD 204 into the RAM 202 and executing it.

  First, the CPU 201 of the information processing apparatus acquires a search expression for acquiring data (for searching data) from the database server 101 (S401).

  Note that even if the retrieval formula is acquired in advance as a file in the HDD 204, a screen for inputting the retrieval formula is displayed on the display device 209, and the input unit such as the keyboard 206 is displayed by solving the screen. You may acquire the search sentence instructed to input via.

  Then, the CPU 201 makes a search request using the search formula acquired in step S401 to the database server 101 (S402).

  Then, as a result of the database search process in the database server 101, the CPU 201 acquires data (list data) that matches the search formula from the database server 101 (S403).

  The CPU 201 determines whether the search condition acquired in step S401 includes a sort condition (for example, “order by” phrase in the case of SQL) (S404).

  If it is determined in step S404 that there is a sort condition (YES in S404), the CPU 201 determines the sort condition (the item name that is the sort key, the sort direction (ascending order or descending order), and if there are multiple sort conditions, The sort key priority order) is stored in the RAM 202 (S405).

  Thereafter, the CPU 201 performs display processing of the acquired list data (S406). Details of the list data display processing will be described later with reference to FIG.

  Thereafter, the CPU 201 performs an editing process on the displayed data (S407). Details of this editing process will be described later with reference to FIG.

  Thereafter, the CPU 201 determines whether to perform editing processing on other data (S408).

  When it is determined that the editing process for other data is to be continued (YES in S408), the CPU 201 controls to repeat the process from step S401. In this case, in step S401, a search expression necessary for editing processing for other data is acquired.

  On the other hand, if it is determined in step S408 that the process is not to be continued (NO in S408), the CPU 201 controls to end the process.

  FIG. 5 is a flowchart showing in detail an example of the list data display process in step S406 of FIG. This process is realized by the CPU 201 of the information processing apparatus loading a program recorded in the HDD 204 into the RAM 202 and executing it.

  First, the CPU 201 sets the item name of each item in the column heading of the list (S501).

  Thereafter, the CPU 201 assigns “1” to N (stored in the RAM 202), which is a variable indicating the priority order of the sort keys (S502).

  Thereafter, the CPU 201 repeats the processing from step S503 to step S511 for the number of sort keys. If no sort key is set, these processes are not performed, and the CPU 201 advances the process to step S512.

  First, in step S503, the CPU 201 obtains item information of the sort key with the sort priority N and the sort direction from the sort conditions stored in the RAM 202 (S405 in FIG. 4).

  Then, when the sort direction of the sort key acquired in step S503 is ascending order (when it is determined as “ascending order” in S504), the CPU 201 sorts images indicating ascending order, for example, “△” images (for example, 901 of FIG. 9 is generated (S505), and the process proceeds to step S507.

  On the other hand, if the sort direction of the sort key is descending order (when it is determined as “descending order” in S504), a sort icon indicating descending order, for example, “▽” is generated (S506), and the process proceeds to step S507. Proceed. The sort icon may have any form as long as it can recognize the sort direction.

  In step S507, the CPU 201 acquires the number of sort keys set as the sort condition.

  Next, the CPU 201 determines the number of sort keys acquired in step S507 (S508). If a plurality of sort keys are set, the process proceeds to step S509 so that the priority order of the sort keys can be visually identified. Therefore, the display mode of the sort icon is changed. At this time, even if a sort icon (for example, 1001 to 1003 in FIG. 10) in which the number indicating the priority order is displayed in the sort icon Δ or ▽, the priority order is relatively determined by the size of the sort icon. May be recognized. Further, priority may be indicated by color. For example, priorities may be provided in the order of blue, yellow, and red. In this case, in addition to the list, the display may be blue: priority 1, yellow: priority 2, red: priority 3. That is, any display format may be used as long as the priority can be identified.

  Then, when the process of step S509 ends, the CPU 201 advances the process to step S510.

  On the other hand, if it is determined in step S508 that one (one) sort key is set, the CPU 201 advances the process to step S510.

  Next, in step S510, the CPU 201 sets a sort icon in the column header of the item set as the sort key having the Nth priority.

  After that, the CPU 201 adds 1 to the number N, which is a variable indicating the priority of the sort key, in order to perform the process for the sort key having the next priority (S511), and returns the process to step S503.

  Then, when the CPU 201 finishes the processes of step S503 to step S511 by the number of sort keys, the process proceeds to step S512.

  In step S512, the CPU 201 displays the data acquired from the database server 101 in S403 of FIG. 4 (S512). At this time, if the sort condition is set, the CPU 201 performs data display according to the sort condition.

  After this processing is completed, when the sort key is singular, a list as shown in FIG. 9 is displayed on the display device 209. On the other hand, when there are a plurality of sort keys, a list as shown in FIG. 10 is displayed on the display device 209.

  FIG. 6 is a flowchart showing in detail an example of the editing process in step S407 of FIG. This process is realized by the CPU 201 of the information processing apparatus loading a program recorded in the HDD 204 into the RAM 202 and executing it.

  When the processing of this flowchart is started, the CPU 201 has always received an instruction to change the sort condition based on an instruction from the input unit by the user (S601), or has received an instruction to edit the displayed data (S602). ), Whether an edit content storage request has been received (S607), or an edit end instruction has been received (S609).

  For example, the sort condition change instruction can be input by instructing the column headings of the list displayed on the display device 209 with a pointing device. An editing instruction can be given by selecting the displayed data and changing the contents of the column using a keyboard or the like.

  First, when it is determined that the sort condition has been changed (YES in S601), the CPU 201 determines whether the change instruction is a sort key priority change instruction or a sort direction change instruction. (S604).

  For example, when a specific key on the keyboard (for example, “Alt” or “Ctrl” is pressed), the column heading is clicked with the pointing device, and the priority is changed. The column heading is simply clicked with the pointing device. It is possible to set the instruction as a condition for changing the sort order, and these conditions are not limited to this, and even if the conditions of double click and single click are set, a specific position ( For example, it is of course possible to set conditions such as changing the priority when the click area (sort icon display area) is instructed, and changing the sort direction when other locations are clicked.

  If it is determined in step S604 that the priority order change condition is met, the CPU 201 performs sort key priority order change processing (S605), and proceeds to step S607. The details of the sort key priority change process will be described later with reference to FIG.

  On the other hand, if it is determined in step S604 that the conditions for changing the sort direction are met, the CPU 201 performs sort direction change processing (S606), and advances the processing to step S607. Details of the sorting direction change process will be described later with reference to FIG.

  If it is determined in step S601 that no sort condition change instruction has been received (NO in S601), the CPU 201 determines whether a data editing instruction has been received (S602).

  If it is determined that a data editing instruction has been received (YES in step S602), the CPU 201 stores in the RAM 202 the data for which the editing instruction has been received in the RAM 202 so as to be identifiable as to which item in the record. The display content is changed (S603). Then, the process proceeds to step S607.

  On the other hand, if it is determined that a data editing instruction has not been received (NO in S602), the CPU 201 proceeds to step S607 as it is.

  In step S607, the CPU 201 determines whether an instruction to confirm editing contents (register editing contents in the database) has been received. If the CPU 201 determines that an instruction to confirm editing contents has been received (YES in step S607), the database 201 The server 101 is instructed to update the contents of the database with the edited data (S608). Then, the process proceeds to step S609.

  On the other hand, if it is determined in step S607 that an instruction to confirm editing contents has not been received (NO in S607), the CPU 201 proceeds to step S609 as it is.

  If the CPU 201 determines in step S609 that it has not received an editing end instruction (NO in step S609), the process returns to step S601 to continue monitoring the instruction.

  On the other hand, in step S609, if the CPU 201 determines that an editing end instruction has been received (YES in step S609), the processing of this flowchart ends.

  FIG. 7 is a flowchart showing in detail an example of the sort key priority changing process in step S605 of FIG. This process is realized by the CPU 201 of the information processing apparatus 102 loading a program recorded in the HDD 204 into the RAM 202 and executing it.

  First, the CPU 201 determines whether the instruction received from the user through the pointing device is a sort condition reset instruction.

  The sort condition reset processing means that the sort condition that has already been set is invalidated and the data is rearranged (initialized) according to the sort condition set at the time of database search.

  Here, when the column heading is instructed to be clicked while the specific key is being pressed, it is set that the priority order is to be changed. In the case of “Alt” key + clicking instruction, the priority order is simply changed. In the case of an instruction, “Alt” + “Ctrl” + click instruction, it is possible to set a reset request or the like.

  In addition, if the condition is set to be a priority change instruction when the column heading is double-clicked, a reset request is issued when a double-click instruction is issued while a specific key on the keyboard is pressed. It may be a condition.

  In addition, if it is set that the click of a specific part of the column heading is a condition for instructing to change the priority order, when the specific key is pressed and the corresponding part is clicked or double-clicked It is possible to set that the condition is a reset request condition.

  These conditions are set by, for example, displaying a dialog box (not shown) and inputting a key used for a priority order instruction or a key used for a reset instruction. Input may be performed by actually operating the mouse for each of the priority order and reset.

  When it is determined in step S701 that the instruction is a sort setting reset request instruction (YES in S701), the CPU 201 resets the sort setting (S702). That is, the sort condition is returned to the state set in the search expression acquired in step S 401 in FIG. 4 and the sort condition is stored in the RAM 202. Then, the list data display process shown in FIG. 5 is performed (S713), and the process of this flowchart is terminated.

  On the other hand, if it is determined in step S701 that the request is not a sort setting reset request (NO in S701), the CPU 201 determines whether the item instructed as a priority change instruction target has already been set as a sort key. (S703).

  If it is determined that an item not set as a sort key has been designated (NO in S703), the CPU 201 performs sort direction change processing (S704). This sort direction change processing will be described later with reference to FIG.

  After that, the CPU 201 determines whether there is a sort key that has already been set as a sort priority replacement candidate (S705).

  If it is determined that there is no sort key set as a sort priority replacement candidate (NO in S705), the CPU 201 sets the designated sort key item as a priority replacement candidate (S706). Display control is performed so that the user can recognize that the sort key item has been set as a replacement target item (S707).

  For example, as shown in FIG. 13A, when a sort key “code” 1301 that has not yet been set as a sort priority replacement candidate is designated, the sort key “code” 1301 is set as a priority replacement candidate, and the sort key In order to make the user recognize that the “code” 1301 has been set as the item to be exchanged, the display form is changed as shown in FIG. That is, the display format of the column heading of the sort key “code” 1301 set as the item to be replaced is different from the column headings “classification” 1302 and “name” 1303 of other items.

  Then, when the process of S707 is completed, the CPU 201 ends the process of this flowchart.

  On the other hand, if it is determined in step S705 that a replacement candidate has already been set (YES in S705), the CPU 201 is directed to the column header of the sort key item that has already been set as a replacement candidate. Is determined (S708).

  If it is determined in step S708 that the instruction is a column heading of a sort key item that has already been set as a replacement candidate (YES in S708), the CPU 201 invalidates (cancels) the replacement candidate setting. (S709), the column heading display of the item is returned to the normal one (S710). For example, as shown in FIG. 13B, when the sort key “code” 1301 that has already been set as the sort priority replacement candidate is designated, the replacement candidate setting of the sort key “code” 1301 is canceled, and FIG. The display is returned to that shown in (a).

  Then, when the process of S710 is completed, the CPU 201 ends the process of this flowchart.

  On the other hand, if it is determined in step S708 that the specified column header is a sort key item that is not set as a replacement candidate (NO in S708), the CPU 201 replaces the newly specified sort key item with the replacement candidate. The priority order of the sort key item is switched (S711). Thereafter, the CPU 201 returns the column headings of the sort key items to be replaced to normal ones (S712).

  For example, as shown in FIG. 13B, when the sort key “code” 1301 is already set as a sort priority replacement candidate and a sort key “classification” 1302 that is not set as a replacement candidate is designated, As shown in FIG. 13C, the priority order of the newly designated sort key “classification” 1302 and the replacement candidate sort key “code” 1301 is switched, and the column headings of the replacement candidate sort key items are returned to normal ones. .

  When the process of S712 is completed, the CPU 201 performs a list data display process shown in FIG. 5 (S713), and ends the process of this flowchart.

  The above is an example of the sort key priority change process. Although not described above, when there is no item set as a sort key, it is of course possible to perform control so that this process is not performed (a request for changing the sort priority is not accepted). .

  If NO in step S705, if only one sort key is set at that time, the CPU 201 does not execute the processes in steps S706 and S707, and ends the process of this flowchart as it is. It may be configured. That is, when only one sort key is set, it may be configured not to accept the change of the sort priority itself.

  Further, in the case of NO in S703, the processing may be terminated as it is. In other words, when a change in sorting priority is requested for an item that is not set as a sort key, a request for changing the sorting priority itself may not be accepted.

  FIG. 8 is a flowchart showing in detail an example of the sorting direction change process shown in step S606 of FIG. This process is realized by the CPU 201 of the information processing apparatus loading a program recorded in the HDD 204 into the RAM 202 and executing it.

  First, when the CPU 201 determines that an instruction to change the sort direction has been received, the CPU 201 determines whether there is a sort key item set as a sort priority replacement candidate at that time (S801).

  If it is determined that there is a sort key item set as a replacement candidate (YES in S801), the CPU 201 cancels the replacement candidate setting (S802) and advances the process to step S803.

  On the other hand, if it is determined in step S801 that there is no sort key item set as a replacement candidate (YES in S802), the CPU 201 proceeds the process to step S803 as it is.

  Next, in step S803, the CPU 201 acquires current sort direction information of an item for which a sort direction change instruction has been received.

  Next, when the CPU 201 determines that the acquired result is “ascending order” (“ascending order” in S804), the CPU 201 changes the sorting direction of the item (already set as a sort key item) in descending order ( S805).

  For example, as shown in FIG. 12A, when it is determined that a sort direction change instruction has been received for the sort key “code” 1201 in ascending order, the sort key “ The sorting direction of the “code” 1201 is changed in descending order.

  When the process of S805 is completed, the CPU 201 performs a list data display process shown in FIG. 5 (S811), and ends the process of this flowchart.

  If it is determined in step S804 that the result obtained in S803 is “descending order” (“descending order” in S804), the CPU 201 excludes the item from the sort key item (S806).

  Then, if there is another sort key item whose priority is lower than the sort key item excluded in step S806, the CPU 201 controls to change the priority (increase the priority by one) (S807).

  When the processing of S807 is completed, the CPU 201 performs list data display processing shown in FIG. 5 (S811), and ends the processing of this flowchart.

  If it is determined in step S804 that the result obtained in step S803 is “no sort direction is specified” (“not specified” in step S804), the CPU 201 has not yet set the item as a sort key item. Since there is no item, the item is added to the sort key item (S808), and the priority order is set to the lowest (S809). Then, the sort direction of the item is set in ascending order (S810).

  For example, as shown in FIG. 11A, when it is determined that a sort direction change instruction has been received for a “section” 1102 in which the sort direction is not specified, as shown in FIG. "Classification" 1202 is added to the sort key item, and its priority is set to "2" which is the lowest order.

  When the processing of S807 is completed, the CPU 201 performs list data display processing shown in FIG. 5 (S811), and ends the processing of this flowchart.

  The above is an example of the sort direction change process performed by the CPU of the information processing apparatus 102 when a sort direction change instruction is received.

  FIG. 9 is a diagram showing an example of a list display example when the sort key is singular.

  In the example shown in FIG. 9, as indicated by 901, the “code” item is set as the sort key, and the other items are not set as the sort key.

  In this example, since the item designated as the sort key is only the “code” item, the sort icon represents only the direction of sorting.

  FIG. 10 is a diagram showing an example of a list display example when a plurality of sort keys are set.

  In the example shown in FIG. 10, the “code” item is in ascending order as shown in 1001, the “category” item is in ascending order as shown in 1002, the “name” item is in descending order as shown in 1003, and the priority is “Code”, “Division”, “Name” are set in this order.

  In this example, since there are a plurality of items specified by the sort key, as shown by 1001, 1003, 1003, numbers indicating the priority are displayed in the sort icons indicating the direction, and the sort direction, The priority is controlled so as to be easily visible.

  FIG. 11 is a diagram illustrating an example of display control of a sort icon when a sort key is added.

  In FIG. 11A, only the “code” item 1101 is set as the sort key. Therefore, when it is determined that a click instruction has been received for another item not set as a sort key ("category" item 1102 in the figure), the item is added as a sort key item at the lowest priority level, and sort processing is performed. . At this time, the CPU 201 changes the sort icon display process.

  As shown in FIG. 11B, the “code” item 1101 is sorted in ascending order and the “category” item 1102 is sorted in ascending order, and the priority is in the order of “code” and “category”. Since the number of sort items has changed from single to plural in the current process, numbers indicating the priority are displayed in the sort icons as indicated by 1101 and 1102 under the control of the CPU 201.

  FIG. 12 is a diagram illustrating an example of display control of the sort icon when changing the sort direction.

  In FIG. 12A, the “code” item 1201 is set in ascending order, the “classification” item 1202 is set in ascending order, and the priorities are set in the order of “code” and “classification”.

  At this time, when a click instruction is accepted for the “code” item 1201 that is already set as an ascending sort key item, the sort direction of the clicked sort key is changed under the control of the CPU 201 (ascending order → descending order). , Descending order → no sorting: However, if the priority is not the lowest, it is possible to control descending order → ascending order.

  In the example shown in FIG. 12, since the instruction to change the sort direction of the “code” item 1201 that is in ascending order is given, the code is changed in descending order. Accordingly, as shown in FIG. 12 (b), the sort icon is also changed from an ascending order to a descending order. In this case, since only the sorting direction is changed, no change is made in the priority order.

  FIG. 13 is a diagram illustrating an example of display control of the sort icon and the item display column in the sort key priority order changing process.

  FIG. 13A is an example of setting the sorting priority order replacement candidate. When a specific key is pressed in the item display field, the mouse cursor displayed therein is switched in priority order under the control of the CPU 201. The image is changed to a candidate selection image.

  When the “code” item 1301 is clicked, the item is selected as a sort priority order candidate. Accordingly, as shown in FIG. 13B, display control is performed in such a way that the user can visually recognize that the item is a sort priority order change candidate, such as making the display of the item display column different from a normal one. It will be.

  After that, when selection of sort priority replacement candidates is performed on items other than the items set as sort priority replacement candidates (the “category” item 1302 shown in FIG. 13B is clicked). In this case, as shown in FIG. 13C, the “code” item 1301 and the “category” item 1302 are switched in priority, and the sort process is performed based on the new sort order.

  Then, the display of the display item is returned to the normal state display, and the number indicating the priority in the sort icon is changed. Note that the direction of each sort key is not changed.

  As described above, when sorting by a plurality of keys while referring to a data list, it is possible to easily change or confirm the priority of the sort keys through visual means or the like.

  It should be noted that the configuration and contents of the various data described above are not limited to this, and it goes without saying that the various data and configurations are configured according to the application and purpose.

  Further, although one embodiment has been described above, the present invention can take an embodiment as, for example, a system, apparatus, method, program, or recording medium, and more specifically, from a plurality of devices. You may apply to the system comprised, and may apply to the apparatus which consists of one apparatus.

  For example, in the above embodiment, a configuration has been described in which the information processing apparatus 102 performs a sort process on data acquired from the database server 101 and displayed in a table format. However, the target to be sorted may be data (for example, table data) stored in the HDD 204 of the information processing apparatus 102. For example, even if it is a sort process of data displayed in an inbox or a send box of mail software or a sort process of data displayed in a file list or the like, spreadsheet software (for example, Microsoft's (Excel (registered trademark)) display data sort processing or the like.

  Note that when data stored in the HDD 204 of the information processing apparatus 102 is to be subjected to sort processing, information on items set as a sort key when the data is displayed last time, sort direction, priority The ranking or the like may be stored in the HDD 204 as sort setting information in the data or in association with the data. In this case, when displaying the data, the CPU 201 controls to display based on the sort setting information at the time of display.

  The configuration of a data processing program that can be read by the information processing apparatus according to the present invention will be described below with reference to the memory map shown in FIG.

  FIG. 14 is a diagram illustrating a memory map of a recording medium (storage medium) that stores various data processing programs readable by the information processing apparatus according to the present invention.

  Although not specifically shown, information for managing a program group stored in the recording medium, for example, version information, creator, etc. is also stored, and information depending on the OS on the program reading side, for example, a program is identified and displayed. Icons may also be stored.

  Further, data depending on various programs is also managed in the directory. In addition, when a program or data to be installed is compressed, a program to be decompressed may be stored.

  The functions shown in FIGS. 4, 5, 6, 7, and 8 in this embodiment may be performed by a host computer by a program installed from the outside. In this case, the present invention is applied even when an information group including a program is supplied to the output device from a recording medium such as a CD-ROM, a flash memory, or an FD, or from an external recording medium via a network. Is.

  As described above, a recording medium in which a program code of software for realizing the functions of the above-described embodiments is recorded is supplied to the system or apparatus, and the computer (or CPU or MPU) of the system or apparatus is stored in the recording medium. It goes without saying that the object of the present invention can also be achieved by reading and executing the program code.

  In this case, the program code itself read from the recording medium realizes the novel function of the present invention, and the recording medium storing the program code constitutes the present invention.

  As a recording medium for supplying the program code, for example, a flexible disk, hard disk, optical disk, magneto-optical disk, CD-ROM, CD-R, DVD-ROM, magnetic tape, nonvolatile memory card, ROM, EEPROM, A silicon disk or the like can be used.

  Further, by executing the program code read by the computer, not only the functions of the above-described embodiments are realized, but also an OS (operating system) or the like running on the computer based on the instruction of the program code. It goes without saying that a case where the function of the above-described embodiment is realized by performing part or all of the actual processing and the processing is included.

  Furthermore, after the program code read from the recording medium is written in a memory provided in a function expansion board inserted in the computer or a function expansion unit connected to the computer, the function expansion is performed based on the instruction of the program code. It goes without saying that the case where the CPU or the like provided in the board or the function expansion unit performs part or all of the actual processing and the functions of the above-described embodiments are realized by the processing.

  Further, the present invention may be applied to a system composed of a plurality of devices or an apparatus composed of a single device. Needless to say, the present invention can be applied to a case where the present invention is achieved by supplying a program to a system or apparatus. In this case, by reading a recording medium storing a program represented by software for achieving the present invention into the system or apparatus, the system or apparatus can enjoy the effects of the present invention.

  Furthermore, by downloading a program represented by software for achieving the present invention from a server, database, etc. on a network using a communication program and reading it, the system or apparatus can enjoy the effects of the present invention. It becomes.

  In addition, all the structures which combined each embodiment mentioned above and its modification are also included in this invention.

  As described above, according to the present invention, when data is rearranged by a plurality of items, the priority of the data rearrangement item and the visual recognition of the rearrangement direction, and the change of the item priority are displayed. Can be easily performed.

It is a system configuration figure showing an example of the composition of the information processing system in the present invention. 2 is a block diagram illustrating an example of a hardware configuration of a database server 101 and an information processing apparatus 102. FIG. 3 is a block diagram illustrating a functional configuration of the information processing apparatus 102. FIG. 4 is a flowchart showing master data editing processing managed by the database server 101 performed by the information processing apparatus 102. It is a flowchart which shows in detail an example of the list data display process of step S406 of FIG. 5 is a flowchart illustrating in detail an example of an editing process in step S407 of FIG. 7 is a flowchart illustrating in detail an example of a sort key priority change process in step S605 of FIG. 6. 7 is a flowchart showing in detail an example of a sorting direction change process shown in step S606 of FIG. It is a figure which shows an example of the example of a display of a list in case a sort key is single. It is a figure which shows an example of the example of a display of a list when multiple sort keys are set. It is a figure which shows an example of the display control of the sort icon at the time of the addition of a sort key. It is a figure which shows an example of the display control of the sort icon in the case of change of the direction of a sort. It is a figure which shows an example of the display control of the sort icon and the item display column in the case of the change process of the priority order of a sort key. It is a figure explaining the memory map of the recording medium (storage medium) which stores the various data processing program which can be read by the information processing apparatus which concerns on this invention.

Explanation of symbols

DESCRIPTION OF SYMBOLS 101 Database server 102-1 and 102-2 Information processing apparatus 103 Network 301 Control part 302 Display control part 303 Data access part 304 Data management part 305 Input control part

Claims (9)

An information processing apparatus for displaying data composed of a plurality of items ,
First accepting means for accepting a request to set the item of data as a sort key item by an instruction for an area in which the item name in the list of data displayed on the display device is displayed ;
Second accepting means for accepting a request to change the sorting priority of the sort key item by an instruction for an area in which the item name is displayed in the list of data displayed on the display device;
A first control unit that sets an item that has received a request to be set as a sort key item by the first receiving unit as a sort key item, and determines a sorting priority according to an order in which the request is received ;
A determination means for determining presence of a sort key item set as a sort priority replacement candidate;
The sort key item that has received the sort priority change request when there is no sort key item that has already been set as a sort priority replacement candidate when the second receiving means receives a sort priority change request. Is set as the sort priority replacement candidate, and if there is a sort key item set as the sort priority replacement candidate, the sort priority item that received the sort priority change request and the sort priority replacement candidate are set. A second control means for switching the sorting priority with the sorted key item ,
Display control means for displaying data sorted according to the sorting priority determined by the first and second control means on a display device;
An information processing apparatus comprising: The information processing apparatus according to claim 1 , wherein the display control unit displays the sort key items set as sort priority replacement candidates by the second control unit in an identifiable manner. When the sort key item set as the sort priority replacement candidate by the second control unit receives a sort priority change request by the second reception unit, the second control unit selects the sort key item. The information processing apparatus according to claim 1, wherein the setting as an item replacement candidate is invalidated. The information processing apparatus according to any one of claims 1 to 3, wherein the display control means displays the sorting priorities in an identifiable manner. When an item that is not set as a sort key item receives a request to set as a sort key item in the first receiving unit, the first control unit further sets the sort direction of the sort key item that has received a setting request. The information processing apparatus according to claim 1, wherein: When an item that has already been set as a sort key item has received a setting request by the first receiving unit, the first control unit further changes the sort direction of the sort key item that has received the setting request. The information processing apparatus according to any one of claims 1 to 5, wherein the information processing apparatus is characterized in that: The information processing apparatus according to claim 5, wherein the display control unit displays the sort direction in an identifiable manner. An information processing method of an information processing apparatus for displaying data composed of a plurality of items ,
A first accepting step in which a first accepting unit accepts a request to set the data item as a sort key item by an instruction for an area in which the item name in the list of data displayed on the display device is displayed ;
A second accepting step in which the second accepting means accepts a request to change the sort priority of the sort key item by an instruction for an area in which the item name in the list of data displayed on the display device is displayed ;
A first control step in which a first control unit sets an item that has received a request to be set as a sort key item by the first receiving unit as a sort key item, and determines a sort priority according to the order in which the request is received ; ,
A determining step for determining the presence of a sort key item set as a sort priority replacement candidate;
When the second control means accepts the sort priority change request by the second accepting means, and there is no sort key item already set as a sort priority replacement candidate, the sort priority The sort key item that received the change request is set as a sort priority replacement candidate. If there is a sort key item that is set as a sort priority replacement candidate, the sort key item that received the sort priority change request is sorted. A second control step for switching the sort priority with the sort key item set as a priority replacement candidate ;
A display control step for causing the display device to display the data sorted according to the sorting priority determined by the first and second control means ;
An information processing method comprising: An information processing apparatus that displays data composed of a plurality of items ,
First accepting means for accepting a request to set the item of data as a sort key item by an instruction for an area in which the item name in the list of data displayed on the display device is displayed ;
Second accepting means for accepting a request to change the sorting priority of the sort key item by an instruction for an area in which the item name is displayed in the list of data displayed on the display device;
A first control unit that sets an item that has received a request to be set as a sort key item by the first receiving unit as a sort key item, and determines a sort priority according to the order in which the request is received ;
Determining means for determining the presence of a sort key item set as a sort priority replacement candidate;
When the sort priority item change request is received by the second accepting means, and there is no sort key item that is already set as a sort priority replacement candidate, the sort key item that has received the sort priority change request Is set as a sort priority replacement candidate, and if there is a sort key item that is set as a sort priority replacement candidate, the sort priority item that received the sort priority change request and the sort priority replacement candidate are set. A second control means for switching the sorting priority with the sorted key item ,
A program for causing a display device to function as display control means for displaying data sorted according to the sort priority determined by the first and second control means .

Images