2. PHPRunner General questions
  3. Advanced Search Options
This topic is locked

Advanced Search Options

 		6/24/2005 4:34:41 PM
PHPRunner General questions
author

Hello,
We just purchased PHPRunner and it is great!
I have 2 questions regarding the Advanced Search page:

  1. Is there a way to search by date range - like all records dated between 4/6/2004 and 6/24/2005
  2. We have 3 columns (out of 12 total) in our MYSQL db named ID1, ID2, ID3. How do we set up a text box search field like "If any of fields ID1 or ID2, or ID3 contain X"?
    Thanks
    Regards
Sergey Kornilov admin 6/27/2005

Hi,

  1. Advanced Search by date range is available in PHPRunner. Use "between" condition.
  2. You can use plain search for this purpose. Select ID1, ID2, ID3 fields only as searchable fields on the Step 6 in PHPRunner and use "Any field - Contains - X" search condition on the list page.
500265 6/28/2005

Sergey Thanks.
Would # 2 work in conjuction with other paramenters: like If any of fields ID1 or ID2, or ID3 contain X" and also = a document number, date range, etc?
Many thanks again.
Regards
Sergey Kornilov admin 6/29/2005

No, this is not possible with PHPRunner.