Trying to show and filter Calcualted Column inside Search Web Parts using Managed properties

Iron Contributor

I have a site calculated column of type Date/Time named "PUETADateTime", which sum up the values from 4 other Date/time calculated columns (but only one of the 4 calculated columns will have value at any time), as follow:-

 
johnjohnPeter_7-1724763363279.png

 

 

Now i want to show and sort this calculated column inside a search web part. so after i added the column >> i added it to a list and added some values >> then i did a re-index to the list and to the site 48 hours ago.

Now i checked the search service, and i found that there is a crawl property that has been created automatically, as follow:-

 
johnjohnPeter_8-1724763385420.png

 

 

but there is not any managed property, so i did those 2 modifications:-

  1. I added a managed property of type text (since the option to create a date/time managed property is disabled) named "PUETADateTimeOWSDATE", and i link it to the crawl property:-
 
johnjohnPeter_9-1724763403923.png

 

 

  1. I edited the "RefinableDate03" managed property >> and i link it to the crawl property, as follow:-
 
johnjohnPeter_10-1724763424625.png

 

 I did a re-index to the list and to the site, 24 hours ago.

but showing and sorting using the above managed properties did not work. here is my case:-

  1. I am showing the manged property "PUETADateTimeOWSDATE" inside a column, and it will be showed as this format which is not a valid date/time:-
 
johnjohnPeter_11-1724763445885.png

 

 

  1. I am showing the "RefinableDate03" inside a column which will be empty, as follow:-
 
johnjohnPeter_12-1724763453552.png

 

 

  1. when i tired to sort using the "PUETADateTimeOWSDATE" managed property, i get an error, which i think is valid since custom manged proprieties are not sort able:-
 
johnjohnPeter_13-1724763461845.png

 

 

  1. now when i tried to sort using the Refinable, i will not get any error, but the sort of the item will not get affected, either Descending or Asending.

so based on my above case, how i can show and sort my calculated column? what i am doing wrong?

0 Replies