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,