This topic is locked
[SOLVED]

 Group By Help

8/9/2018 7:33:05 PM
PHPRunner General questions
A
admin author

I have a table for service that I want to be able to group by "unit_type" so that when the user is selecting "Unit Type" they are seeing multiple.
I have repeating "unit_type" with the same "service_name" with different or same "rates" (See example below)
serviceid service_name unit_type rate

1 Clean 1 bed downstairs $80.00

2 Clean - Bathroom +1 1 bed downstairs $10.00

3 Paint 1 bed downstairs $200.00

4 Paint Additional Bathroom 1 bed downstairs $10.00

5 Paint Ceilings 1 bed downstairs $30.00

6 Paint Primer 1 bed downstairs $115.00

7 Punch 1 bed downstairs $100.00

8 Punch - + 1 Hour 1 bed downstairs $25.00

9 Clean 1 bed upstairs $100.00

10 Clean - Bathroom +1 1 bed upstairs $10.00

11 Paint 1 bed upstairs $230.00

12 Paint Additional Bathroom 1 bed upstairs $10.00
From the "Unit Type" field on the form, I want to only see the example below:
1 bed downstairs

1 bed upstairs
From there it works, I only see the "service_name" options with the appropriate rate.
I have tried the Group By in PHPRunner and no matter how I try it, it does not work. Any help greatly appreciated.
Thanks,

admin 8/10/2018

Not 100% sure what your question is but may be you can use a Filter?

https://xlinesoft.com/phprunner/docs/filter_as_settings.htm

A
admin author 8/11/2018



Not 100% sure what your question is but may be you can use a Filter?

https://xlinesoft.com/phprunner/docs/filter_as_settings.htm


Thanks, I tried that it is not working. I tried "Group By" in Queries. I did figure out I was looking at the incorrect table and required the cascade down.
Thanks for the response