Method, apparatus, and system for searching based on search visibility rules
According to one aspect of the present invention, a method is provided in which a search request containing search criteria is received from a first user. A search is performed based upon the search criteria and the first user's organizational identifier to identify data records that match the search criteria and to which the first user is allowed to access based upon the first user's organizational identifier. In another embodiment, a search is performed based upon the search criteria and a list of categories to which the first user is authorized to access to identify records that match the search criteria and to which the first user is allowed to access based upon the list of categories.
1. A method comprising:
providing a set of predetermined search categories for display to a user;
associating each predetermined search category of the set of predetermined search categories with a corresponding indexed set of records by:
generating a first indexed set of records corresponding to a first predetermined search category, wherein said generating the first indexed set of records comprises
selecting one or more fields of a database table,
generating a search table corresponding to the database table, wherein
columns of the search table correspond to the selected one or more fields, and
adding a visibility column to the search table, wherein
the visibility column comprises one or more identifiers of organizations authorized to access each record in the search table;
receiving, from the user, selection of a selected search category and a search key for searching;
generating a query comprising the search key and an organizational identifier of the user;
performing the query on an indexed set of records corresponding to the selected search category; and
providing results of said performing the query to the user.
2. The method of claim 1 wherein said performing the query further comprises:
selecting a subset of the indexed set of records by comparing the organizational identifier of the user with the one or more organizational identifiers associated with each record; and
searching the subset of the indexed set of records using the search key.
3. The method of claim 1 wherein the results of said performing the query comprise data stored in records of the indexed set of records selected by said searching.
4. The method of claim 1 wherein the results of said performing the query comprise data pointed to by records of the indexed set of records selected by said searching.
5. An apparatus comprising:
means for providing a set of predetermined search categories for display to a user;
means for associating each predetermined search category of the set of predetermined search categories with a corresponding indexed set of records that further comprises
means for generating a first indexed set of records corresponding to a first predetermined search category, wherein said means for generating the first indexed set of records comprises
means for selecting one or more fields of a database table,
means for generating a search table corresponding to the database table, wherein
columns of the search table correspond to the selected one or more fields, and
means for adding a visibility column to the search table, wherein
the visibility column comprises one or more identifiers of organizations authorized to access each record in the search table;
means for receiving, from the user, selection of a selected search category and a search key for searching;
means for generating a query comprising the search key and an organizational identifier of the user;
means for performing the query on an indexed set of records corresponding to the selected search category; and
means for providing results of said means for performing the query to a user.
6. The apparatus of claim 5 wherein said means for performing the query further comprises:
means for selecting a subset of the indexed set of records by comparing the organizational identifier of the user with the one or more organizational identifiers associated with each record; and
means for searching the subset of the indexed set of records using the search key.
7. A computer readable storage medium comprising:
a first set of instructions, executable by a processor, configured to provide a set of predetermined search categories for display to a user;
a second set of instructions, executable by the processor, configured to receive, from the user, selection of a selected search category and a search key for searching;
a third set of instructions, executable by the processor, configured to generate a query comprising the search key and an organizational identifier of the user;
a fourth set of instructions, executable by the processor, configured to perform the query on an indexed set of records corresponding to the selected search category;
a fifth set of instructions, executable by the processor, configured to provide results of said performing the query to the user;
a sixth set of instructions, executable by the processor, configured to associate each predetermined search category of the set of predetermined search categories with a corresponding indexed set of records; and
a seventh set of instructions, executable by the processor, configured to generate a first indexed set of records corresponding to a first predetermined search category, wherein the sixth set of instructions comprises
a eighth set of instructions, executable by the processor, configured to select one or more fields of a database table,
a ninth set of instructions, executable by the processor, configured to generate a search table corresponding to the database table, wherein
columns of the search table correspond to the selected one or more fields, and
a tenth set of instructions, executable by the processor, configured to add a visibility column to the search table, wherein
the visibility column comprises one or more identifiers of organizations authorized to access each record in the search table.
8. The computer readable storage medium of claim 7 wherein the fourth set of instructions further comprises:
an eleventh set of instructions, executable by the processor, configured to select a subset of the indexed set of records by comparing the organizational identifier of the user with the one or more organizational identifiers associated with each record; and
a twelfth set of instructions, executable by the processor, configured to search the subset of the indexed set of records using the search key.
9. The computer readable storage medium of claim 7 further comprising:
a thirteenth set of instructions, executable by the processor, configured to provide results of the fourth set of instructions.