tag:blogger.com,1999:blog-14479009.post116237056429062638..comments2023-11-24T12:30:17.358+01:00Comments on Ronald Lemmen - CRM, C# and Cme: Using the Advanced Find for FetchXML builderRonald Lemmenhttp://www.blogger.com/profile/11930631598114156863noreply@blogger.comBlogger21125tag:blogger.com,1999:blog-14479009.post-42964074511044344622011-02-23T15:30:55.962+01:002011-02-23T15:30:55.962+01:00I come back to this post on a regular basis - it&#...I come back to this post on a regular basis - it's such a cool hint, though I'm almost too lazy to remember the syntax! Either way - Thank you so much! <br />Perhaps another little tip worth mentioning - when you need the LayoutXml for operations, just replace it giving you: <br /><br />javascript:alert(resultRender.LayoutXml.value);<br /><br />Same great principle - works perfectly! :)Mr Bobhttps://www.blogger.com/profile/13734923062034929832noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-13002007510611077522010-04-14T16:49:36.915+02:002010-04-14T16:49:36.915+02:00Does anyone know why after upgrade of CRM from 3.0...Does anyone know why after upgrade of CRM from 3.0 to 4.0 we have a new workflowbase table that takes up 80% of the database space (1.3G)? What is in it? Can we clean it up?Lana7220noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-66888104127768880652009-11-15T18:10:14.348+01:002009-11-15T18:10:14.348+01:00Hi Ronald,
I cant use promt on ie8, ı dont know ...Hi Ronald, <br /><br />I cant use promt on ie8, ı dont know why. But there is another good solution on ie8 which is<br />javascript: clipboardData.setData("Text", resultRender.FetchXml.value);<br /><br />When you allow access fetch query is in your clipboard :)<br /><br />Ersin,Ersin Öztürkhttp://www.ersinozturk.netnoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-3473171787839666672009-08-04T11:16:56.000+02:002009-08-04T11:16:56.000+02:00Vishwas,
This would make quite a difficult query ...Vishwas,<br /><br />This would make quite a difficult query for the fetchxml. I would look into using reporting for this purpose.<br /><br />With kind regards,<br />RonaldRonald Lemmenhttps://www.blogger.com/profile/11930631598114156863noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-52197447839426310592009-07-09T17:40:28.920+02:002009-07-09T17:40:28.920+02:00Hi,
I was using your tips but on the popup the re...Hi,<br /><br />I was using your tips but on the popup the result that i get is this <br />"Specified argument was out of the range of valid values.<br />Parameter name: Expected 'safe string' data type for 'RequestUri' parameter in 'Request.QueryString'. The raw request was 'GET /_common/error/errorhandler.aspx?ErrorCode=&RequestUri=%2fDevScope%2fAdvancedFindJessicanoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-12377169597694313212009-06-15T08:53:30.375+02:002009-06-15T08:53:30.375+02:00I used advanced find window and got the results an...I used advanced find window and got the results and i pressed F11 and got the addredd bar and pasted the javascript code in the address bar it prompted me to close the existing window but did the get the query it shwed the error ad unhandeled exception , can u please help me on this... and aslo i need the query ID of that query how can i get that ..<br />please help me on this..Vishwashttps://www.blogger.com/profile/13168039020914270242noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-64982759059212186312009-06-02T14:41:58.721+02:002009-06-02T14:41:58.721+02:00Ronald,
i am trying to get the complete list of u...Ronald,<br /><br />i am trying to get the complete list of users with direct or indirect reporting to the logged in user. for the same i am tring to write the fetch xml statement but stuck in how to convert the sql CTE queries to fetch xml query ??<br /><br />do you have any suggestion on how to do that ?vishal swamihttps://www.blogger.com/profile/12498695901164843294noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-86855997213974222462008-10-21T09:43:00.000+02:002008-10-21T09:43:00.000+02:00Hi Shilpa,You can get all the information around t...Hi Shilpa,<BR/><BR/>You can get all the information around the fetchxml query on this page in the SDK: http://msdn.microsoft.com/en-us/library/bb930489.aspx<BR/><BR/>You'll see that there is an attribute for Distinct. You would use it like this:<BR/>// Retrieve all accounts.<BR/>string fetch1 = "<fetch mapping='logical' distinct="true">";<BR/>fetch1 += "Ronald Lemmenhttps://www.blogger.com/profile/11930631598114156863noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-73501888606643865762008-10-21T08:54:00.000+02:002008-10-21T08:54:00.000+02:00Hi Ronald,Thanks for ur reply.Would u pls help me ...Hi Ronald,<BR/><BR/>Thanks for ur reply.<BR/><BR/>Would u pls help me on how to use "distinct" in fetch XML query.<BR/><BR/>Thanks in advanceUnknownhttps://www.blogger.com/profile/14616980662632669093noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-57724595267515447442008-10-16T11:38:00.000+02:002008-10-16T11:38:00.000+02:00Hi Shilpa,There is no way to create a fetchxml que...Hi Shilpa,<BR/><BR/>There is no way to create a fetchxml query which contains a union. You'll need to do multiple fetch requests and combine the results in a dataset.<BR/><BR/>Hope this helps,<BR/><BR/>RonaldRonald Lemmenhttps://www.blogger.com/profile/11930631598114156863noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-43494892409231703602008-10-16T08:53:00.000+02:002008-10-16T08:53:00.000+02:00Hi Ronlad,Thanks for all ur posts.. it is of gr8 h...Hi Ronlad,<BR/><BR/>Thanks for all ur posts.. it is of gr8 help for all developers<BR/><BR/>Could you pls let me know how to combine two fetch xml queries using union clause.....<BR/><BR/>This will be of gr8 help for me....Unknownhttps://www.blogger.com/profile/14616980662632669093noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-82208668047793670942008-08-04T21:15:00.000+02:002008-08-04T21:15:00.000+02:00You can also create a bookmark so you dont have to...You can also create a bookmark so you dont have to enter the javascript into the address bar every time.<BR/><BR/>Set your bookmark to: <BR/>javascript: var x = prompt("my query:", resultRender.FetchXml.value);<BR/><BR/>The "var x = " part prevents IE from navigating away from the advanced find page.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-72442788985230280982008-06-17T14:25:00.000+02:002008-06-17T14:25:00.000+02:00Hi Boudewijn,A lookup does filter the inactive rec...Hi Boudewijn,<BR/><BR/>A lookup does filter the inactive records. You are not able to select these records in a lookup.<BR/><BR/>RonaldRonald Lemmenhttps://www.blogger.com/profile/11930631598114156863noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-28882603959245609472008-06-06T09:35:00.000+02:002008-06-06T09:35:00.000+02:00Hi Ronald,can you help me out here?I need to selec...Hi Ronald,<BR/><BR/>can you help me out here?<BR/>I need to select a fulfilled order via a lookup. It seems like the lookup itself filters out records.<BR/>(like selecting an inactive account pe.)<BR/><BR/>Regards,<BR/><BR/>BoudewijnAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-29232379605354531772007-08-21T10:43:00.000+02:002007-08-21T10:43:00.000+02:00Dear Ronald,I kinda got this working and was wonde...Dear Ronald,<BR/><BR/>I kinda got this working and was wondering if you want a copy of this html page that will be invoked via a button from the contacts window and stick a parameter in the url. This later will take the parameter paste it into the FetchXml and send this form to the fetchData.aspx and show the results.<BR/><BR/>My email is 1kevinchu1@gmail.com please contact me if you wish to get Unknownhttps://www.blogger.com/profile/05276858247082091766noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-41566716621146008852007-08-09T02:01:00.000+02:002007-08-09T02:01:00.000+02:00Hi Kevin,You can create an html page which does a ...Hi Kevin,<BR/><BR/>You can create an html page which does a post to the advanced find search result page which supplies exactly the same values as the advanced find search screen would supply. One of the values is the fetchxml. <BR/>Somewhen I will write a blog post around this, but this should get you started.<BR/><BR/>RonaldRonald Lemmenhttps://www.blogger.com/profile/11930631598114156863noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-32793478116468746012007-08-06T09:58:00.000+02:002007-08-06T09:58:00.000+02:00Hi all, I just came across this because i was tryi...Hi all, I just came across this because i was trying to use the advancedfind.aspx as a pop up page to show a list records that has many-to-many relationship with contacts.<BR/><BR/>I was wondering if i had the xml for my search query, how i can encorporate the xml with the aspx page to actually run a search without having to select my query and filling in the values.<BR/><BR/><BR/>Is there a way Unknownhttps://www.blogger.com/profile/05276858247082091766noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-30449910134517301352007-06-25T07:12:00.000+02:002007-06-25T07:12:00.000+02:00this is fantastic mate..saved my daythis is fantastic mate..saved my dayAnilhttps://www.blogger.com/profile/05635601110678610273noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-87638394651287291402007-03-29T15:58:00.000+02:002007-03-29T15:58:00.000+02:00Thanks Piotr,I've updated the post.RonaldThanks Piotr,<BR/><BR/>I've updated the post.<BR/>RonaldRonald Lemmenhttps://www.blogger.com/profile/11930631598114156863noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-44689455914377873112007-03-01T17:20:00.000+01:002007-03-01T17:20:00.000+01:00Or you can use prompt function, like:javascript:pr...Or you can use prompt function, like:<BR/>javascript:prompt("my query:", resultRender.FetchXml.value);<BR/>This will give you the query ready to copy :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-1162380706005115552006-11-01T12:31:00.000+01:002006-11-01T12:31:00.000+01:00Great tip! Especially the part about being able t...Great tip! Especially the part about being able to copy the contents of a popup to the clipboard via ctrl-c (I had no idea!) :-)<BR/><BR/><A HREF="http://advantageworks.blogspot.com" REL="nofollow">http://advantageworks.blogspot.com</A>Rosshttps://www.blogger.com/profile/12145867483724913787noreply@blogger.com