function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
ChigurhChigurh 

Chatter News Alerts search criteria

When using Chatter News alerts, I was wondering if I can add multiple search terms using "and" and" or" to combine terms to limit the stories.

 

An example: Anadarko+(Petroleum OR Offshore)

 

When I use this criteria in regular google alerts, it works correctly.  News with Anadarko AND at least one of the other terms.

 

But when i put the same criteria into Chatter News alers search field, I get nothing.   Any help?

 

 

 

IspitaIspita

Hi,

Let just take the example given by you and see what can be done about it...

 

You can try using the "LIKe" operator as below:-

 

  • The % and _ wildcards are supported for the LIKE operator.
  • The % wildcard matches zero or more characters.
  • The _ wildcard matches exactly one character.
  • The text string in the specified value must be enclosed in single quotes.
  • The LIKE operator is supported for string fields only.
  • The LIKE operator performs a case-insensitive match, unlike the case-sensitive matching in SQL.
  • The LIKE operator in SOQL and SOSL supports escaping of special characters % or _.
  • Do not use the backslash character in a search except to escape a character.
For example, the following query matches Appleton, Apple, and Bappl , but not Appl:
 SELECT AccountId, FirstName, lastname FROM Contact WHERE lastname LIKE 'appl_%'
Try this :-
Select  body from feeditem where body like ' %Anadarko%' and body in ( '%Petroleum%' , '%Offshore%')

Hope this helps ...