How do I query on journal entries with a specific note?

Many different journal entry types have a Note field available and at some point you may want to locate all entries that have a specific word or phrase within that note.  You can find all journal entries with specific wording in the Note field by creating a query.
You can create a query to find all journal entries with specific text in the Note field by following these steps:

1. Click Queries
2. Select a category to store this query in (Ex: Base)
3. Click New Query
4. Name the query
5. Select Base for Query Category
6. Select All Constituents for Query
7. Select Journal Entries for Data Return Type
8. Select Match each Criteria for Criteria Matching
9. Under Browse Fields select Journal from the drop down box
10. Click Journal Note Text
11. Type in the specific text you're looking for
12. Click Save and Preview



Was this article helpful?