This topic is locked
[SOLVED]

 Two detail master relationship conditions

8/24/2020 3:40:41 AM
PHPRunner General questions
alac author


Is it possible to create two conditions, two conditions of the master detail relationship?
Instead of AND include OR.





I need to display records in the detail grid**

**

alac author 8/24/2020




**
Does anyone have another idea? Another solution?**

Sergey Kornilov admin 8/24/2020

The built-in master-details functionality always uses AND. If you need to use OR instead this can be done as well and I would recommend using SQL variables to this purpose:

https://xlinesoft.com/phprunner/docs/sql_variables.htm
Using SQL variables you can either refer to master table fields directly or to use session variables. Since this is not a real master-details relationship I recommend using session variables.