and [KW_AND] (23 in 8 files)

Filename Line # Column # Match Text
./abl/checkout.p 00086 00069
and [KW_AND] @86:69
   = [EQUALS] @86:43
      reservation.reservation-id [FIELD_INT] @86:16
      checkout.reservation-id [FIELD_INT] @86:45
   ( [LPARENS] @88:17
      or [KW_OR] @88:39
         = [EQUALS] @88:33
            checkout.state [FIELD_CHAR] @88:18
            'I' [STRING] @88:35
         = [EQUALS] @88:57
            checkout.state [FIELD_CHAR] @88:42
            "O" [STRING] @88:59
./abl/checkout.p 00285 00105
and [KW_AND] @285:105
   ( [LPARENS] @285:22
      if [FUNC_POLY] @285:23
         or [KW_OR] @285:36
            = [EQUALS] @285:32
               g-f-n [VAR_CHAR] @285:26
               ? [UNKNOWN_VAL] @285:34
            = [EQUALS] @285:45
               g-f-n [VAR_CHAR] @285:39
               "" [STRING] @285:47
         true [BOOL_TRUE] @285:55
         matches [KW_MATCHES] @285:84
            b-guest.first-name [FIELD_CHAR] @285:65
            + [PLUS] @285:98
               g-f-n [VAR_CHAR] @285:92
               "*" [STRING] @285:100
   ( [LPARENS] @286:22
      if [FUNC_POLY] @286:23
         or [KW_OR] @286:36
            = [EQUALS] @286:32
               g-l-n [VAR_CHAR] @286:26
               ? [UNKNOWN_VAL] @286:34
            = [EQUALS] @286:45
               g-l-n [VAR_CHAR] @286:39
               "" [STRING] @286:47
         true [BOOL_TRUE] @286:55
         matches [KW_MATCHES] @286:83
            b-guest.last-name [FIELD_CHAR] @286:65
            + [PLUS] @286:97
               g-l-n [VAR_CHAR] @286:91
               "*" [STRING] @286:99
./abl/checkout.p 00288 00088
and [KW_AND] @288:88
   = [EQUALS] @288:65
      b-out-room.reservation-id [FIELD_INT] @288:39
      b-res.reservation-id [FIELD_INT] @288:67
   ( [LPARENS] @289:22
      or [KW_OR] @291:66
         or [KW_OR] @290:66
            or [KW_OR] @289:66
               = [EQUALS] @289:47
                  b-out-room.guest-ids [FIELD_INT] @289:23
                     [ [LBRACKET] @289:43
                        1 [NUM_LITERAL] @289:44
                  b-guest.guest-id [FIELD_INT] @289:49
               = [EQUALS] @290:47
                  b-out-room.guest-ids [FIELD_INT] @290:23
                     [ [LBRACKET] @290:43
                        2 [NUM_LITERAL] @290:44
                  b-guest.guest-id [FIELD_INT] @290:49
            = [EQUALS] @291:47
               b-out-room.guest-ids [FIELD_INT] @291:23
                  [ [LBRACKET] @291:43
                     3 [NUM_LITERAL] @291:44
               b-guest.guest-id [FIELD_INT] @291:49
         = [EQUALS] @292:47
            b-out-room.guest-ids [FIELD_INT] @292:23
               [ [LBRACKET] @292:43
                  4 [NUM_LITERAL] @292:44
            b-guest.guest-id [FIELD_INT] @292:49
./abl/checkout.p 00310 00074
and [KW_AND] @310:74
   = [EQUALS] @310:67
      checkout-room.reservation-id [FIELD_INT] @310:38
      r-id [VAR_INT] @310:69
   = [EQUALS] @310:104
      checkout-room.room-number [FIELD_INT] @310:78
      f-room-id [VAR_INT] @310:106
./abl/guests.p 00173 00104
and [KW_AND] @173:104
   and [KW_AND] @172:105
      ( [LPARENS] @172:22
         if [FUNC_POLY] @172:23
            or [KW_OR] @172:36
               = [EQUALS] @172:32
                  g-f-n [VAR_CHAR] @172:26
                  ? [UNKNOWN_VAL] @172:34
               = [EQUALS] @172:45
                  g-f-n [VAR_CHAR] @172:39
                  "" [STRING] @172:47
            true [BOOL_TRUE] @172:55
            matches [KW_MATCHES] @172:84
               b-guest.first-name [FIELD_CHAR] @172:65
               + [PLUS] @172:98
                  g-f-n [VAR_CHAR] @172:92
                  "*" [STRING] @172:100
      ( [LPARENS] @173:22
         if [FUNC_POLY] @173:23
            or [KW_OR] @173:36
               = [EQUALS] @173:32
                  g-l-n [VAR_CHAR] @173:26
                  ? [UNKNOWN_VAL] @173:34
               = [EQUALS] @173:45
                  g-l-n [VAR_CHAR] @173:39
                  "" [STRING] @173:47
            true [BOOL_TRUE] @173:55
            matches [KW_MATCHES] @173:83
               b-guest.last-name [FIELD_CHAR] @173:65
               + [PLUS] @173:97
                  g-l-n [VAR_CHAR] @173:91
                  "*" [STRING] @173:99
   ( [LPARENS] @174:22
      if [FUNC_POLY] @174:23
         = [EQUALS] @174:32
            g-dob [VAR_DATE] @174:26
            ? [UNKNOWN_VAL] @174:34
         true [BOOL_TRUE] @174:41
         = [EQUALS] @174:73
            b-guest.date-of-birth [FIELD_DATE] @174:51
            g-dob [VAR_DATE] @174:75
./abl/rates-report.p 00110 00087
and [KW_AND] @110:87
   and [KW_AND] @109:59
      and [KW_AND] @108:49
         = [EQUALS] @108:33
            rate.floor [FIELD_INT] @108:22
            t-floor.floor [FIELD_INT] @108:35
         = [EQUALS] @109:40
            rate.type-of-room [FIELD_INT] @109:22
            t-room-type.type [FIELD_INT] @109:42
      ( [LPARENS] @110:22
         if [FUNC_POLY] @110:23
            = [EQUALS] @110:37
               start-date [VAR_DATE] @110:26
               ? [UNKNOWN_VAL] @110:39
            true [BOOL_TRUE] @110:46
            <= [LTE] @110:72
               rate.start-date [FIELD_DATE] @110:56
               start-date [VAR_DATE] @110:75
   ( [LPARENS] @111:22
      if [FUNC_POLY] @111:23
         = [EQUALS] @111:35
            end-date [VAR_DATE] @111:26
            ? [UNKNOWN_VAL] @111:37
         true [BOOL_TRUE] @111:44
         >= [GTE] @111:68
            rate.end-date [FIELD_DATE] @111:54
            end-date [VAR_DATE] @111:71
./abl/rates-report.p 00153 00087
and [KW_AND] @153:87
   and [KW_AND] @152:59
      and [KW_AND] @151:49
         = [EQUALS] @151:33
            rate.floor [FIELD_INT] @151:22
            t-floor.floor [FIELD_INT] @151:35
         = [EQUALS] @152:40
            rate.type-of-room [FIELD_INT] @152:22
            t-room-type.type [FIELD_INT] @152:42
      ( [LPARENS] @153:22
         if [FUNC_POLY] @153:23
            = [EQUALS] @153:37
               start-date [VAR_DATE] @153:26
               ? [UNKNOWN_VAL] @153:39
            true [BOOL_TRUE] @153:46
            <= [LTE] @153:72
               rate.start-date [FIELD_DATE] @153:56
               start-date [VAR_DATE] @153:75
   ( [LPARENS] @154:22
      if [FUNC_POLY] @154:23
         = [EQUALS] @154:35
            end-date [VAR_DATE] @154:26
            ? [UNKNOWN_VAL] @154:37
         true [BOOL_TRUE] @154:44
         >= [GTE] @154:68
            rate.end-date [FIELD_DATE] @154:54
            end-date [VAR_DATE] @154:71
./abl/rates-report.p 00258 00087
and [KW_AND] @258:87
   and [KW_AND] @257:59
      and [KW_AND] @256:49
         = [EQUALS] @256:33
            rate.floor [FIELD_INT] @256:22
            t-floor.floor [FIELD_INT] @256:35
         = [EQUALS] @257:40
            rate.type-of-room [FIELD_INT] @257:22
            t-room-type.type [FIELD_INT] @257:42
      ( [LPARENS] @258:22
         if [FUNC_POLY] @258:23
            = [EQUALS] @258:37
               start-date [VAR_DATE] @258:26
               ? [UNKNOWN_VAL] @258:39
            true [BOOL_TRUE] @258:46
            <= [LTE] @258:72
               rate.start-date [FIELD_DATE] @258:56
               start-date [VAR_DATE] @258:75
   ( [LPARENS] @259:22
      if [FUNC_POLY] @259:23
         = [EQUALS] @259:35
            end-date [VAR_DATE] @259:26
            ? [UNKNOWN_VAL] @259:37
         true [BOOL_TRUE] @259:44
         >= [GTE] @259:68
            rate.end-date [FIELD_DATE] @259:54
            end-date [VAR_DATE] @259:71
./abl/rates-report.p 00301 00087
and [KW_AND] @301:87
   and [KW_AND] @300:59
      and [KW_AND] @299:49
         = [EQUALS] @299:33
            rate.floor [FIELD_INT] @299:22
            t-floor.floor [FIELD_INT] @299:35
         = [EQUALS] @300:40
            rate.type-of-room [FIELD_INT] @300:22
            t-room-type.type [FIELD_INT] @300:42
      ( [LPARENS] @301:22
         if [FUNC_POLY] @301:23
            = [EQUALS] @301:37
               start-date [VAR_DATE] @301:26
               ? [UNKNOWN_VAL] @301:39
            true [BOOL_TRUE] @301:46
            <= [LTE] @301:72
               rate.start-date [FIELD_DATE] @301:56
               start-date [VAR_DATE] @301:75
   ( [LPARENS] @302:22
      if [FUNC_POLY] @302:23
         = [EQUALS] @302:35
            end-date [VAR_DATE] @302:26
            ? [UNKNOWN_VAL] @302:37
         true [BOOL_TRUE] @302:44
         >= [GTE] @302:68
            rate.end-date [FIELD_DATE] @302:54
            end-date [VAR_DATE] @302:71
./abl/rates.p 00103 00053
and [KW_AND] @103:53
   = [EQUALS] @103:37
      rate.floor [FIELD_INT] @103:26
      t-floor.floor [FIELD_INT] @103:39
   = [EQUALS] @104:44
      rate.type-of-room [FIELD_INT] @104:26
      t-room-type.type [FIELD_INT] @104:46
./abl/rates.p 00165 00042
and [KW_AND] @165:42
   = [EQUALS] @165:29
      b-rate.floor [FIELD_INT] @165:16
      rate.floor [FIELD_INT] @165:31
   = [EQUALS] @166:36
      b-rate.type-of-room [FIELD_INT] @166:16
      rate.type-of-room [FIELD_INT] @166:38
./abl/reservations.p 00190 00098
and [KW_AND] @190:98
   and [KW_AND] @189:99
      ( [LPARENS] @189:16
         if [FUNC_POLY] @189:17
            or [KW_OR] @189:30
               = [EQUALS] @189:26
                  g-f-n [VAR_CHAR] @189:20
                  ? [UNKNOWN_VAL] @189:28
               = [EQUALS] @189:39
                  g-f-n [VAR_CHAR] @189:33
                  "" [STRING] @189:41
            true [BOOL_TRUE] @189:49
            matches [KW_MATCHES] @189:78
               b-guest.first-name [FIELD_CHAR] @189:59
               + [PLUS] @189:92
                  g-f-n [VAR_CHAR] @189:86
                  "*" [STRING] @189:94
      ( [LPARENS] @190:16
         if [FUNC_POLY] @190:17
            or [KW_OR] @190:30
               = [EQUALS] @190:26
                  g-l-n [VAR_CHAR] @190:20
                  ? [UNKNOWN_VAL] @190:28
               = [EQUALS] @190:39
                  g-l-n [VAR_CHAR] @190:33
                  "" [STRING] @190:41
            true [BOOL_TRUE] @190:49
            matches [KW_MATCHES] @190:77
               b-guest.last-name [FIELD_CHAR] @190:59
               + [PLUS] @190:91
                  g-l-n [VAR_CHAR] @190:85
                  "*" [STRING] @190:93
   ( [LPARENS] @191:16
      if [FUNC_POLY] @191:17
         = [EQUALS] @191:26
            g-dob [VAR_DATE] @191:20
            ? [UNKNOWN_VAL] @191:28
         true [BOOL_TRUE] @191:35
         = [EQUALS] @191:67
            b-guest.date-of-birth [FIELD_DATE] @191:45
            g-dob [VAR_DATE] @191:69
./abl/reservations.p 00208 00098
and [KW_AND] @208:98
   and [KW_AND] @207:102
      ( [LPARENS] @207:19
         if [FUNC_POLY] @207:20
            or [KW_OR] @207:33
               = [EQUALS] @207:29
                  g-f-n [VAR_CHAR] @207:23
                  ? [UNKNOWN_VAL] @207:31
               = [EQUALS] @207:42
                  g-f-n [VAR_CHAR] @207:36
                  "" [STRING] @207:44
            true [BOOL_TRUE] @207:52
            matches [KW_MATCHES] @207:81
               b-guest.first-name [FIELD_CHAR] @207:62
               + [PLUS] @207:95
                  g-f-n [VAR_CHAR] @207:89
                  "*" [STRING] @207:97
      ( [LPARENS] @208:16
         if [FUNC_POLY] @208:17
            or [KW_OR] @208:30
               = [EQUALS] @208:26
                  g-l-n [VAR_CHAR] @208:20
                  ? [UNKNOWN_VAL] @208:28
               = [EQUALS] @208:39
                  g-l-n [VAR_CHAR] @208:33
                  "" [STRING] @208:41
            true [BOOL_TRUE] @208:49
            matches [KW_MATCHES] @208:77
               b-guest.last-name [FIELD_CHAR] @208:59
               + [PLUS] @208:91
                  g-l-n [VAR_CHAR] @208:85
                  "*" [STRING] @208:93
   ( [LPARENS] @209:16
      if [FUNC_POLY] @209:17
         = [EQUALS] @209:26
            g-dob [VAR_DATE] @209:20
            ? [UNKNOWN_VAL] @209:28
         true [BOOL_TRUE] @209:35
         = [EQUALS] @209:67
            b-guest.date-of-birth [FIELD_DATE] @209:45
            g-dob [VAR_DATE] @209:69
./abl/reservations.p 00393 00104
and [KW_AND] @393:104
   and [KW_AND] @392:105
      ( [LPARENS] @392:22
         if [FUNC_POLY] @392:23
            or [KW_OR] @392:36
               = [EQUALS] @392:32
                  g-f-n [VAR_CHAR] @392:26
                  ? [UNKNOWN_VAL] @392:34
               = [EQUALS] @392:45
                  g-f-n [VAR_CHAR] @392:39
                  "" [STRING] @392:47
            true [BOOL_TRUE] @392:55
            matches [KW_MATCHES] @392:84
               b-guest.first-name [FIELD_CHAR] @392:65
               + [PLUS] @392:98
                  g-f-n [VAR_CHAR] @392:92
                  "*" [STRING] @392:100
      ( [LPARENS] @393:22
         if [FUNC_POLY] @393:23
            or [KW_OR] @393:36
               = [EQUALS] @393:32
                  g-l-n [VAR_CHAR] @393:26
                  ? [UNKNOWN_VAL] @393:34
               = [EQUALS] @393:45
                  g-l-n [VAR_CHAR] @393:39
                  "" [STRING] @393:47
            true [BOOL_TRUE] @393:55
            matches [KW_MATCHES] @393:83
               b-guest.last-name [FIELD_CHAR] @393:65
               + [PLUS] @393:97
                  g-l-n [VAR_CHAR] @393:91
                  "*" [STRING] @393:99
   ( [LPARENS] @394:22
      if [FUNC_POLY] @394:23
         = [EQUALS] @394:32
            g-dob [VAR_DATE] @394:26
            ? [UNKNOWN_VAL] @394:34
         true [BOOL_TRUE] @394:41
         = [EQUALS] @394:73
            b-guest.date-of-birth [FIELD_DATE] @394:51
            g-dob [VAR_DATE] @394:75
./abl/reservations.p 00395 00069
and [KW_AND] @395:69
   = [EQUALS] @395:50
      b-res.guest-id [FIELD_INT] @395:35
      b-guest.guest-id [FIELD_INT] @395:52
   >= [GTE] @395:88
      b-res.checkout [FIELD_DATE] @395:73
      today [FUNC_DATE] @395:91
./abl/reservations.p 00524 00089
and [KW_AND] @524:89
   and [KW_AND] @524:56
      >= [GTE] @524:43
         b-res2.checkin [FIELD_DATE] @524:28
         r-checkin [VAR_DATE] @524:46
      <= [LTE] @524:76
         b-res2.checkout [FIELD_DATE] @524:60
         r-checkin [VAR_DATE] @524:79
   <> [NOT_EQ] @525:41
      b-res2.state [FIELD_CHAR] @525:28
      res-state-ch [VAR_CHAR] @525:44
         [ [LBRACKET] @525:56
            res-state-canceled [VAR_INT] @525:57
./abl/reservations.p 00613 00076
and [KW_AND] @613:76
   >= [GTE] @613:59
      b-res2.checkin [FIELD_DATE] @613:44
      b-res.checkin [FIELD_DATE] @613:62
   <= [LTE] @613:95
      b-res2.checkin [FIELD_DATE] @613:80
      b-res.checkout [FIELD_DATE] @613:98
./abl/reservations.p 00616 00079
and [KW_AND] @616:79
   and [KW_AND] @615:74
      <> [NOT_EQ] @615:53
         recid [FUNC_RECID] @615:34
            b-out-room2 [BUFFER] @615:40
         recid [FUNC_RECID] @615:56
            b-out-room [BUFFER] @615:62
      = [EQUALS] @616:58
         b-out-room2.room-number [FIELD_INT] @616:34
         b-room.room-number [FIELD_INT] @616:60
   = [EQUALS] @617:61
      b-out-room2.reservation-id [FIELD_INT] @617:34
      b-res2.reservation-id [FIELD_INT] @617:63
./abl/reservations.p 00642 00058
and [KW_AND] @642:58
   and [KW_AND] @641:73
      = [EQUALS] @641:51
         b-rate.type-of-room [FIELD_INT] @641:31
         b-room.type-of-room [FIELD_INT] @641:53
      <= [LTE] @642:49
         b-rate.start-date [FIELD_DATE] @642:31
         today [FUNC_DATE] @642:52
   ( [LPARENS] @642:62
      or [KW_OR] @642:83
         = [EQUALS] @642:79
            b-rate.end-date [FIELD_DATE] @642:63
            ? [UNKNOWN_VAL] @642:81
         >= [GTE] @642:102
            b-rate.end-date [FIELD_DATE] @642:86
            today [FUNC_DATE] @642:105
./abl/reservations.p 00647 00076
and [KW_AND] @647:76
   = [EQUALS] @647:54
      b-rate.type-of-room [FIELD_INT] @647:34
      b-room.type-of-room [FIELD_INT] @647:56
   <= [LTE] @648:50
      b-rate.end-date [FIELD_DATE] @648:34
      today [FUNC_DATE] @648:53
./abl/rooms-add.p 00063 00053
and [KW_AND] @63:53
   = [EQUALS] @63:34
      room.floor [FIELD_INT] @63:23
      current-floor-no [VAR_INT] @63:36
   = [EQUALS] @63:74
      room.room-number [FIELD_INT] @63:57
      r-no [VAR_INT] @63:76
./abl/rooms-overview.p 00051 00054
and [KW_AND] @51:54
   = [EQUALS] @51:42
      room.type-of-room [FIELD_INT] @51:24
      room-type [VAR_INT] @51:44
   = [EQUALS] @51:69
      room.floor [FIELD_INT] @51:58
      f-no [VAR_INT] @51:71
./abl/rooms.p 00075 00075
and [KW_AND] @75:75
   = [EQUALS] @75:54
      room-state.room-number [FIELD_INT] @75:31
      b-room.room-number [FIELD_INT] @75:56
   <= [LTE] @75:101
      room-state.start-date [FIELD_DATE] @75:79
      today [FUNC_DATE] @75:104

Conditions matched: [ upPath("RECORD_PHRASE/KW_WHERE/EXPRESSION") ]


Please see the Source File Index for the list of report inputs. Generated at 03/31/2017 21:16:32 EEST.