I'm trying to use the VersionOne rest-1.v1/Data endpoint to find all stories with the string 9.00.00.01
in a particular field. Here's the query (newlines added for readability):
<Server Base URI>/rest-1.v1/Data/Story
?sel=Number,Custom_FixedinVersions
&find=9.00.00.01
&findin=Custom_FixedinVersions
This is returning results which do not show the 9.00.00.01
string in the queried field. For example:
<Asset href="/rest-1.v1/Data/Story/60560" id="Story:60560">
<Attribute name="Number">B-06248</Attribute>
<Attribute name="Custom_FixedinVersions">8.10.00.00-01</Attribute>
</Asset>
What's wrong with my query?
The find
feature of the rest-1.v1 API uses the same underlying capabilities as the Advanced Search feature. Therefore, it has the same limitations as the VersionOne application. Namely, punctuation marks are treated as single-character terms and are excluded from the search query. So the above term 9.00.00.01
is treated as 9 00 00 01
where the search engine matches any of the space-separated values. Therefore, 8.10.00.00-01
matches both 00
and 01
terms.