We have configured publishing service in our environment and we came across with below post. Should we manually add the fields in SOLR managed schema?

isAvailable versionsunrisedate versionsunsetdate publishablefrom publishableto


1 Answer 1


No, you do not need to add these fields to the Solr Managed Schema. This is because these fields in the content database are listed as strings.

There is a dynamic field setting in the Managed Schema that will classify these fields as "strings".

As such, and as listed in the blog post, these fields will automatically appear in the document for the returned items as such:

Snippet of Image from blog post in question

You will still want to make sure that the proper configuration on the CD's are created for your specific Sitecore site. Notice in the blog post that the Sitecore.Publishing.Service.ContentAvailability.config out of the box only contains a configuration for the "website" site, which is Sitecore's default site.

You'll want to make sure you include other sites, as appropriate here.

Edit: The _IsAvailable field is setup as a virtual field in the search query and computed at Runtime. There's a great answer here that explains the difference between Computed Fields and Virtual Fields. You don't need to add it to the schema because the value is not stored in the index itself.

Virtual Fields have draw backs as they can cause queries to be expensive and slow depending on what you are doing.

  • Should we add _isavailable field in schema file?
    – Astle
    Jul 29, 2022 at 15:21
  • 1
    @Astle I've updated my answer to answer your question. Jul 30, 2022 at 0:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.