Is it possible to use an OR in a query on a text field?
ex:
sg.find("Task",[["step.Step.code","is",["Dept1","Dept2","Dept3"]])
That syntax of course doesn't work but was hoping there was something like it? I don't seem to be able to use "in" [] on a text field.
Thanks!
sg.find("Task",[["step.Step.code","is","Dept1"], ["step.Step.code","is", "Dept2"], ["step.Step.code","is", "Dept3"]], filter_operator='any')
the .find method has a limitation though https://github.com/shotgunsoftware/python-api/wiki/Reference%3A-Methods#wiki-find.
You can't combine AND and ANY operations so you havet to pull all Dept* tasks from db and then filter them by project.
Cheer,
