Reporting excluding V1.0 but include 11.0

[Karl F-V]

I have been working on some reports in ServiceNow and come across an issue.

I have been reporting on Knowledge articles and looking at the versions, I want to exclude V1.0 but want to ensure that it still includes V11.0

As V11.0 includes 1.0 this is removing all versions 11.0, does anyone have ideas on how to exclude V1.0 but ensures V11.0 are still included.

[Mark Manders]

Version is a reference (1.0 ends up on a kb_version record). You can do an exclude on the sysID of that record. But what exactly are you reporting on? Because some articles may still be on V1.0 and others maybe already on V101.0. 

[Karl F-V]

I am reporting on Knowledge Articles we have along with the versions but i want to look at all the articles which are above version 1.0. None of are articles go up that far as yet, and follow sequence of 1.0 2.0 3.0 etc we do have some which are 8.02.

[Mark Manders]

I think it will work if you query your articles on the dotwalked version field:

kb_knowledge.version.version != 1.0

'version' on the kb_version form is a string, so there 'is not' will work, while on the the kb_knowledge table it's a reference field and 'is not' will filter on a single sysID.