How do I search in NorthScope?

Owned by Janice Dannenberg (Unlicensed)
Last updated: Jun 29, 2021 by Emma Greenwood
4 min read

Many of the inquiries in the NorthScope™ 3.0 Framework utilize the ‘Search’ option text box. This guide will explain how to use reserved keywords and search operators to return the desired data within NorthScope.

Additionally, one change to the inquiries in the NorthScope™ 3.0 Framework is that we are encouraging users to specify search options prior to clicking the Refresh button to narrow down the search results. Though not required, the more information we have to filter on, the faster the inquiry will run and the more relevant the returned results will be. A win-win.

 

Financial Inquiries

Please note the use of keywords for searching has not been implemented in the Financial functional area. For example, to search by a specific Account Description, users may not prepend the search value with the text "Account Description: ". If there is an Account Description containing "Checking", simply enter "Checking" into the Search text box. Clicking Refresh will return all results where the value "Checking" is stored in any of the searchable fields. Searchable fields are displayed as placeholder text in the Search text box.

Fisherman Accounting Inquiries

Keywords available for use in the ‘Search’ text box:

  • Class: (search Ticket Class ID and Ticket Class Name)

  • Delivery: (search Delivery #)

  • Permit: (search Permit Holder ID and Permit Holder Name)

  • Site: (search Site ID and Site Name)

  • Tender: (search Tender ID and Tender Name)

  • Ticket: (search Fish Ticket #)

  • Vessel: (search Fishing Vessel Number or Fishing Vessel Name)

Inventory Inquiries

Keywords available for use in the ‘Search’ text box:

  • Attr: (search Attribute values and not Attribute Names)

  • Batch: (search Production Batch)

  • Item: (search Item ID and Description)

  • Owner: (search Lot Owner)

  • Site: (search Site ID and Site Name)

  • WLot: (search the Warehouse Lot ID)

Sales Inquiries

Keywords available for use in the ‘Search’ text box:

  • Attr: (search Attribute values and not Attribute Names)

  • Carrier: (search Carrier)

  • Customer: (search Customer ID and Name)

  • Invoice: (search Invoice)

  • Item: (search Item ID and Description)

  • Order: (search Order #)

  • PurchaseOrder: (search Purchase Order)

  • Site: (search Site ID and Site Name)

Search Functionality

Using the colon: In the ‘Search’ text box, use any of the keywords listed above followed by a colon to return specific search results. For example, “Item: Salmon” will return all items where the Item ID or Item Description contains the word “Salmon”.

Because the colon is a reserved search operator, users will be unable to search for any text that precedes the colon in the ‘Search’ text box. To find items containing the text “RM: 110 Pacific Cod”, enter “RM 110 Pacific Cod” (without the colon).

Using the comma: To search by more than one criteria in the ‘Search’ text box, users may use a comma between keywords. The comma signifies the word “and”. For example, “Batch: K19-229, WLot: 410” will filter results where the Production Batch contains “K19-229” AND Warehouse Lot contains “410”.

However, users may not search multiple values using the same keyword. For example, entering “Item: 110, 410” or “Item: 110, Item: 410” will not yield any results.

Using multiple search words for the same keyword: It is possible to enter multiple words to search on the same keyword. When multiple words are entered in the ‘Search’ text box, all words need to match. Entering “Item: Pacific Cod Frozen” will find all Item IDs and Item Descriptions where the words “Pacific” and “Cod” and ”Frozen” all exist. In this case, “Pacific Cod Frozen Mixed H&G 70# Case” would be found, but “Pacific Cod Fresh Mixed H&G 70# Case“ would not be found. Similarly, entering “Item: Frozen 6-8oz” would not return results if the Item description is “Arrowtooth Flounder Frozen 6-8 oz Fillets“ since the search word “6-8oz” was entered as one search word without spaces. Additionally, NorthScope has the ability to search in reverse order. Following the earlier examples, the same search results will be returned for “Item: Frozen Cod Pacific” and “Item: Cod Pacific Frozen”, or “Item: 6-8 oz Flounder” and “Item: Flounder 6-8 oz”.

The ‘Search’ text box is not case sensitive. Both “salmon” and “Salmon” will return the same results in the grid.

Practical ways to use keywords in the ‘Search’ text box:

  • Find items containing a specific Item ID or Item Description: “Item: 410” or “Item: Frozen”

  • Find an item balance for a specific Site and Warehouse Lot: “Site: Bellingham, WLot: 410”

  • Find a Item/Lot/Transaction containing specific Attribute Values (All items where the ‘Case Size’ attribute is 70# Case): “Attr: 70# Cases”

  • Find items with Attribute Values containing multiple words (All items where the ‘Packaging Size’ attribute is 4” x 6”: “Attr: 4 x 6” or “Attr: 6 x 4” will both return the same results

  • Find items at a specific site: “Site: Commercial Cold Storage” and “Site: Cold Storage Commercial” will both return the same results

  • Find all Fish Tickets associated with a specific Permit Holder named John Smith: “Permit: Smith”

  • Find all Fish Tickets associated with a specific Ticket Class: “Class: Salmon”

  • Find all invoices for a Customer: “Customer: Costco”