9,267
edits
Join the Power Platform Masterclass #2 starting April 23
Filter editor: Difference between revisions
Jump to navigation
Jump to search
→Using search strings in filters
| Line 93: | Line 93: | ||
== Using search strings in filters == | == Using search strings in filters == | ||
When app users | 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. | ||