Finding Content Items with missing fields

Rhythmyx Technical Discussion
1

I would like to search for all content items that have a specific field left blank. Is this possible?

2

If this is for an auto-slot, use “rx:fieldname is null” in your where clause

3

It’s not for an auto-slot, but that gave me an idea. I can use the Rhythmyx Query Debugger to find a list of content items I need.

Thanks!

4

Hi Nick

You could also create a Rhythmyx view similar to “Default Folder paths”. This is a backend xml resource which you create using the workbench. It relies on the a SQL query that returns the content id. The benefit being as you updated items in the view they would automatically be removed.

Cheers
James

5

That’s a really interesting idea… I think I might try that method out.

Thanks!