Changes

Jump to navigation Jump to search
3 bytes added ,  14:50, 23 January 2020
Line 93: Line 93:  
== Using search strings in filters ==
 
== Using search strings in filters ==
   −
When app users use the filter function in a view, they can use only the fields of the viewed entity as filter criteria. For example, on the Opportunity view, you can filter records by Customer or Estimated Revenue, because both are fields of the Opportunity entity. However, you cannot filter for opportunities whose customer comes from a particular city, because City is a field of a different entity, Customer.
+
When app users want to filter the records in a view, they can use only the fields of the viewed entity as filter criteria. For example, on the Opportunity view, you can filter records by Customer or Estimated Revenue, because both are fields of the Opportunity entity. However, you cannot filter for opportunities whose customer comes from a particular city, because City is a field of a different entity, Customer.
    
Fortunately, there's a way. Using the '''Edit Filter''', you can define a set of conditions that allow full-text search in related fields. In the following example, while on the Opportunity view, app users can use the Search function: the string is then compared with the topic of the opportunity, the name of the account or the full name of the owner (with account and owner being related entities). The filter uses the search condition; when at least one field matches the searched string, the opportunity is displayed. This is ensured by the string <code>@@filter@@</code> that corresponds to the searched string.
 
Fortunately, there's a way. Using the '''Edit Filter''', you can define a set of conditions that allow full-text search in related fields. In the following example, while on the Opportunity view, app users can use the Search function: the string is then compared with the topic of the opportunity, the name of the account or the full name of the owner (with account and owner being related entities). The filter uses the search condition; when at least one field matches the searched string, the opportunity is displayed. This is ensured by the string <code>@@filter@@</code> that corresponds to the searched string.

Navigation menu