I've been looking on this board and can't seem to find an answer.

My problem is with searching. I'd like to show records which haven't been modified/checked on a latest build number.

The user will open a record, then check and then select the 'build checked' dropdown to the latest which is set via a valuelist, which I update every build. I wish to find out which records haven't been updated to this build.

I was thinking search as 'Open records' and-not 'build 1.4' where 'build 1.4' would be coming from a versionchecked valuelist/field setable by the search page.

But how would I do this, been puzzling me for a while.

Thanks in advance

How would you do it if the records were pieces of paper?

Manually check the version number against the latest version number, then put them into different piles based on that condition.

See bottom of the search atm there is a :-

<dt><input type="radio" name="-lop" value=AND>

Match all words between fields (AND)</dt>

<dt><input type="radio" name="-lop" value=OR>

Match any words between fields (OR)</dt>

This seems to work for AND or OR but doesn't work for NOT.. the condition I want to do is if record is OPEN and+not LATEST VERSION then display the records.

If I understood the scripting a bit more maybe that would allow me to do this, but currently I don't.