condition

I took a look through the rules group, but wasn't able to find anything relevant to my question. . .

I'm trying to make a rule to publish content if the user has the role "editor" for and is the member of the group the content is in.

It works fine when the user is editing a piece of content (node), but when creating a new piece of content, the "member of group" part of the test fails. From the code in "og.rules.inc", it looks like the test is failing because the node doesn't have a node id yet, but the content should know what groups it's in before that, right?

I am looking for a way to use sql query in condition of rule - if sql query returns something - proceed with rule, if it returns nothing - skip rule. Can anyone suggest way to go in this case? Thanks.