This topic is locked
[SOLVED]

 Syntax of Query Link

9/8/2010 8:58:47 AM
PHPRunner General questions
U
uli author

I want to compose various links to another table inside the runner application (e.g. for an ID or description).

Where can I find a list of options for queries.

Thanks for help.

Sergey Kornilov admin 9/8/2010

Urlich,
more details required. Show us some examples of links you trying to build.

U
uli author 9/8/2010



Urlich,
more details required. Show us some examples of links you trying to build.



Quite easy:

having a table of devices with fields ID

date_shipped

desciption

serial_no

that device_list is built strait foreward and contains all records.
I would like to compose links that for ex. list records with one specific ID

or with date_shipped from xxxx to xxxx

or with serial_no greater xxx
So what I ask for is a list of all the options that are generated by the search field in the runner template like this:
"http://device_list.php?ctlSearchFor=router&simpleSrchTypeComboNot=&a=integrated&id=1&criteria=and";
Hope that helps to understand.
Ulrich

Sergey Kornilov admin 9/8/2010

Ulrich,
here is the sample code. I assume that you make 'View as' type of one of fields 'Custom' and put the following code there:

$value = "<a href='device_list.php?ctlSearchFor=" . $data["DeviceFieldName"]. "&simpleSrchTypeComboNot=&a=integrated&id=1&criteria=and'>" . $value . "</a>";


Replace DeviceFieldName with the actual field name stores device name i.e. router.

U
uli author 9/9/2010



Ulrich,
here is the sample code. I assume that you make 'View as' type of one of fields 'Custom' and put the following code there:

$value = "<a href='device_list.php?ctlSearchFor=" . $data["DeviceFieldName"]. "&simpleSrchTypeComboNot=&a=integrated&id=1&criteria=and'>" . $value . "</a>";


Replace DeviceFieldName with the actual field name stores device name i.e. router.



Sergey,

thanks for you answer,

but this covers only one simple case of many.

I listed some more in my former post. To compose these, I would need to know the terms in the query syntax as:
"simpleSrchTypeComboNot="

"a=integrated"

"criteria=and"

"contains"
Is this documentation available?
Thanks

Sergey Kornilov admin 9/9/2010

Here is the typical search link:

Balance_list.php?ctlSearchFor=&simpleSrchTypeComboNot=&a=integrated&id=1&criteria=and&type1=&value11=33&field1=Debit&option1=Contains&not1=


If you want to build a link that searches for several criteria add a few fields to the search panel, run a search and see what URL it produces.