Query items by custom field

[JamesGreen]

Hi guys,

I was hoping to query our Vault Pro 5 (5.1.2) instance for work items where the value of custom field #1 is blank.

The idea was to query for all the items where this value has not been entered. I have tried expressions like <> '' etc but they always return no results.

Could you please help me out with what expression to use when querying items to get all the items where custom field #1 is blank?

Cheers
James

[Beth]

There currently isn't a way to query on keywords that are not present or blank. I can put in a feature request for this functionality.

In the meantime, I can send you a work-around. Could you send an email to support at sourcegear.com (attn: Beth) with a link to this forum thread?

F: 16503

[JamesGreen]

A feature request would be great, thanks!

My use case is the custom #1 field is being used to store a reference number for another internal system. The way we are using it this field is not required for all issues, but I would like to check each week or so that where it is applicable it has been filled in (and not forgotten)

Thanks for a quick reply
James

[Beth]

You're welcome.