DataSets
InsertSearchBox
insert a search form into the worksheet
Calling Sequence
Parameters
Description
Examples
Compatibility
InsertSearchBox()
InsertSearchBox(options)
options
-
(optional) keyword options of the form assign = n or search = s, where n is a name or string and s is a string
The InsertSearchBox command embeds an interactive search form into the worksheet.
If the assign = n option is given, then the search results are assigned to the global name n. If the assign = n option is not given, then an unused global name is generated and the search result is assigned to that name.
If the search = s option is given, then the search form automatically searches for s upon insertion.
Any changes made to the search form result in the designated name (n) being automatically reassigned the new reference object specified by the search form.
For example, in the following example a search form is inserted with canpop being the name to which results are assigned. If canpop is changed to canpop2, then canpop2 will be assigned a reference object of equal value. If the year of the start date is then changed to 2000, then canpop2 will be assigned a reference object that will only retrieve data from the year 2000 onwards, while canpop remains unchanged.
Automatic reassignment happens after changing the assignment name, searching, changing the page, selecting a data set, changing the start or end dates, changing the frequency, or changing columns.
Column selection is only available for data sets with ten or fewer columns. All columns must be included for data sets with more than ten columns.
The search form can recover after a restart and can be copied into other worksheets, or even the same worksheet, and act as independent search forms.
with⁡DataSets:
InsertSearchBox⁡'assign'='canpop','search'=Canada Population
The first search result is now automatically assigned to the name canpop.
canpop
The DataSets[InsertSearchBox] command was introduced in Maple 2015.
For more information on Maple 2015 changes, see Updates in Maple 2015.
See Also
DataSets[Reference]
DataSets[Search]
Download Help Document