OR Operator in SOQL with Castiron

Question

I'm facing an issue while creating a SOQL from within Castiron Studio 7.0.0.2

SELECT Id FROM Account
WHERE
Field_Feed__c = 'particular flag value'
**OR**
RecordTypeId = '012400000009ae1'

The OR operator just doesn't work. And when I say it doesn't work I mean I can't even validate the query, because I get a syntax error

But, but, but if I put

SELECT Id FROM Account
WHERE
Field_Feed__c = 'particular flag value'
**AND**
RecordTypeId = '012400000009ae1'

it works fine. Why it doesn't with OR? What am I missing?

Thanks

Answer 1

Studio version 7.0x has lots of internal bugs and most unstable version. I am using cast iron studio version 7.5.1.0, the most stable version of IBM CastIron/AppConnect till now. This version doesn't have any SOQL related issues which you mentioned in this post. Attaching my studio screenshot, which validates the query without any error.

Download link: Studio Download Link 7.5.1.0

SOQL Screenshot

Answer 2

I could not figure this out, in all honesty this issues doesn't make any sense at all. So what I did was to add a Filter and Profile activity, and in there I placed all my logic ORs. Crappy Castiron.