Filtering of Reports in the Web Interface

[HammettMike]

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.

[HammettMike]

Thank you.

[Tom_P]

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]

Here's the area I'm talking about.

[HammettMike]

Not in the SQL statement. In the filter row at the top of the report.

[Tom_P]

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