Wildcards and symbols for searching in standalone Data Marketplace
In the Data Marketplace search field, you can enter your search terms and use wildcards and symbols.
- If you want to search for all assets, type * in the search field.
- If you want to find something, but are not quite sure of the name, you can use the following wildcards in your search terms:
Wildcard Description Example ? A question mark replaces any single character. Search term: ?ar
Possible results: Car, Bar, Tar.* An asterisk replaces any string of characters. Search term: C*r
Possible results: Car, Crosshair, and so on. - If you want to find a literal piece of text, you can add the terms between double quotation marks.
Don't forget to close the quotation marks. If you add only one, you receive an error message. This also applies to brackets[]
,{}
, and()
.Example By typing "Tax Statement" you can find Tax Statement 2017, but not Tax or Statement.
- If you want to search based on a database structure, start your search with sql: [database].[schema].[table].
Each time you add a .[search term], Data Marketplace searches for the value you entered and shows the result as a search suggestion.Note The SQL search only works if the Database, Schema, and Table asset types are part of the Data Marketplace scope.