OData

[Matt_Hirst]

I am trying to query Dynamics CRM to return the quote details, so far I can return the quote details for a specific quote, however it returns everything.

private void BeginRetrieveQuoteDetail(Guid Id)
        {
            dataGrid1.ItemsSource = null;

            _context = new AnconTestContext(ODataUri);

            lstQuoteDetails = new DataServiceCollection<QuoteDetail>(_context);

            var result = from QuoteDetailSet in _context.QuoteDetailSet.Where<QuoteDetail>(r=> r.QuoteId.Id ==Id) select QuoteDetailSet;
          
            lstQuoteDetails.LoadCompleted += new EventHandler<LoadCompletedEventArgs>(lstQuoteDetails_LoadCompleted);
            lstQuoteDetails.LoadAsync(result);

        }

        private void lstQuoteDetails_LoadCompleted(object sender, LoadCompletedEventArgs e)
        {
            if (lstQuoteDetails.Continuation != null)
            {
                lstQuoteDetails.LoadNextPartialSetAsync();
            }
            else
            {
                dataGrid1.ItemsSource = lstQuoteDetails;
            }

        }

How can I get it to return specific columns?

regards,

Matt

 

[Matt_Hirst]

Forgot to add.

If I change line to

var result = from QuoteDetailSet in _context.QuoteDetailSet.Where<QuoteDetail>(r=> r.QuoteId.Id ==Id) select QuoteDetailSet.BaseAmount;

I get an error at line

lstQuoteDetails.LoadAsync(result);

Argument 1: cannot convert from 'System.Linq.IQueryable<Microsoft.Crm.Sdk.Samples.CrmODataService.Money>' to 'System.Linq.IQueryable<Microsoft.Crm.Sdk.Samples.CrmODataService.QuoteDetail>'

and

The best overloaded method match for 'System.Data.Services.Client.DataServiceCollection<Microsoft.Crm.Sdk.Samples.CrmODataService.QuoteDetail>.LoadAsync(System.Linq.IQueryable<Microsoft.Crm.Sdk.Samples.CrmODataService.QuoteDetail>)' has some invalid arguments

regards,

Matt

 

[Matt_Hirst]

So do I pass Id to LoadCompleted?

As all I get when I try the above is The name 'Id' does not exist in the current context

regards,

Matt

 

[Matt_Hirst]

Am new to all this hence code all over the place, not getting any help on MSDN forum.

Matt

 

[Matt_Hirst]

Any pointers on how to pass I'd?

Matt

 

[Matt_Hirst]

Thanks for the replies guys.

We cannot use the OOB quote as the quote portion of our CRM product is quite complex to say the least.

Another complication is that I have now been asked to look at moving the quote module across to HTML5 - any help on how to get started on this as nothing is appearing in google on how to get started with HTML5 and dynamics crm.

regards,

Matt