How to implement IN query in ResultSet

Posts   
 
    
neos
User
Posts: 8
Joined: 03-Jan-2014
# Posted on: 03-Jan-2014 07:25:37   

hi

i want to implement IN query with LLBLgen filters how do i do this ,i have already use joins but it's not working

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 03-Jan-2014 07:46:16   

Hi neos,

Please check the FieldCompareSetPredicate in the docs.

If you still need help please show us your code so far and post additional information. Ref: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=7725

At last but not least, next time don't create your thread in the 'General Chat' forum, as that is for offtopic talk. For this question, it may suits better into the 'Generated Code' forum.

David Elizondo | LLBLGen Support Team
neos
User
Posts: 8
Joined: 03-Jan-2014
# Posted on: 03-Jan-2014 11:05:47   

hello sir,

from next time i'll take care of this.smile

i understand your reply but sir as per my que i have multiple condition as well. i want to apply this filter condition Separately on My one field

how can i move ahead.

really thx for reply

abhishek

neos
User
Posts: 8
Joined: 03-Jan-2014
# Posted on: 03-Jan-2014 11:17:28   

i have doing something like this

fields.DefineField(BinContentFields.NroThermostats, 11, "Count Number of Thermostats Received ");

//// bucket.PredicateExpression.Add(new FieldCompareSetPredicate(BinContentFields.BinReceiptId, null, BinReceiptFields.Id, null, SetOperator.In, APredicate)); ///

so i want to directly give this Expression on perticular fields beacuse if i am doing like mention above i need to set joins [and i am getting wrong data when doing join]

neos
User
Posts: 8
Joined: 03-Jan-2014
# Posted on: 03-Jan-2014 11:29:44   

done