2016-01-10 15:33:23 +03:00
## MIMWAL Change Log
2016-01-10 03:20:59 +03:00
All notable changes to MIMWAL project will be documented in this file. The "Unreleased" section at the top is for keeping track of important changes that might make it to upcoming releases.
2016-01-10 15:33:23 +03:00
### Version [Unreleased]
2016-01-10 03:20:59 +03:00
2016-01-23 12:36:31 +03:00
* Support for multi-valued attributes in `[//Effective]` lookup in AuthZ workflows.
2016-10-28 13:54:23 +03:00
* Implement Approve Request Activity.
2018-03-19 00:38:15 +03:00
* Support for `[//Value]` lookups in Query definitions across rest of the activities.
2019-01-11 10:25:16 +03:00
------------
2020-05-23 23:43:09 +03:00
### Version 2.20.0523.0
#### Added
* New [IndexByValueFunction][IndexByValue] function
* New [CRFunction][CR] function
* New [DateTimeUtcToLocalTimeFunction][DateTimeUtcToLocalTime] function
* New optional culture name parameter to [DateTimeFormatFunction][DateTimeFormat] function
* Added support for WAL Lookup resolution for PowerShellUserName and PowerShellUserPassword properties of [Run PowerShell Script][RunPowerShellScript] activity.
------------
### Version 2.19.0112.0
2019-01-11 10:25:16 +03:00
#### Changed
* [Generate Unique Value Activity][GenerateUniqueValueActivity] now has the Conflict Filter search optimisation logic for the *starts-with* XPath function as documented in the [Wiki ](https://github.com/Microsoft/MIMWAL/wiki/Generate-Unique-Value-Activity#conflict-filter ) turned off by default.
To get the backward compatible behaviour, define the app setting GenerateUniqueValueActivity_OptimizeUniquenessKey = true in the FIMService app.config.
2018-03-19 00:38:15 +03:00
2018-11-10 22:08:58 +03:00
------------
2019-01-11 10:25:16 +03:00
2018-11-10 22:08:58 +03:00
### Version 2.18.1110.0
#### Changed
* [FormatMultivaluedList][FormatMultivaluedListFunction] now accepts all null values.
* [DateTimeAdd][DateTimeAddFunction] now accepts a null value for timespan parameter.
* [ConvertStringToGuid][ConvertStringToGuidFunction] returns Empty GUID if the input is a null/empty string.
* [ConvertFromBase64][ConvertFromBase64Function] returns null if the input is a null/empty string.
* [ConvertToBase64][ConvertToBase64Function] returns null if the input is a null/empty string.
* [ConvertToNumber][ConvertToNumberFunction] returns 0 if the input is a null/empty string.
* [SplitString][SplitStringFunction] returns null if the input is a null/empty string.
* [RemoveDuplicates][RemoveDuplicatesFunction] returns null if the input is a null list.
* [Eq][EqFunction] function will return true if one string parameter is null and other string parameter is Empty
#### Removed
* Removed validation check from RunPowerShellScript activity UI from that the PowerShell User Password is Decryptable as the code runs under the context of submitter instead of FIMService plus the code runs on the Portal Server which may not be co-located with FIMService server.
2018-03-19 00:38:15 +03:00
------------
### Version 2.18.0318.0
#### Added
* [ConvertNumberToList][ConvertNumberToListFunction] function.
* [Multiply][MultiplyFunction] function.
* [Divide][DivideFunction] function.
* [Mod][ModFunction] function.
#### Changed
* [ConvertToString][ConvertToStringFunction] will return null if the input parameter is null instead of throwing an exception.
2016-10-28 13:54:23 +03:00
2017-07-21 05:12:41 +03:00
------------
2017-09-27 12:07:22 +03:00
### Version 2.17.0927.0
#### Fixed
* Bugfix in SortList function.
2017-09-27 12:19:19 +03:00
------------
2017-07-21 05:12:41 +03:00
### Version 2.17.0721.0
#### Added
* Support for Query and Iternation in SendEmailNotification activity.
* [DateTimeFromString][DateTimeFromStringFunction] function.
#### Fixed
* Fixed ParameterValue* functions to return attribute values in the original datatype than as string.
* Correctly setting connection timeout for ODBC connection in ExecuteSqlNonQuery and ExecuteSqlScalar functions.
------------
2017-09-27 12:07:22 +03:00
2017-04-14 12:32:54 +03:00
### Version 2.17.0414.0
2017-03-22 19:11:32 +03:00
#### Added
2017-04-14 12:32:54 +03:00
* Support for executing SQL stored procedures and queries for SQL Server and ODBC Data Sources with the implementation of following new functions:
2017-03-22 19:11:32 +03:00
* New function [CreateSqlParameter][CreateSqlParameterFunction]
* New function [CreateSqlParameter2][CreateSqlParameter2Function]
* New function [ExecuteSqlNonQuery][ExecuteSqlNonQueryFunction]
* New function [ExecuteSqlScalar][ExecuteSqlScalarFunction]
* New function [ValueByKey][ValueByKeyFunction]
2017-07-21 05:12:41 +03:00
------------
2016-10-28 13:54:23 +03:00
### Version 2.16.1028.0
#### Changed
* [FormatMultivaluedList][FormatMultivaluedListFunction] function now supports list of variable lengths as input to format. It also no more expects the list to be of strings. The input can be any object type.
* [ConvertToString][ConvertToStringFunction] function now supports a Guid as input.
2016-01-10 23:31:18 +03:00
2016-01-31 01:05:11 +03:00
------------
2016-07-10 22:52:36 +03:00
### Version 2.16.0710.0
#### Changed
2016-10-28 13:54:23 +03:00
* RunPowerShellScript User for can now be specified in the UPN format. The Domain\UserName or UPN format is also only required if "Impersonate PowerShell User" option is selected.
* Iteration in CreateResource, DeleteResource and UpdateResources activities now re-evaluates not only `[//Value]` expressions but also `[//WorkflowData]` expressions.
2016-07-10 22:52:36 +03:00
#### Added
2016-10-28 13:54:23 +03:00
* [FormatMultivaluedList][FormatMultivaluedListFunction] function now supports more than one list of strings as input to format.
* [ConvertToUniqueIdentifier][ConvertToUniqueIdentifierFunction] now supports a Guid in byte[] format as input.
2016-07-10 22:52:36 +03:00
------------
2016-03-20 21:53:34 +03:00
### Version 2.16.0320.0
#### Changed
* The `[//Request/RequestParameter]` lookup for a SystemEvent request will resolve to request parameters in the parent request.
------------
2016-03-15 10:24:09 +03:00
### Version 2.16.0315.0
2016-03-14 23:15:58 +03:00
#### Added
* Support for Dynamic Grammar Resolution capability to [Update Resources][UpdateResourcesActivity] activity.
* The activity can be configured to resolve / evaluate lookups and expressions in the values returned by the expressions in update definitions. e.g. The string returned by `[//Queries/EmailTemplate/EmailBody]` will be parsed and all lookups will be resolved.
#### Changed
* Use of [EvaluateExpression][EvaluateExpressionFunction] function will now log a deprecation warning in the event log in favour of using the newly implemented Dynamic Grammar Resolution capability of the [Update Resources][UpdateResourcesActivity] activity.
2016-03-15 10:24:09 +03:00
#### Fixed
* Error event logging logic in the [Run PowerShell Script][RunPowerShellScriptActivity] activity.
2016-03-14 23:15:58 +03:00
------------
### Version 2.16.0305.0
#### Added
* Support for dropping hard / soft signs and any other symbols in [NormalizeString][NormalizeStringFunction] function .
#### Changed
* [Run PowerShell Script][RunPowerShellScriptActivity] activity will now only abort the workflow execution when an unhandled or explicit exception is thrown from the PowerShell script. Non-terminating errors in the script will only get logged to the event log.
------------
2016-01-31 01:05:11 +03:00
### Version [2.16.0130.0]
#### Added
* Support for executing a collection of Queries.
2016-10-28 13:54:23 +03:00
* New function [FormatMultivaluedList][FormatMultivaluedList].
2016-01-31 01:05:11 +03:00
* Support for `[//Value]` lookup in Request Actor expressions in CreateResource, DeleteResources and UpdateResources activities.
#### Fixed
* Fixed broken `[//ComparedRequest]` lookup.
* Fix for deleting a definition listing causing deletion / mess up with the remaining listings.
------------
2016-01-16 01:35:43 +03:00
### Version 2.16.0115.0
#### Added
* Support for "/" as a Null Query.
#### Fixed
* Added null check in the ForEachIteration_UntilCondition function of UpdateResources and CreateResource activities to prevent crash when AEC is defined, but Iteration not.
2016-01-31 01:05:11 +03:00
------------
2016-01-16 01:35:43 +03:00
2016-01-10 23:31:18 +03:00
### Version 2.16.0110.0
2016-01-10 15:33:23 +03:00
#### Added
2016-01-10 03:20:59 +03:00
* Re-branded of FIMWAL "2" version 2.15.1016.0 as MIMWAL.
* AICs are updated to a "WAL: " prefix instead of "FIMWAL: ".
2016-01-13 11:28:19 +03:00
* The event log name changed from "FIMWAL" to "WAL".
2016-01-10 03:20:59 +03:00
* Added design time check for the Activity Execution Condition to be a boolean function expression.
* If in FIMWAL "2" you were using an `IIF` function expression as an Activity Execution Condition, you'll need to wrap it around a `ConvertToBoolean` for UI validation to succeed when making any changes to the activity in future.
* Added support to break iteration loop in `UpdateResources` and `CreateResource` activities.
2016-01-13 11:28:19 +03:00
* Reserved `$__BREAK_ITERATION__` for the name of the boolean variable that needs to be set to true to break the iteration loop.
2016-01-10 03:20:59 +03:00
* Added support for cascaded queries lookup so that data from the first query can be used in the XPath search filter expression of the second query.
2016-01-10 15:33:23 +03:00
#### Changed
2016-01-10 03:20:59 +03:00
* Updated `Add` and `Subtract` function to treat null input values as zero instead of throwing exception
* Made substitutions parameter optional in `NormalizeString` function.
2016-01-10 15:33:23 +03:00
#### Removed
2016-01-10 03:20:59 +03:00
* Deleted compiled referenced DLLs and EXEs until LCA provides a split licence.
* Build and Deployment Wiki documents how to gather these files for building the solution.
2016-01-10 15:33:23 +03:00
#### Fixed
2016-01-10 03:20:59 +03:00
* There are no bug fixes in this release.
2016-03-14 23:15:58 +03:00
2018-11-10 22:08:58 +03:00
[AddFunction]: https://github.com/Microsoft/MIMWAL/wiki/Add-Function
[AfterFunction]: https://github.com/Microsoft/MIMWAL/wiki/After-Function
[AndFunction]: https://github.com/Microsoft/MIMWAL/wiki/And-Function
[BeforeFunction]: https://github.com/Microsoft/MIMWAL/wiki/Before-Function
[BitAndFunction]: https://github.com/Microsoft/MIMWAL/wiki/BitAnd-Function
[BitNotFunction]: https://github.com/Microsoft/MIMWAL/wiki/BitNot-Function
[BitOrFunction]: https://github.com/Microsoft/MIMWAL/wiki/BitOr-Function
[ConcatenateFunction]: https://github.com/Microsoft/MIMWAL/wiki/Concatenate-Function
[ConcatenateMultivaluedStringFunction]: https://github.com/Microsoft/MIMWAL/wiki/ConcatenateMultivaluedString-Function
[ContainsFunction]: https://github.com/Microsoft/MIMWAL/wiki/Contains-Function
[ConvertFromBase64Function]: https://github.com/Microsoft/MIMWAL/wiki/ConvertFromBase64-Function
[ConvertNumberToListFunction]: https://github.com/Microsoft/MIMWAL/wiki/ConvertNumberToList-Function
[ConvertSIDToStringFunction]: https://github.com/Microsoft/MIMWAL/wiki/ConvertSIDToString-Function
[ConvertStringToGUIDFunction]: https://github.com/Microsoft/MIMWAL/wiki/ConvertStringToGUID-Function
[ConvertToBase64Function]: https://github.com/Microsoft/MIMWAL/wiki/ConvertToBase64-Function
[ConvertToBooleanFunction]: https://github.com/Microsoft/MIMWAL/wiki/ConvertToBoolean-Function
[ConvertToNumberFunction]: https://github.com/Microsoft/MIMWAL/wiki/ConvertToNumber-Function
2016-10-28 13:54:23 +03:00
[ConvertToStringFunction]: https://github.com/Microsoft/MIMWAL/wiki/ConvertToString-Function
2018-11-10 22:08:58 +03:00
[ConvertToUniqueIdentifierFunction]: https://github.com/Microsoft/MIMWAL/wiki/ConvertToUniqueIdentifier-Function
[CountFunction]: https://github.com/Microsoft/MIMWAL/wiki/Count-Function
2017-03-22 19:11:32 +03:00
[CreateSqlParameterFunction]: https://github.com/Microsoft/MIMWAL/wiki/CreateSqlParameter-Function
[CreateSqlParameter2Function]: https://github.com/Microsoft/MIMWAL/wiki/CreateSqlParameter2-Function
2018-11-10 22:08:58 +03:00
[CRLFFunction]: https://github.com/Microsoft/MIMWAL/wiki/CRLF-Function
2020-05-23 23:43:09 +03:00
[CRFunction]: https://github.com/Microsoft/MIMWAL/wiki/CR-Function
2018-11-10 22:08:58 +03:00
[DateTimeAddFunction]: https://github.com/Microsoft/MIMWAL/wiki/DateTimeAdd-Function
[DateTimeFormatFunction]: https://github.com/Microsoft/MIMWAL/wiki/DateTimeFormat-Function
[DateTimeFromFileTimeUTCFunction]: https://github.com/Microsoft/MIMWAL/wiki/DateTimeFromFileTimeUTC-Function
2017-07-21 05:12:41 +03:00
[DateTimeFromStringFunction]: https://github.com/Microsoft/MIMWAL/wiki/DateTimeFromString-Function
2018-11-10 22:08:58 +03:00
[DateTimeNowFunction]: https://github.com/Microsoft/MIMWAL/wiki/DateTimeNow-Function
[DateTimeSubtractFunction]: https://github.com/Microsoft/MIMWAL/wiki/DateTimeSubtract-Function
[DateTimeToFileTimeUTCFunction]: https://github.com/Microsoft/MIMWAL/wiki/DateTimeToFileTimeUTC-Function
2020-05-23 23:43:09 +03:00
[DateTimeUtcToLocalTimeFunction]: https://github.com/Microsoft/MIMWAL/wiki/DateTimeUtcToLocalTime-Function
2018-03-19 00:38:15 +03:00
[DivideFunction]: https://github.com/Microsoft/MIMWAL/wiki/Divide-Function
2018-11-10 22:08:58 +03:00
[EqFunction]: https://github.com/Microsoft/MIMWAL/wiki/Eq-Function
[EscapeDNComponentFunction]: https://github.com/Microsoft/MIMWAL/wiki/EscapeDNComponent-Function
[EvaluateExpressionFunction]: https://github.com/Microsoft/MIMWAL/wiki/EvaluateExpression-Function
[ExecuteSqlScalarFunction]: https://github.com/Microsoft/MIMWAL/wiki/ExecuteSqlScalar-Function
[ExecuteSqlNonQueryFunction]: https://github.com/Microsoft/MIMWAL/wiki/ExecuteSqlNonQuery-Function
[FirstFunction]: https://github.com/Microsoft/MIMWAL/wiki/First-Function
[FormatMultivaluedListFunction]: https://github.com/Microsoft/MIMWAL/wiki/FormatMultivaluedList-Function
[GenerateRandomPasswordFunction]: https://github.com/Microsoft/MIMWAL/wiki/GenerateRandomPassword-Function
[GreaterThanFunction]: https://github.com/Microsoft/MIMWAL/wiki/GreaterThan-Function
[IIFFunction]: https://github.com/Microsoft/MIMWAL/wiki/IIF-Function
[InsertValuesFunction]: https://github.com/Microsoft/MIMWAL/wiki/InsertValues-Function
2020-05-23 23:43:09 +03:00
[IndexByValueFunction]: https://github.com/Microsoft/MIMWAL/wiki/IndexByValue-Function
2018-11-10 22:08:58 +03:00
[IsPresentFunction]: https://github.com/Microsoft/MIMWAL/wiki/IsPresent-Function
[LastFunction]: https://github.com/Microsoft/MIMWAL/wiki/Last-Function
[LeftFunction]: https://github.com/Microsoft/MIMWAL/wiki/Left-Function
[LeftPadFunction]: https://github.com/Microsoft/MIMWAL/wiki/LeftPad-Function
[LengthFunction]: https://github.com/Microsoft/MIMWAL/wiki/Length-Function
[LessThanFunction]: https://github.com/Microsoft/MIMWAL/wiki/LessThan-Function
[LowerCaseFunction]: https://github.com/Microsoft/MIMWAL/wiki/LowerCase-Function
[LTrimFunction]: https://github.com/Microsoft/MIMWAL/wiki/LTrim-Function
[MidFunction]: https://github.com/Microsoft/MIMWAL/wiki/Mid-Function
2018-03-19 00:38:15 +03:00
[ModFunction]: https://github.com/Microsoft/MIMWAL/wiki/Mod-Function
2018-11-10 22:08:58 +03:00
[MultiplyFunction]: https://github.com/Microsoft/MIMWAL/wiki/Multiply-Function
[NormalizeStringFunction]: https://github.com/Microsoft/MIMWAL/wiki/NormalizeString-Function
[NotFunction]: https://github.com/Microsoft/MIMWAL/wiki/Not-Function
[NullFunction]: https://github.com/Microsoft/MIMWAL/wiki/Null-Function
[OrFunction]: https://github.com/Microsoft/MIMWAL/wiki/Or-Function
[ParametersContainFunction]: https://github.com/Microsoft/MIMWAL/wiki/ParametersContain-Function
[ParametersListFunction]: https://github.com/Microsoft/MIMWAL/wiki/ParametersList-Function
[ParametersTableFunction]: https://github.com/Microsoft/MIMWAL/wiki/ParametersTable-Function
[ParameterValueFunction]: https://github.com/Microsoft/MIMWAL/wiki/ParameterValue-Function
[ParameterValueAddedFunction]: https://github.com/Microsoft/MIMWAL/wiki/ParameterValueAdded-Function
[ParameterValueRemovedFunction]: https://github.com/Microsoft/MIMWAL/wiki/ParameterValueRemoved-Function
[ProperCaseFunction]: https://github.com/Microsoft/MIMWAL/wiki/ProperCase-Function
[RandomNumFunction]: https://github.com/Microsoft/MIMWAL/wiki/RandomNum-Function
[RegexMatchFunction]: https://github.com/Microsoft/MIMWAL/wiki/RegexMatch-Function
[RegexReplaceFunction]: https://github.com/Microsoft/MIMWAL/wiki/RegexReplace-Function
[RemoveDuplicatesFunction]: https://github.com/Microsoft/MIMWAL/wiki/RemoveDuplicates-Function
[RemoveValuesFunction]: https://github.com/Microsoft/MIMWAL/wiki/RemoveValues-Function
[ReplaceStringFunction]: https://github.com/Microsoft/MIMWAL/wiki/ReplaceString-Function
[RightFunction]: https://github.com/Microsoft/MIMWAL/wiki/Right-Function
[RightPadFunction]: https://github.com/Microsoft/MIMWAL/wiki/RightPad-Function
[RTrimFunction]: https://github.com/Microsoft/MIMWAL/wiki/RTrim-Function
[SortListFunction]: https://github.com/Microsoft/MIMWAL/wiki/SortList-Function
[SplitStringFunction]: https://github.com/Microsoft/MIMWAL/wiki/SplitString-Function
[SubtractFunction]: https://github.com/Microsoft/MIMWAL/wiki/Subtract-Function
[TitleCaseFunction]: https://github.com/Microsoft/MIMWAL/wiki/TitleCase-Function
[TrimFunction]: https://github.com/Microsoft/MIMWAL/wiki/Trim-Function
[UpperCaseFunction]: https://github.com/Microsoft/MIMWAL/wiki/UpperCase-Function
[ValueByIndexFunction]: https://github.com/Microsoft/MIMWAL/wiki/ValueByIndex-Function
[ValueByKeyFunction]: https://github.com/Microsoft/MIMWAL/wiki/ValueByKey-Function
[ValueTypeFunction]: https://github.com/Microsoft/MIMWAL/wiki/ValueType-Function
[WordFunction]: https://github.com/Microsoft/MIMWAL/wiki/Word-Function
[WrapXPathFilterFunction]: https://github.com/Microsoft/MIMWAL/wiki/WrapXPathFilter-Function
[MIMWalFunctionsTable]: https://github.com/Microsoft/MIMWAL/wiki/Functions-Table
2019-01-11 10:25:16 +03:00
[GenerateUniqueValueActivity]: https://github.com/Microsoft/MIMWAL/wiki/Generate-Unique-Value-Activity
2020-05-23 23:43:09 +03:00
[RunPowerShellScriptActivity]: https://github.com/Microsoft/MIMWAL/wiki/Run-PowerShell-Script-Activity
