DevForce Community Forum : Multiple Where clause

Multiple Where clause : i wonder how it works in your...

Fri, 17 Feb 2012 00:56:41 -700

Author: k_cire0426
Subject: 3264
Posted: 17-Feb-2012 at 12:56am

i wonder how it works in your end...I am checking the script on profiler and it definitely not grouping.. i'll find what's causing this...

Multiple Where clause : The following works when I tested...

Thu, 16 Feb 2012 19:24:29 -700

Author: DenisK
Subject: 3264
Posted: 16-Feb-2012 at 7:24pm

The following works when I tested it.

[TestMethod]
    public void DynamicQueryCombiningPredicates() {
      //T11526
      var pd1 = new PredicateDescription("UnitPrice", FilterOperator.IsGreaterThanOrEqualTo, 24);
      var pd2 = new PredicateDescription("Discontinued", FilterOperator.IsEqualTo, true);
      var pd3 = new PredicateDescription("Category.Name", FilterOperator.StartsWith, "P");
      var arrPredicates = new ArrayList { pd1, pd2, pd3 };
      
      CompositePredicateDescription compPredicates = null;
      IPredicateDescription predicate = null;

      for (int arrCount = 0; arrCount < arrPredicates.Count; arrCount++) {
        if (predicate != null) {
          if (compPredicates == null) {
            compPredicates = predicate.And((IPredicateDescription)arrPredicates[arrCount]);
            //tried this as well
            //compPredicates = (predicate.And((IPredicateDescription)arrPredicates[arrCount]));
          } else {

            //here is the part where i add the parenthesis, but i tried the above as well...
            compPredicates = (compPredicates).Or((IPredicateDescription)arrPredicates[arrCount]);
          }
        } else {
          predicate = (IPredicateDescription)arrPredicates[arrCount];
        }
      }

      var r1 = _em1.Products.Where(p => (p.UnitPrice >= 24 && p.Discontinued) || p.Category.Name.StartsWith("P")).ToList();
      var r2 = _em1.Products.Where(compPredicates).ToList();
      Assert.IsTrue(r1.Count == r2.Count);
    }

I had to change

arrCount <= arrPredicates.Count

arrCount < arrPredicates.Count

or else it throws index out of range exception.

Multiple Where clause : hello denisK, Here is the sample...

Thu, 16 Feb 2012 16:44:43 -700

Author: k_cire0426
Subject: 3264
Posted: 16-Feb-2012 at 4:44pm

hello denisK,

Here is the sample code.

The code below assuming that we have 3 predicates and the 1 and 2 predicate will be in group.

CompositePredicateDescription compPredicates = null;

            IPredicateDescription predicate = null;             for (int arrCount = 0; arrCount <= arrPredicates.Count; arrCount++)            {                if (predicate != null)                {                    if (compPredicates == null)                    {                        compPredicates = predicate.And((IPredicateDescription)arrPredicates[arrCount]);                        //tried this as well                        //compPredicates = (predicate.And((IPredicateDescription)arrPredicates[arrCount]));                    }                    else                    {

						//here is the part where i add the parenthesis, but i tried the above as well...
                        compPredicates = (compPredicates).Or((IPredicateDescription)arrPredicates[arrCount]);
                    }                }                else                {                    predicate = (IPredicateDescription)arrPredicates[arrCount];                }            }

Multiple Where clause : Would you be able to post a code...

Thu, 16 Feb 2012 11:01:08 -700

Author: DenisK
Subject: 3264
Posted: 16-Feb-2012 at 11:01am

Would you be able to post a code snippet?

Multiple Where clause : hello denisK, :) Your sample is...

Wed, 15 Feb 2012 21:34:58 -700

Author: k_cire0426
Subject: 3264
Posted: 15-Feb-2012 at 9:34pm

hello denisK, :)

Your sample is working, however it seems not working when combining each predicatedescription in a for loop one by one. I have all my PredicateDescription in the ArrayList..

thanks...

Multiple Where clause : Hi k_cire0426,Here's an example. ...

Tue, 14 Feb 2012 18:42:18 -700

Author: DenisK
Subject: 3264
Posted: 14-Feb-2012 at 6:42pm

Hi k_cire0426,

Here's an example.

      var pd1 = new PredicateDescription("AccountID", FilterOperator.IsEqualTo, "123");
      var pd2 = new PredicateDescription("Group", FilterOperator.IsEqualTo, "Group1");
      var pd3 = new PredicateDescription("AccountID ", FilterOperator.IsEqualTo, "1234");
      
      var pd = (pd1.And(pd2)).Or(pd3);

Multiple Where clause : Hello, How do I convert this SQL...

Mon, 13 Feb 2012 21:14:13 -700

Author: k_cire0426
Subject: 3264
Posted: 13-Feb-2012 at 9:14pm

Hello,

How do I convert this SQL Where Expression to CompositePredicateDescription?

WHERE (AccountID = '123' AND Group = 'Group1')

OR AccountID = '1234'

thanks