Fourth Quarter of 2022

Release Date: December 13, 2022

This topic provides a list of product changes released for this module on this date.

Table 1. Enhancements and New Features

The following enhancements and new features have been added.

DescriptionTracking ID
Since Oracle databases do not support date math by year ('yy') or month ('mm') with time stamps enabled, the DateAdd function for Oracle databases will now use 365.25 days for years and 30 days for months.US563265
The following changes have been made to the Advanced section of the Expression Builder window:
  • To improve usability when creating query expressions, the functions unique to the databases are no longer displayed in the Functions section. Irrespective of the type of database that you use to access APM, you can now access all the supported functions from the Functions section.
  • The following functions have been added:
    • Case: Evaluates the conditions (that are, If, Then, and Else) in a query expression and returns results when a condition is met.
    • Rank: Assigns a rank to each row within a partition of query result.
    • Reverse: Reverses a query string and returns the result.
US457466
The following parameters are now supported for creating expression syntax for the MI DatePart and DATEPART functions:
Date ComponentParameter
Dayd, dd, day
Day of yeary, dy, dayofyear
Hourhh, hour
Minuten, mi, minute
Monthm, mm, month
Quarterq, qq, quarter
Seconds, ss, second
Weekwk, ww, week
Weekdaydw. weekday
Yearyy, yyyy, year
DE143708
Table 2. Resolved Issues

The following issues, which existed in one or more previous versions, have been resolved.

DescriptionTracking ID
Previously, when you deleted a query column that was included in the query clause, and then attempted to run and export the query results, an error occurred. This issue has been resolved. DE184300
Previously, when you created a query with several parameters, which included single-value and multi-value parameters, the query sometimes did not return any data, and the graph using the query did not display any results. This issue has been resolved.DE181800
Previously, when you used a hyperlink in a query to build links using multi-value parameters, the first two parameters were incorrectly encoded. Due to this, the parameter values were not passed as expected. This issue has been resolved.DE180641
Previously, while creating a query, when you added a family, and selected the Fields filter button in the Design workspace, the filter options were always visible, even if you navigated back to the previous page. This issue has been resolved.DE180619
Previously, when you attempted to select a query in the Asset Group page, if the query path contained any special characters, an error occurred. This issue has been resolved.DE180782
Previously, if you attempted to run a crosstab query using a conditional alert, an error occurred. This issue has been resolved.DE179635
Previously, if a column in your query result contained special characters, such as the equal sign (=), percent (%), or ampersand (&), and you ran the subquery associated with that column via a hyperlink, the subquery did not return any result. This issue has been resolvedDE177644
Previously, if you ran a query containing a union operator and a column having null values, and then applied a filter on the query results, an error occurred. This issue has been resolved. DE154094
Previously, if the results of a crosstab query contained only one column, and you attempted to export the results, an error occurred. This issue has been resolved.DE147190
Previously, when you created a query that uses another query as its source, and if the source query had another query at the parent level, an error occurred in the following scenarios:
  • You added a field to the query
  • There was a space in the column alias name
These issues have been resolved.		DE108925
Previously, in the Results workspace, when you right clicked the column header and then selected the sort order to sort multiple columns in the query results, the sort order was not displayed. This issue has been resolved.DE176433
Table 3. Known Issues and Limitations

The following known issues and limitations exist.

DescriptionTracking ID
When a value in your query result contains the ampersand (&) and equal (=) characters (for example, "A&B=C"), and you use that value as a parameter in a hyperlink, the hyperlink may not work as expected.DE180641
Table 4. Obsolete Features

The following features are no longer available.

DescriptionTracking ID
In the Expression Builder window, the following redundant functions are no longer available to create query expressions:
  • ACOS
  • ASCII
  • ASIN
  • ATAN
  • ATAN2
  • CEIL
  • CEILING
  • CHAR
  • CHARINDEX
  • CONVERT
  • COS
  • COSH
  • COT
  • EXP
  • GREATEST
  • INITCAP
  • INSTR
  • LAST_DAY
  • LEAST
  • LN
  • LOG
  • LOG10
  • LPAD
  • MI_DateAdd
  • MI_DatePart
  • MOD
  • MONTHS_BETWEEN
  • NEW_TIME
  • NEXT_DAY
  • NVL
  • PATINDEX
  • POWER
  • RAND
  • REPLICATE
  • REPLACE
  • RPAD
  • SIN
  • SOUNDEX
  • SPACE
  • SQRT
  • STDEV
  • STUFF
  • TAN
  • TANH
  • TRANSLATE
  • TRUNC
  • VARIANCE
  • VAR
US457466

Release Date: November 18, 2022

This topic provides a list of product changes released for this module on this date.

Table 5. Resolved Issues

The following issues, which existed in one or more previous versions, have been resolved.

DescriptionTracking ID
Previously, when exporting a query result, the export process occurred in the same workspace, and you were unable to perform any other task until the export was completed. This issue has been resolved. Now, the query export opens in a new window. DE184969