→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
HammettMike
Engaged Sweeper III
What sort of inputs are allowed in the filter at the top of a report? I know I can enter various text and it filters that column based on that, but does it accept wildcards or anything else? I haven't been successful at finding something, if it does.
5 REPLIES 5
HammettMike
Engaged Sweeper III
Thank you.
Tom_P
Lansweeper Employee
Lansweeper Employee
Unfortunately, the report filters you are referring to currently do not allow the use of wildcards. We will however add your request to our customer wish list so that it may get implemented in a future release.
HammettMike
Engaged Sweeper III
Here's the area I'm talking about.
HammettMike
Engaged Sweeper III
Not in the SQL statement. In the filter row at the top of the report.
Tom_P
Lansweeper Employee
Lansweeper Employee
As the Report Builder is an SQL Editor, you can e.g. make use of the '%' and '_' wildcards in combination with the 'LIKE' statement. More information on the use of the wildcards can be found here.

The following example filters the assets on the asset type containing 'win':

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.OScode
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tsysAssetTypes.AssetTypename like '%Win%' And tblAssetCustom.State = 1