tag:blogger.com,1999:blog-14479009.post115565647424511283..comments2023-11-24T12:30:17.358+01:00Comments on Ronald Lemmen - CRM, C# and Cme: Fetch all recordsRonald Lemmenhttp://www.blogger.com/profile/11930631598114156863noreply@blogger.comBlogger26125tag:blogger.com,1999:blog-14479009.post-84456903023659645812013-03-18T08:17:46.714+01:002013-03-18T08:17:46.714+01:00I think the readers of this post might interested ...I think the readers of this post might interested in writing FetchXML, here is a web tool convert from SQL to FetchXML, available at http://www.sql2fetchxml.comWeifeng Jianghttps://www.blogger.com/profile/00368463209574435082noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-84292207114466965452010-07-21T07:09:58.228+02:002010-07-21T07:09:58.228+02:00You can refer to this post on how to fetch mutlipl...You can refer to this post on how to fetch mutliple records and schedule workflows.<br />http://raotayyabali.wordpress.com/2010/07/21/scheduling-workflows-in-crm-4-0/Tayyabhttps://www.blogger.com/profile/02101901876340891457noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-60273131750284509042010-07-16T00:26:06.776+02:002010-07-16T00:26:06.776+02:00another attempt to display the FetchXML
"fet...another attempt to display the FetchXML<br /><br />"fetch version=\"1.0\" output-format=\"xml-platform\" mapping=\"logical\" page=\"2\" count=\"5000\" distinct=\"false\"<br />entity name=\"account\"<br />attribute name=\"name\"<br />attribute name=\"primarycontactid\"<br />attribute name=\"Unknownhttps://www.blogger.com/profile/04226737653677642947noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-9663479644345748152010-07-15T18:25:30.097+02:002010-07-15T18:25:30.097+02:00This comment has been removed by the author.Unknownhttps://www.blogger.com/profile/04226737653677642947noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-23969775590471439512010-07-15T18:16:42.977+02:002010-07-15T18:16:42.977+02:00hi,
am using your FetchXML code which is excellen...hi,<br /><br />am using your FetchXML code which is excellent.<br />Am getting the following error <br />"'column' argument cannot be null. Parameter name: column"<br /><br />when returning the data from a total of 5211 from the Account entity.<br />The 1st 5000 records are ok, the error occurs when returning the 2nd set of 211 records.<br />This is the xml...<br /><br />"<Unknownhttps://www.blogger.com/profile/04226737653677642947noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-84457453890603383672010-02-17T13:58:48.317+01:002010-02-17T13:58:48.317+01:00Can you tell me how to passa value to FetchXML, th...Can you tell me how to passa value to FetchXML, than hardcoded value for filter condition?Vineetahttps://www.blogger.com/profile/16687053396494887507noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-38521495668820063242008-05-26T07:35:00.000+02:002008-05-26T07:35:00.000+02:00Hi Ronald,I would like to get Records count only l...Hi Ronald,<BR/><BR/>I would like to get Records count only like SELECT COUNT(*) recordsCount FROM account. How can I do it? <BR/><BR/>I am using RetrieveMultiple to retrieve records. And I faced one problem when I am using Paging. It hits the error if there is NO records (There is no page number 1). It is NO problem if there is records. What is the way to avoid that problem?<BR/><BR/>Regards,<BRAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-38185855806043354292008-05-23T07:45:00.000+02:002008-05-23T07:45:00.000+02:00Ronald;We stumbled upon this very problem when try...Ronald;<BR/><BR/>We stumbled upon this very problem when trying to bypass another CRM "quirk" so this has helped us a lot.<BR/><BR/>The original problem we were trying to workaround was the way CRM counts records.<BR/><BR/>We are trying to get a count of distinct contacts for some criteria. <BR/><BR/>The FetchXml aggregate=count option work really well; until we include criteria for a one-many Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-24815222310146121532008-05-01T22:33:00.000+02:002008-05-01T22:33:00.000+02:00Hi Ronald,Is there a way to capture the fetchXML f...Hi Ronald,<BR/><BR/>Is there a way to capture the fetchXML for a users current view. <BR/><BR/>I checked out your script to grab the fetch in advanced find<BR/><BR/>javascript:prompt("my query:", resultRender.FetchXml.value);<BR/><BR/>just cant seem to get the fetchXML for a currently selected view. I want to grab it and send it off to an server side function that processes records for bulk Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-1165326463564748752006-12-05T14:47:00.000+01:002006-12-05T14:47:00.000+01:00Hi John,Searching on google (keywords: crm phoneca...Hi John,<BR/><BR/>Searching on google (keywords: crm phonecall from to) found me this page:<BR/><BR/>http://groups.google.nl/group/microsoft.public.crm.developer/browse_thread/thread/fe8955286b49cafa/dea7c337c855095a?lnk=st&q=&rnum=2&hl=nl#dea7c337c855095a<BR/><BR/>The code described there is:<BR/>public Guid CreatePhoneCallActivity(string subject, string description, <BR/>Guid to, string toType,Ronald Lemmenhttps://www.blogger.com/profile/11930631598114156863noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-1165300066573748382006-12-05T07:27:00.000+01:002006-12-05T07:27:00.000+01:00Hi RonaldHow to create Activities(PhoneCall,Fax an...Hi Ronald<BR/><BR/>How to create Activities(PhoneCall,Fax and etc) in MS CRM 3.0.I have lot of confusion while creating Phonecall where passing the values of properties "from" and "to".<BR/><BR/>So Could u plz help me.<BR/><BR/>Thanks in Advance.<BR/><BR/>Regards<BR/>JohnAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-1164967059906022092006-12-01T10:57:00.000+01:002006-12-01T10:57:00.000+01:00Hello Ronald,I Need some help from you regarding ...Hello Ronald,<BR/>I Need some help from you regarding how to assign activities to Lead Programmatically.<BR/><BR/>So Could you please help me in this regard.<BR/><BR/>Regards<BR/>AlexAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-1164881041362691562006-11-30T11:04:00.000+01:002006-11-30T11:04:00.000+01:00Hi Chanti,Good luck with your CRM project! If you ...Hi Chanti,<BR/><BR/>Good luck with your CRM project! If you have any questions, just ask the public newsgroups or post your question to the crm sandbox site: http://codegallery.gotdotnet.com/crm<BR/><BR/>Kind regards,<BR/><BR/>RonaldRonald Lemmenhttps://www.blogger.com/profile/11930631598114156863noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-1164880592003976252006-11-30T10:56:00.000+01:002006-11-30T10:56:00.000+01:00Hi RonaldRemember me? I am chanti.Got Useful infor...Hi Ronald<BR/><BR/>Remember me? I am chanti.Got Useful information from you so far regarding creating SalesOrder and etc.<BR/><BR/>Now I am Completely entering into Our Domain(CRM).Means New Project will be strated by next week.I need Your help as i am new to CRM and to gain and learn good knowledge in MS CRM.I hope that you should.<BR/><BR/>Anyhow I will be in touch with you if i have any doubtsAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-1160652225372741272006-10-12T13:23:00.000+02:002006-10-12T13:23:00.000+02:00Hi Chanti,Please let me correct the url of my last...Hi Chanti,<BR/><BR/>Please let me correct the url of my last message. The correct url is:<BR/>http://msdn.microsoft.com/library/en-us/CrmSdk3_0/htm/v3d0usingcrmtypes.asp<BR/>This url explains how to work with the crm types. When you look to that page, then you'll notice some differences with your code.<BR/>so.customerid.type = "account" should be so.customerid.type = EntityName.account.ToString()Ronald Lemmenhttps://www.blogger.com/profile/11930631598114156863noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-1160650704392049782006-10-12T12:58:00.000+02:002006-10-12T12:58:00.000+02:00Hi Ronald,Thanks for Youe Reply.I have tried with ...Hi Ronald,<BR/><BR/>Thanks for Youe Reply.<BR/>I have tried with this code.<BR/><BR/>salesorder so = new salesorder();<BR/> <BR/> //Set the properties<BR/>so.ordernumber = "98489";<BR/>so.name = "HP PC";<BR/>so.customerid = new Customer();<BR/>so.customerid.Value = new Guid("556E49E6-581B-4B61-91E4-6A7E7E8E6A9E");<BR/>so.customerid.type = "account";<BR/>so.totalamountAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-1160645716086084522006-10-12T11:35:00.000+02:002006-10-12T11:35:00.000+02:00Hi Chanti,You're heading the good way. For the val...Hi Chanti,<BR/><BR/>You're heading the good way. For the value of the customerid you should fill in the guid (unique identifier) of the account or contact you want to attach this to. You should have that guid in your code, or you can use the Fetch webmethod to find it. For testing purposes you can just enter a hardcoded guid just like you posted. You should then take the guid of an account/Ronald Lemmenhttps://www.blogger.com/profile/11930631598114156863noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-1160644757392185922006-10-12T11:19:00.000+02:002006-10-12T11:19:00.000+02:00Hi Ronald,Thakns for your Response and I have one ...Hi Ronald,<BR/><BR/>Thakns for your Response and I have one more confusion.<BR/><BR/>For Example I am Creating SalesOrder(whatever the entity is),<BR/>I want to pass the CustomerID(Or some Parameter which Returns LookUp/PriceList/Guid)then what can i do.<BR/><BR/>Actually what i am writing is<BR/><BR/>SalesOrder objSalesorder=new SalesOrder();<BR/>so.name="CRM";<BR/>so.CustomerId=new Customer();<Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-1160637125560334492006-10-12T09:12:00.000+02:002006-10-12T09:12:00.000+02:00Hi Chanti,The creation of a salesorder is fairly e...Hi Chanti,<BR/><BR/>The creation of a salesorder is fairly equal to the creation of any other entity. When creating a SalesOrder, then keep in mind that you use the field CustomerId for the relationship with an account. <BR/><BR/>If this doesn't solve your issue, then either post the error message you're receiving to the newsgroup or mail me the issue: ronaldl at avanade dot com.<BR/><BR/>Kind Ronald Lemmenhttps://www.blogger.com/profile/11930631598114156863noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-1160625903645385312006-10-12T06:05:00.000+02:002006-10-12T06:05:00.000+02:00Hello RonaldI am new to CRM and have a Confusion r...Hello Ronald<BR/>I am new to CRM and have a Confusion regarding to create a SalesOrder Programmatically.I tried a lot but not able to get a result.I got solution for another query so far and Thankful to you.<BR/>At this moment,I am expecting the same Response from you as early as possible.I need it very urgent.<BR/><BR/>So Could you please give me solution step by step to create SalesOrder Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-1156936940718234682006-08-30T13:22:00.000+02:002006-08-30T13:22:00.000+02:00Hi Someswar,The _dataHandler30. was a piece of cod...Hi Someswar,<BR/><BR/>The _dataHandler30. was a piece of code I forgot to remove. It's updated now and should work.<BR/><BR/>Kind regardsRonald Lemmenhttps://www.blogger.com/profile/11930631598114156863noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-1156936303710676632006-08-30T13:11:00.000+02:002006-08-30T13:11:00.000+02:00Hello RonaldI am new to CRM and I am not getting t...Hello Ronald<BR/><BR/>I am new to CRM and I am not getting the meaning for _dataHandler30.What does it mean exactly.<BR/><BR/>Plz Let me know ASAP.<BR/><BR/>Regards<BR/>Someswar<BR/><BR/>someswar.m@gmail.comAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-1155719380330409262006-08-16T11:09:00.000+02:002006-08-16T11:09:00.000+02:00You are indeed right. I've updated the blog. Thank...You are indeed right. I've updated the blog. Thanks!Ronald Lemmenhttps://www.blogger.com/profile/11930631598114156863noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-1155717903388371702006-08-16T10:45:00.000+02:002006-08-16T10:45:00.000+02:00just check SDK chm, "registry settings" section......just check SDK chm, "registry settings" section...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-1155672010283346682006-08-15T22:00:00.000+02:002006-08-15T22:00:00.000+02:00Interesting reply. I'll test this tomorrow!Interesting reply. I'll test this tomorrow!Ronald Lemmenhttps://www.blogger.com/profile/11930631598114156863noreply@blogger.com