You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

Step 1 – Searching Various Fields

  1. Find the Client Search page
  2. We will search various fields in this page using PL/SQL operators

Step 2 – Text

  1. LIKE
    1. Use '%' to match groups of characters, for example '%ill' will return "Mill", "Gill" and "Seagill"
    2. Use '_' to match single characters, for example '_ill' will return only "Mill" and "Gill"
    3. Type a series of words seperated by only commas and no spaces to see them all, for example "Max,Alex" or "_ax,%ex"
  2. EQUAL
    1. Will only return exact matches

Step 3 – Number

  1. EQUAL
  2. GREATER
  3. LESS 

Step 4 – Date

  1. BETWEEN
  • No labels