Object Oriented Filtering (OOF) - Dragan S. Pusonjic
Previous Table of Contents Next

 Interior state of object                                             
Let’s define our column order_date as an object (this is it, in fact) which number of compared operators,
negating conditions and null test are used to test single values in one SQL statement. In our case we have
8 possible states of object “order_date”.

1) for down value: <= , NOT<=                                   (2 states)
            2) for up value:       =>, NOT=>                                   (2 states)
            3) between values: BETWEEN, NOT BETWEEN       (2 states)
            4) test on NULL value: IS NULL, IS NOT NULL       (2 states)
But, there is one more now invisible state of object; it is excluding of object. Add this state to active states of object.
            5) state of excluding of object.                                      (1 state)
We have 9 possible states for object mentioned above.

 Photo description and image                        
Our user was on vacation last summer, and from that vacation he had wonderful memories. Very often, in free time,
he has described to his colleagues the place where he had spent his summer days. Beautiful place with narrow,
stone paved streets. Old houses with small wooden windows, from which deepness, sometimes, nice kitchen smell
and restless laughing of children had reached out. One day, our user came with his summer photos.
Sometimes, they could tell more than words.
Therefore, let’s try to transform our cruel word of SQL sentences into something else to be closer to our user.
We want to show 9 states of object “order_date”. But, we will exclude state of test on null value.

     What we must have:
            1) entry of down value
            2) entry of up value

       We ought to have switches in order to know which value is active.
            1) the switch for down value activity
            2) the switch for up value activity
                                                           


Previous Table of Contents Next