Useful Examples

search by e mail address use the email addresses email addresses link to search all e mail addresses, not only the primary ones searching e mails by e mail addresses it is necessary to explicitly search the e mail address on the from , to , cc or bcc links here is an example of searching for e mails e mails having "sarah" "sarah" in either the from or to fields searching by tags search by the name name field on the tags tags link searching for favorites search for records that have a non empty favorite favorite link searching for records that you follow search for records that have a non empty following following link searching multi select fields use the contains contains operator searching for records related to a particular record to search for records related to a particular record, it is first necessary to determine the id of this particular record for instance, if you wanted to search for calls calls related to account account abc inc , you would first need to find the id of abc inc you can learn how to do this faq docid\ w qrkderlew3wrpt zmuc once you've got the id, it's simply a matter of querying the id field on the appropriate relationship assuming the id of abc inc was b582e48a b5ea 11ed 9a54 0242ac1b0002 b582e48a b5ea 11ed 9a54 0242ac1b0002 , this is how we would search for calls calls that are related to this account account searching for my records there are two ways you can include a "my records" condition to your query, depending on what you need to achieve if you simply need to apply a query and and also filter the resulting records to only contain those assigned to you, you can simply use the existing my records my records filter, which will automatically be combined with your query using and and if you need to build more complicated queries, such as involving or or , you will first need to find out the id of your user to do that, navigate to your profile, and copy it out of the address bar it will be located right after records= , as seen in the picture below once you have that, you can search by the assigned user name assigned user name link, and combine it with whatever you need searching for other users' records in this case, the process is very similar to useful examples docid 4z206vs3o6oyffkvfwr1l you again have the option of combining your query with built in filters using and and alternatively, you can determine the ids of the users you need to search by as with your own id, this can be copied from the address bar in the employees employees module, after selecting the user you're interested in this can then be used analogously to useful examples docid 4z206vs3o6oyffkvfwr1l searching for minimal and maximal records using a trick, it is possible to retrieve records that are the "largest" or "smallest" by some numerical field for instance, you can use this to search for the most valuable opportunities opportunities of each account account the trick relies on the fact that the largest/smallest record is always larger /smaller than or equal to all other records here's how you would list the most valuable opportunities of each account to find the least valuable opportunity, the query is analogous, except with <= <= searching for single records a similar trick to useful examples docid 4z206vs3o6oyffkvfwr1l can be used to find records where only a single related record exists this trick relies on the fact that if there is only a single record, \<all!> \<all!> record ids are equal to each other here are all accounts accounts which only have a single opportunity opportunity careful, the \<all!> \<all!> fields & links docid\ kzbtllyb4xfj8df290vxi