Database sorts, filters and ranges

We can query the database in a variety of ways. The more specific and limited the request is, the slower the retrieval time, yet the more focused the request can be. As a user, what matters is whether you want to retrieve one image at a time, or a group of images.

• If you want to put the entire database in a particular order, you SORT the database by index points. Using any index sorts the database. Not all fields in the database are indexes.
• If you want to identify a subset of the database by an indexed range of values such as date or a specific field and its value, you SET A RANGE. These ranges are alternative to each other; that is, you use one or the other, but cannot use both, and using one cancels the other. Dates and fields are indexes in the system, so using these to identify a group of records is particularly efficient and quick for the system.
• If you want the system to examine every record in a range and locate a specific subset of that range, you apply a secondary FILTER to the database.

Return to ChekScan Standard features >

See also

• ACH options - there are three ways for businesses to clear checks through the Automated Clearing House: POP, ARC, and BOC. See how they compare to each other .
• Check 21 changes - a fundamental change is occurring in the world of checks, for both businesses and banks
• remote capture with remote deposit - ChekDirect solves the problem simply
• remote capture without remote deposit- TEKScan provides one-sided scanning for simple microfilm or photocopying replacement
• back office conversion - TEKScanRC helps you collect the information needed to package information for ACH clearing
• ACH - ACHLink connects your check scanner with the ACH network
• check scanner choices - single feed or batch scanning, one- or two-sided scanning. Digital Check. Canon. Magtek.
• check imaging solutions - the ChekScan suite of products offers a variety of check imaging software, from stand-alone to networked to enterprise
• software/feature checklist - which ChekScan software product best meets your needs? our checklist can help you decide
• ChekScan testimonial - Digital Check thinks highly of our products; see why

Contact us for more information.