Database Reference
In-Depth Information
Name: 100-20
Parent: 100
Name: 200-20
Parent: 200
Name: 300-30
Parent: 300
If you need accurate information about shared members, you cannot rely on this
overload, but there are plenty of other reasons to use it. For example, this
executeQuery
overload can be used to perform searches and wildcard searches based on the member
name or alias. here is an example of a wildcard search.
// do a wildcard search
selection.executeQuery(null,
IEssMemberSelection.QUERY_TYPE_WILDSEARCH,
IEssMemberSelection.QUERY_OPTION_MEMBERSANDALIASES,
null, "Co*", null);
When you are using
executeQuery
to do searches, the first argument is ignored. The
second argument, in this case, is the numeric constant that specifies that the query
should do a wildcard search of the outline. The third argument,
IEssMemberSelection.
QUERY_OPTION_MEMBERSANDALIASES
, specifies that the query should look for
the base member name both in members and in alias tables. The fourth argument speci-
fies the dimension to which the search should be limited, and if the argument is null as
in our example, all dimensions will be searched. The fifth argument specifies the search
string for the member. If you are doing a wildcard search, you must specify an asterisk
character at the end of the string. The final argument can be optionally used to limit the
search to a specified alias table. note that this example uses the overload that does not
provide member cursoring.
Below are the summarized results of this query. notice how this returns members
from four dimensions including the hidden Attribute Calculations dimension. That is
because we did not limit the search to a single dimension.
Name: COGS
Name: Connecticut
Name: Colorado
Name: Count
Name: 100-10
Name: 100
Another thing you should note about the wildcard search is that the asterisk wildcard
character works only at the end of the search string. What that means is that the APIs do
not support full-text matching or, in other words, using a wildcard character anywhere
in the search string. If you use an asterisk wildcard character anywhere except as the last
character, the API will truncate the characters after the asterisk before performing the
query. As a result, the search will not return the set of members that you expect. In fact,
if you use an asterisk as the first character in the search string, the search will return all
members in the specified dimension, and if you do not specify a dimension, the search
will return all members in the outline.
