Typical task condition statements look like this PowerShell task: Below are example condition statements. Note that you cannot use macro variable format such as $(Build.SourceBranch). Case is ignored on the variable names. Other useful conditions are available from Microsoft. Template Parameter Conditions (From Microsoft documents) Parameter expansion happens before conditions are considered. Therefore, when you declare a parameter… Read More »
Let’s start by saying the PowerShell is one of the most opaque and crappy languages that was ever created. I’m glad some people like it – but as far as me, it sucks. Adding PowerShell to Azure YAML Build Script Adding PowerShell scripts is easy. The example below shows how to create a script with embedded PowerShell code.… Read More »
Use the template below to load the RootID and Guid values for an order if you have the order number. Add your custom code to the “Queries” section. The code shows an example that displays the Settlement Date for the specified order number.
Azure has a tool that is used in many DevOps YAML scripts. It has many capabilities – to the point of wondering why they crammed so many unrelated functions into one construct. All of this information is from a Microsoft Azure DevOps Services page: Logging commands. Check it out because I will not list these options: Show percentage… Read More »
I needed to find where a certain column name was being used. Try this…
Multiple “Order By” Clause Separate the order by clauses with commas. Use “CASE” to Convert Non-String to String Value In this example, we want do display the SettlementType value (an integer) as a human readable value in a column named “Settlement”. Resulting SQL view. Update Row Value The basic command is: For instance:
I keep a bunch of handy code fragments here so I don’t lose them. They are in no particular order. IEnumManager – Get IState, IBillCode, and Many Others You must use IEnumManager to get literally dozens of values that are come from lists that are either maintained inside Select (like IState) or are user editable (such as Bill… Read More »
Windows uses an enumeration of special folder names to make it easier to find commonly used folders. Without this mechanism, we’d have to jump through a lot more hoops to determine this information since it is user dependent. I was trying to use a special folder as the root of a path for some common files shared by… Read More »
File Search Related Operations Microsoft help on items in this section. Find Processes Get-Process (alias gps) allows you to get all running processes on your machine. It can also be used to create a filtered list. Find all processes with name that matches “mmc”. We are looking for an exact match so don’t need double quotes. All of… Read More »
The code below demonstrates how to create an order on a Select Server. The primary difference between clients and servers is that clients are created by a login process that provides a user and profile. Servers do not have profiles by default. Any order created by a Server will show up as created by “System”. I must make… Read More »