Parse Error at char(35): Parse Error
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I keep receiving this error message and I'm not sure what the fix is.
Please advise! Thank you.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @kimberlyka you need put 'OR' after any expression, like this
[Field1]='A' OR [Field1]='B' OR [FIELD1]='C' etc etc etc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
After applying 'OR'
[COUNTERPARTY_CATEGORY] = "3rd_Pty"OR [COUNTERPARTY_CATEGORY] = "Interco_Non-IHC"
OR[COUNTERPARTY_CATEGORY] = ' '
OR[TEMPLATE_NAME] = "Derivatives"
OR[TEMPLATE_NAME] = "Other_Assets_Liab"
OR[TEMPLATE_NAME] = "Banking_Book_Securities"
I now receive "Parse Error at char(26): An operator must be between operands"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you share your workflow?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I think you just need to add a SPACE after each OR operator (and before).
[a] = [b] OR [b] = [c] <-good
[a] = [b]OR[b] = [c] <-bad
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I tried to do it this way but it didn't work either but before this it was:
[COUNTERPARTY_CATEGORY] ="3rd_Pty" OR " [COUNTERPARTY_CATEGORY]="INTERCO_NON-IHC" OR [COUNTERPARTY_CATEGORY]=" " AND[TEMPLATE_NAME]="DERIVATIVES" OR [TEMPLATE_NAME]= "OTHER_ASSETS_LIAB"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
[COUNTERPARTY_CATEGORY] ="3rd_Pty"
OR
[COUNTERPARTY_CATEGORY]="INTERCO_NON-IHC"
OR
[COUNTERPARTY_CATEGORY]=" "
AND
[TEMPLATE_NAME]="DERIVATIVES"
OR
[TEMPLATE_NAME]= "OTHER_ASSETS_LIAB"
Try the above out. Your original had an unnecessary " after the first OR and there was also an AND operator that was missing a space afterwards.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If I only put one option does it work?
[COUNTERPARTY_CATEGORY] ="3rd_Pty"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @kimberlyka ,
As @jrgo said, the only problem are the spaces between your AND OR logics. I have only added a space after your AND and also an additional quote.
[COUNTERPARTY_CATEGORY] ="3rd_Pty" OR [COUNTERPARTY_CATEGORY]="INTERCO_NON-IHC" OR [COUNTERPARTY_CATEGORY]=" " AND [TEMPLATE_NAME]="DERIVATIVES" OR [TEMPLATE_NAME]= "OTHER_ASSETS_LIAB"
Best,
Fernando Vizcaino
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You may also need to group your conditions. Mixing an AND with an OR without grouping may not work as intended. Here's an example:
[COUNTERPARTY_CATEGORY] ="3rd_Pty"
OR
[COUNTERPARTY_CATEGORY]="INTERCO_NON-IHC"
OR
[COUNTERPARTY_CATEGORY]=" "
AND
(
[TEMPLATE_NAME]="DERIVATIVES"
OR
[TEMPLATE_NAME]= "OTHER_ASSETS_LIAB"
)
