Searching and Filtering

The SQLite provider supports native (SQLite-based) filtering through the use of the -filter parameter in various item cmdlets. For example, this command searches a table for records with a username field value of 'Beefarino':

PS> get-childitem mydb:/Users -filter"username='Beefarino'"

The syntax of the filter parameter is open to the syntax supported by the
SQLite WHERE clause. You can create very powerful search using very little PowerShell. This example finds all users with the letter 'f' in their username:

PS> get-childitem mydb:/Users -filter"username like '%f%'"

The -filter parameter is supported on these SQLite provider cmdlets:

get-childItem

get-item

set-item

remove-item

This example updates the Status field for all records where the username starts with 'Beef':