Hi,
Table 1: Query Result
| workflow | complaint | status | is_onsite |
| 1 | 1 | Active | 0 |
| 1 | 1 | Cancel | 1 |
Table 2: Expecting
| Workflow | complaint | true |
| 1 | 1 | yes |
in Table 1, if any one row having is_onsite =1 then i have to consider that particular complaint as true
Loading
Laxmidhar SahooPosted Dec 11, 2017, 7:11 AM
Ramesh PalanivelPosted Dec 11, 2017, 3:01 AM