This is my blog about SharePoint. I add interesting things that I discover about SharePoint, and “how to’s”. I really love SharePoint, and this is where I add my two cents about it. Adding to the collaboration community.
I am a SharePoint Solution Specialist. I architect, configure, improve and develop Enterprise Content Management and Web Content Management Solution with Microsoft SharePoint Server.
Just had some fun and games with the SharePoint Content Search Web Part (CSWP). I create some content, list and pages, all with there own content type. I was able to view the column "Title" content in the CSWP display, but not able to Sort by "Title" or have it as a Refiner.
I used one of the RefinableString Managed Property. It was tricky to figured out which Mapped crawled property was the correct "Title". These are the ones that worked for me, for my current project.
Mapped crawled property for:
List - Basic:displaytitle
Page - ows_Title
I found the most awesome PowerShell script which generates a csv of all the permission access within a SharePoint site. It works so well.
One of the biggest issues in SharePoint, is access. Making sure the right people have the right access to the right things, and more importantly the wrong people don't have access. But SharePoint doesn't give you a good overview of this information. This is why this script is so nice. Its shows, who has access, and where, and with what level.
Original Article from Microsoft SharePoint TechNet:
With SharePoint Online you can’t create a New mapped search column as simply as SharePoint On-Prem. With SharePoint Online it is best to use one of the pre-created mapped search columns, created for you, by SharePoint to use. I.e. RefinableString, RefinableDate, RefinableInt and RefinableDecimal.
For this example I will be Mapping this column, for my whole SharePoint Online environment, so all my Site Collection can access this Search Mapped Column.
Goto your SharePoint Online Admin Center
Click "search" on the quick links menu (on the left)
Filter by "refinabledate"
You can see that this column is already for searching, and has been configured to be a "Date and Time" column type
Add an Alias to this column. This will inform other and "future you", what this column is for.
Scroll down to "Mapping to crawl properties", and click "Add a Mapping"
Find "Search for crawled property name": Expires
To see the column mapped, filter again by "refinabledate"
Now you just have to wait for the SharePoint Online Crawl to run :)
So in this example, I have a list of Announcements. These Announcements have an Expiry Date. This Expiry Date column can be blank or have a date.
The Content Search Rollup must show all item which has a future Expiry Date, or are blank.
Note: The column which is being used to compare the date, must be a mapped in the Search Schema as a DATE (Date and Time) column. Note: The default “Expires” column is not automatically mapped, by the Search Schema. There is a mapped column called “ExpiresOWSDATE”, but this column is mapped as text.
The reason this is such a cool rule, is because it show items with Blank Dates.