New Or Improved Features

1. If the search index is a Solr index, you can order your query results not only by Name, Relevance and "Updated Date" but also by other property types:
   • System attributes. Note: Only the system attributes that are stored in the search index can be used as the order by fields. Besides multi-valued system attributes such as "Data Classifications" or object-valued system attributes such as "Column Statistics" cannot be used as an order by field
   • Custom attributes. Note: Custom attributes of the Enumeration (Multi-value), Users, Rich Text, Blob or Multiline Text type cannot be used as an order by field. Order by a custom attribute of the User data type returns the results sorted by the user ids not by the usernames.
   • Profile attributes
   • Data Profiling attributes except the multi-valued attribute "Data Profiling"."Inferred Data Types"
   • UDPs

You can have more than one order by field in the Order By clause. Each field can be a property type in the above list with its own asc(ending) or desc(ending) order. For example, "Last Name" asc, "First Name" desc. This sorts everything by "Last Name" in the ascending order first and then by "First Name" in the descending order whenever the "Last Name" property for two or more objects are identical.

2. New system attributes are added: Model, "Source System Definition", "Data Select Method", "Data Select Query", "Replication Quality", "Imported Date", "Import Bridge", "Source System Popularity", Source, Destination, "Data Quality Latest Status", "Data Quality Latest Score", "Data Quality Latest Date", "Mentioned Objects", "Mentioned Users", "Source Model" and "Destination Model" etc.
3. The system attribute "Business Name" is now a custom attribute of an imported object (e.g. Table)
4. The system attribute "Content Name" is renamed to "Model Name", and "Content Description" to "Model Definition". The system attribute "External URL" is renamed to "Open In Tool". The system attribute "Description" is renamed to "System Description". "Description" replaces the custom attribute "Long Description" as HTML formatted text of unlimited length that can include images, tables, etc.
5. The filter type CONTENT is converted to a system attribute Model.
6. Support of binary complex relationships in the SELECT list and WHERE clause.
7. Support of faceting on certain system attributes, data profiling attributes, profile attributes, and custom attributes if the search index is a Solr index.
8. Support of subquery =WHERE(<subquery>) or !=WHERE(<subquery>) filters on the system attribute Model, "Mentioned Objects" or custom relationship.
9. Support of count('Relationship') in the SELECT list and WHERE clause.
10. Added "Data Profiling".Null, "Data Profiling".Blank and "Data Profiling".Zero.