1-888-365-2779
+1-888-365-2779
Try Now
More in this section

Forums / General Discussions / IQueryable<Document> Compare WIth Column Name

IQueryable&lt;Document&gt; Compare WIth Column Name

5 posts, 0 answered
  1. Jmr
    Jmr avatar
    53 posts
    Registered:
    21 Jan 2011
    03 Feb 2011
    Link to this post
    Hi
    I need to compare two IQueryable<Document>  i.e
     First Document ID have 
    1
    2
    3
    4
    5
    Second Document  ID have
    3
    4

    so i want First Document ID 3,4 th another colums value?
    How to do this using API?
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    16 Jun 2017
    03 Feb 2011
    Link to this post
    Hi Jmr,

    Please check this post. You can also use SequenceEqual or/and Queryable.Distinct

    Kind regards,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. Jmr
    Jmr avatar
    53 posts
    Registered:
    21 Jan 2011
    03 Feb 2011
    Link to this post
    Hi
    Thanks for your valuable reply

    two documents have different columns  some columns only have equal column name and also i  want equal row value not except row values.

    if i try that code i am getting "The method 'Except' is not supported" error..

    please clear my doubt
    Thanks
  4. Jmr
    Jmr avatar
    53 posts
    Registered:
    21 Jan 2011
    21 Feb 2011
    Link to this post
    Hi
    How do i use greater then equal operator while i use dynamic fields

    DateTime dt;
    dt = DateTime.Today;
    Idoc = App.WorkWith()
                                     .Documents()
                                     .Where(dc => dc.Parent.Title == "ScheduleSession"
                                           && dc.Status == ContentLifecycleStatus.Live
                                           && dc.GetValue("DatePrinted") >= dt) 
                                     .Get();                    

    Thanks
    jmr
  5. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    16 Jun 2017
    25 Feb 2011
    Link to this post
    Hello Jmr,

    Try using GetValue<T> , because the extension you use returns object and actually you should get an compilation error.

    Kind regards,
    Ivan Dimitrov
    the Telerik team
5 posts, 0 answered