0

locking all records help please

This script works fine apart from fields which are 'empty'.

do as server
    for i in (select 'DOCUMENT REPOSITORY')[LOCKED = true]  do
        i.(LOCKED := false)
    end
end;
alert("All records unlocked")

In other words neither Yes or No.  The field was once 'not required' so a load of records are 'empty' rather than either Yes or No.  Can the above code be modified so that if neither Yes or No it will set Yes if Locking and No if Unlocking.

I have the opposite for vice/versa of course.

2 replies

null
    • Fred
    • 1 yr ago
    • Reported - view

    You can try:

    for i in (select 'DOCUMENT REPOSITORY')[LOCKED = true or LOCKED = null]  do
    
    • Alan_Cooke
    • 1 yr ago
    • Reported - view

    Thanks Fred - as usual my language skills suck.

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 2Replies
  • 55Views
  • 2 Following