Public/New-ServiceNowQuery.ps1
|
function New-ServiceNowQuery{ param( # Machine name of the field to order by [parameter(mandatory=$false)] [string]$OrderBy='opened_at', # Direction of ordering (Desc/Asc) [parameter(mandatory=$false)] [ValidateSet("Desc", "Asc")] [string]$OrderDirection='Desc', # Hashtable containing machine field names and values returned must match exactly (will be combined with AND) [parameter(mandatory=$false)] [hashtable]$MatchExact, # Hashtable containing machine field names and values returned rows must contain (will be combined with AND) [parameter(mandatory=$false)] [hashtable]$MatchContains ) # Start the query off with a order direction $Query = ''; if($OrderDirection -eq 'Asc'){ $Query += 'ORDERBY' }else{ $Query += 'ORDERBYDESC' } $Query +="$OrderBy" # Build the exact matches into the query if($MatchExact){ foreach($Field in $MatchExact.keys){ $Query += "^$Field="+$MatchExact.$Field } } # Add the values which given fields should contain if($MatchContains){ foreach($Field in $MatchContains.keys){ $Query += "^$($Field)LIKE"+$MatchContains.$Field } } return $Query } |