1 2 Previous Next 18 Replies Latest reply: Aug 2, 2013 10:47 AM by Greg Spall Go to original post RSS
      • 15. Re: Binding variable type using parameters from procedure
        Pappu23

        Thanks

         

        Why this is highly questionable ?

         

        Suppose in some Report you are entering parameters and specifying some filters for  specific objects like

        you want to see only if sales > 5000 or any other complex criteria or nested filter conditions ?

         

        Cant they be stored in tables  ?

         

        Thanks

        • 16. Re: Binding variable type using parameters from procedure
          Billy~Verreynne

          Filter conditions is not a problem.

           

          Storing filter conditions as data, and then applying a selection of these filters dynamically, are.

           

          There are logical/functional issues. E.g. filter on sales to customers in a specific region. This filter requires the sales table to be joined to the customer table (get customer), and the customer table to be joined to the address table (get customer's shipping address), and that joined to region table (get region name).

           

          So how do you design the report filter interface to only do these joins when this filter is used? And not to do these joins when the filter for (sales > 500) is used?

           

          If 2 filters have an overlap in join requirements, the same columns will be in multiple tables. How do you determine which column from which table to use in the SQL projection?

           

          There are technical issues - like dynamically determining what joins a filter needs. Like supporting bind variables for a filter. Like knowing when to outer join and when not.

           

          And so this list of complexities goes on and on and on...

           

          If you argue that these filters are not that complex, then thanks. You have just provided the evidence as to why there are no valid reasons for storing filters as data. If they are not that complex, use code for the filters - not data.

          • 17. Re: Binding variable type using parameters from procedure
            Pappu23

            Hi BillyVerreynne

             

            I understood your point.

             

            I will keep in mind of not storing filter conditions as data.

             

            Thanks for your insight and help.

             

            Thanks

            • 18. Re: Binding variable type using parameters from procedure
              Greg Spall

              Pappu23 wrote:

               

              Thanks Greg,

               

              But i will be glad if you clearly specify what you wanted to say ...

               

              Thanks

              Billy said it.

              1 2 Previous Next