1

We're trying to use the advanced search in the Content Manager UI in Tridion 2013, and have selected a search based on a schema, and selected a schema field, but want to find all the components where the schema field is blank.

We've tried putting in 'null' and "" in there, but this doesn't seem to work, and the UI won't let us submit the search with no value. Is there a way to query for null/blank instances of a schema field?

Improve this question

1 Answer 1

Reset to default
-1

If the component field is not filled in, it will not show up in XML of the component after the component is saved. To verify the same, try saving the component and view the source. If you do not add any value, the source tab will not even have the field. Only once you add a whitespace or some value, the field starts to show up in the source tab.

Since the field is not even there in the component, Solr cannot search and find the same.

Suggestion

If you add a space in the field and save the component and then search using advanced search options, you will be able to find the same. In advances options for search by schema select the schema and then in the schema field Name search by just hitting a space bar, it will give the component with blank field.

I tried it in Tridion 2013 SP1 and it works fine and finds components where I had given a whitespace in the field.

So, to make them searchable, add a default value to the schema, run component synchronizer so that you don't have to open each component after updating the schema and then Solr will be able to search for the same.

Improve this answer
2
  • Unfortunately this isn't all that helpful, as we're trying to find components where a value hasn't been filled out, so opening all of them and adjusting them is the opposite of what we were hoping for :-/
    – GAG
    Commented Sep 9, 2015 at 12:55
  • I provided details on how Tridion is working and why Solr cannot find it since it is not even in source XML. That is the answer, that without adding a value you cannot search for it AFAIK. I gave a suggestion that by adding a white space you can find it. So, you can change the schema, add a default value (not sure if white space can be added as default value), run the component synchronizer so that you don't have to open each component after adding default value to the schema. Then Solr will be able to find it.
    – Vipin Kothari
    Commented Sep 9, 2015 at 14:29

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.