2. PHPRunner General questions
  3. [SOLVED]  AddWhere Checkbox on List Page
This topic is locked
[SOLVED]

 AddWhere Checkbox on List Page

 		12/12/2013 11:43:45 AM
PHPRunner General questions
P
 p1nr author

I have a table that holds completed and incomplete records. Incomplete records have no status update nor do they have Pass/Fail where as complete will have a status and Pass/Fail indicator. I would like to add a checkbox to my list page which will show completed records when unchecked.
I've looked at this article: http://www.asprunner.com/forums/topic/17263-cool-smart-checkbox-feature-client-before-on-server-client-after/ but it didn't work when I attempted to add the AddWhere function.
Sergey Kornilov admin 12/12/2013

My suggestion is to use a dropdown box for this purpose.
Here is the sample code:

http://xlinesoft.com/phprunner/docs/add_dropdown_list_box_with_values_for_search.htm
Your code will be even less complicated as you only going to need two hardcoded options there. The point is you do not need any SQL queries there. All you need to do is to redirect user to the proper search results page.
P
 		p1nr author 12/12/2013

I like that suggestion but the issue is that incomplete records have a blank status. This will be misleading to users as they will not know that blank means incomplete.

The best is to have Pending and Completed as options, then have the appropriate records display based off of one of the two options.
P
 		p1nr author 12/12/2013



I like that suggestion but the issue is that incomplete records have a blank status. This will be misleading to users as they will not know that blank means incomplete.

The best is to have Pending and Completed as options, then have the appropriate records display based off of one of the two options.



Actually, I just used a URL redirect.

Thanks!
P
 		p1nr author 12/12/2013

is there a page that lists all possible "search" urls?
Example: (field~equals~keyword)

(fields~notequal~blank)

etc.