Forum Discussion
Use of custom columns in eDiscovery Queries
Hello Purview Experts,
Does anyone know whether or not it is possible to build queries in a Purview eDiscovery Search that query (and return) custom SharePoint columns? What we need to be able to do is define a query similar to this:
(contenttypeid:0x0101007707E42DD710C842898595819673FA19*) AND (LastModifiedTime > SomeCustomDateProperty)
The SomeCustomDateProperty is a custom SharePoint property we have added to our content type and which appears in the Search Schema/Index. We would then also like to be able to have both the LastModifiedTime and the SomeCustomDateProperty included in the export file for all versions that we generate from the eDiscovery search.
Is this possible? If so, what is needed to set this up? Does the Search Schema need to be modified and if so, how? What is the format of the query to be defined in Purview to get this to work? When we try to set up the above, we always get syntax errors to where we are unable to save.
Any thoughts/ideas appreciated ...
Afaik no. While you can expose custom properties for search via RefinableStringXX, the values you can search against need to be preset. You cannot dynamically compare property values.
Thank you. Do you know if it's possible to somehow include custom properties like SomeCustomDateProperty when you generate an export of search results via Purview? Or are we just limited to the default properties that seem to be hardcoded ?
Don't think so, you'll have to query them outside of the eDiscovery experience.
