Apparatus and Method For Retrieving Information From An Application Functionality Table
A computer readable storage medium includes executable instructions to derive a table representing operations associated with an application. One or more parameters are received. A query is executed against the table if the parameters are resolvable with respect to one or more columns in the table. A derived query is constructed based on one or more additional parameters if the parameters are not resolvable with respect to one or more columns in the table. The derived query is executed against the table. A query result is returned.
1 . A computer readable storage medium comprising executable instructions to:
derive a table representing operations associated with an application;
receive one or more parameters;
execute a query against the table if the parameters are resolvable with respect to one or more columns in the table;
construct, as a query against the table, a derived query based on the one or more additional parameters if the parameters are not resolvable with respect to one or more columns in the table;
execute the query against the table; and
return a query result.
2 . The computer readable storage medium of claim 1 , wherein the parameters comprise at least one of an input parameter and an output parameter to the application.
3 . The computer readable storage medium of claim 1 , wherein the columns in the table include at least one of an input column and an output column.
4 . The computer readable storage medium of claim 1 , further comprising executable instructions to map the parameters to the columns in the table to generated mapped parameters.
5 . The computer readable storage medium of claim 4 , further comprising executable instructions to select a query specifying the columns in the table that correspond to the mapped parameters.
6 . The computer readable storage medium of claim 1 , wherein the executable instructions to construct a derived query further comprise executable instructions to prompt a user to specify the additional parameters.
7 . The computer readable storage medium of claim 1 , wherein the executable instructions to construct a derived query further comprise executable instructions to specify a list of hard-coded parameters to resolve the query.
8 . The computer readable storage medium of claim 1 , wherein the executable instructions to construct a derived query further comprise executable instructions to assign a dynamic list of parameters to resolve the query.
9 . The computer readable storage medium of claim 1 , wherein the query is a Structured Query Language (SQL) statement.
10 . A computer readable storage medium comprising executable instructions to:
create a table including a set of input columns and a set of output columns, wherein a record in the table represents a set of inputs and a set of corresponding outputs to an application;
receive an initial query with a parameter that is not resolvable with respect to the table;
construct a derived query for a set of output values based on the set of inputs including the parameter which is not resolvable with respect to the table;
request execution of the derived query against the table; and
receive a query result.
11 . The computer readable storage medium of claim 10 , wherein the table comprises an interface to the application.
12 . The computer readable storage medium of claim 11 , wherein the interface to the application is accessed by using Structured Query Language (SQL) statement.
13 . The computer readable storage medium of claim 1 , wherein the initial query is produced by a semantic layer.