AnsweredAssumed Answered

How to make script to omit multiple criteria

Question asked by PeterMontague on Jun 19, 2012
Latest reply on Jun 19, 2012 by JimMac


How to make script to omit multiple criteria


I am writing a script to export the records in my database.

I want to omit all of the records which are located in bay 14.

So I want all locations with 14A1, 14A2, 14C1 etc to omited. 

I tried omitting, in the script, all of these records by selecting the location field and then entering 14A followed by a carriage return, then 14B etc.

But all of my records, including those from bay 14 were exported. 

I am using an unsatisfacory workaround at the moment. I am exporting all records which have an sku lower than 4000. This excludes the books from bay 14. But also many more.

Any ideas about how I can achieve this?