Using ISHRemote can I filter results where Version is less than or equal to a value?

Question

Hi, 
 The Version metdata field for an ISHModule object is of type string. 
 Is there any workaround in ISHRemote to find results where Version is lessthan or equal to an integer value e.g.. 
 $metadataFilterLang = Set-IshMetadataFilterField -Level Lng -Name DOC-LANGUAGE -FilterOperator NOTIN -Value 'en-US' | Set-IshMetadataFilterField -Level Version -Name VERSION -FilterOperator LE -Value $version 
 Any advice appreciated, 
 Regards, 
 Ann

Dave De Meyer · Answer

ISHRemote is a PowerShell client layer on top of the public API of the Tridion Docs Content Manager product. In turn ISHRemote can only passthrough what the API has to offer 
 
 https://docs.rws.com/1151795/68174/tridion-docs-main-documentation/understanding-metadata-filter-operators indicates the field types and their operators... which are what you see in Set-IshMetadataFilterField. Here you can see there is no VERSION type field. 
 Some API calls have heavy lifting server-side on how to handle VERSION, especially finding latest version on main or branch. As background see https://docs.rws.com/1151795/68239/tridion-docs-main-documentation/understanding-how-version-numbers-behave 
 
 So as VERSION is a STRING field, that contains main versions like 1, 2, 3, etc or branch versions like 4.3.2 (read it as version 4 has 3 branches, 2nd version on that branch). So you have two options 
 
 Server-side filtering on STRING field VERSION, you can use the operators as mentioned. Theoretically, in your case at best equal, not equal or clike operators... but greather-than and alike were not implemented for STRING. 
 Client-side filtering
 
 If you only expect integer versions, then cast to [int] where comparisons like 10 > 9 is handled nummerically and not alphabetically... [int]$ishobject.version_version_value 
 If you have branches on branches like 4.3.2.7.6.8 and more, then you need to write your own compare. There is nothing available on the internet to handle this.

... perhaps there are other dimensions you could consider like creation date, security, to keep the list to process small. 
 
 Best wishes, Dave

Tridion Docs Developers > 03 - Developer Forum

Using ISHRemote can I filter results where Version is less than or equal to a value?