No announcements
Found 65195 threads
-
1 VotesAggregate functions in Query Expression
It is not possible to aggregate with queryexpression, you need to use FetchXml to get aggegate data from CRM.Answered | 3 Replies | 12066 Views | Created by aslamd - Wednesday, October 20, 2010 7:07 AM | Last reply by Amarsen Vangoor - Wednesday, October 20, 2010 12:33 PM
-
0 Votes
Aggregate functions
and even if it does there is no mention of all the possbile aggregate functions such as min and max.Answered | 4 Replies | 7529 Views | Created by Shafeeq Hussain - Thursday, May 7, 2009 8:31 AM | Last reply by Nishant Rana - Thursday, May 7, 2009 1:47 PM -
1 Votes
Exact Difference between Query expression and fetchXML
Use this query language when you need support for aggregates and grouping or you need to save the query.Answered | 1 Replies | 9609 Views | Created by Ayazahmed - Saturday, May 9, 2015 4:40 PM | Last reply by Madhu_M - Monday, May 11, 2015 1:06 AM -
2 Votes
Aggregate and advanced queries for a CRM custom view
Advanced find can't show aggregate result in a grid.Answered | 4 Replies | 8136 Views | Created by Richard Magee - Wednesday, June 12, 2013 12:42 PM | Last reply by Adi Katz - Wednesday, August 6, 2014 11:12 AM -
0 Votes
is inside a scope that defines a variable that is used in a lambda or query expression
Hello, when I use lambda function and goto in same sub or function, I am getting that error message.Answered | 1 Replies | 12553 Views | Created by emil_tr - Thursday, October 21, 2010 4:22 PM | Last reply by Shivendra Pratap Singh - Friday, November 26, 2010 8:48 AM -
0 Votes
Include Aggregate Value in a View
Darn Microsoft gives you half of a function and forgets about the rest!Answered | 2 Replies | 3237 Views | Created by berel_lax - Saturday, December 8, 2012 6:58 PM | Last reply by berel_lax - Monday, December 10, 2012 5:19 PM -
1 Votes
Aggregate and LinkEntity in FetchXml
Thank you so much for taking the time to translate the sql query!Answered | 2 Replies | 5612 Views | Created by Kristine L. Jongstra - Wednesday, March 6, 2013 2:54 PM | Last reply by Kristine L. Jongstra - Thursday, March 7, 2013 9:20 PM -
2 Votes
CRM 2011 views with aggregates
Is there any (Proper) solution from MS for this kind of aggregate values situation in CRM 2013??Answered | 3 Replies | 2640 Views | Created by Gabriel.Fernandez.Perez - Monday, May 20, 2013 10:09 AM | Last reply by ANSrikanth - Friday, May 16, 2014 8:47 PM -
0 Votes
Cannot find either column "mdm" or the user-defined function or aggregate "mdm.Get_USER
"|Cannot find either column "mdm" or the user-defined function or aggregate "mdm.Get_USER", or the name is ambiguous.Answered | 1 Replies | 1118 Views | Created by NivyaV - Thursday, January 24, 2019 8:53 PM | Last reply by Dave Patrick - Thursday, January 24, 2019 9:00 PM -
1 Votes
Query Expression with Option Sets
: RetrieveMultipleRequest req = new RetrieveMultipleRequest { Query = query }; RetrieveMultipleResponse resp = ...Answered | 2 Replies | 6648 Views | Created by MeProgrammer - Wednesday, June 27, 2012 3:29 PM | Last reply by MeProgrammer - Thursday, June 28, 2012 12:36 PM -
0 Votes
QueryExpression challenge - can I express a negative query using query expression?
As you said, CRM does not support “not in” queries.Answered | 3 Replies | 5817 Views | Created by Feridun Kadir MCT - Tuesday, April 28, 2009 6:11 PM | Last reply by JuergenBeck - Wednesday, April 29, 2009 8:07 AM -
4 Votes
Expressing a SQL query in JavaScript.
function getOriginatingEmailFirstQueue(originalEmailId) { var authenticationHeader = GenerateAuthenticationHeader(); // Prepare the SOAP ...Answered | 3 Replies | 10025 Views | Created by Tamim Sadikali - Thursday, February 17, 2011 12:59 PM | Last reply by Tamim Sadikali - Friday, February 18, 2011 3:12 PM -
1 Votes
difference between fetchxml and query expression ?
See the following CRM SDK documentation for a run down of what each can provide: http://msdn.microsoft.com/en-us/library/bb928429.aspx FetchXml allows the ...Answered | 1 Replies | 8682 Views | Created by Crane kes - Wednesday, February 16, 2011 8:39 AM | Last reply by pogo69 - Wednesday, February 16, 2011 8:47 AM -
0 Votes
Regarding Query expression
Use the page and count attributes / PageInfo (in query expression) to set the number of retrieved records.Answered | 7 Replies | 5104 Views | Created by samuel s - Thursday, July 22, 2010 11:27 AM | Last reply by Adi Katz - Thursday, July 22, 2010 1:15 PM -
0 Votes
Translation to expression tree and query execution??
I need to build linq queries dinamically and i think the only way to do it is with expression trees.Answered | 1 Replies | 8658 Views | Created by spaiva - Thursday, February 5, 2009 4:17 PM | Last reply by Shrikant Maske - Wednesday, February 18, 2009 10:44 AM -
1 Votes
Is there any tool to build Fetch XML and Query expression?
and if you are specifically looking for QueryExpression query, you can always use FetchXmlToQueryExpressionRequest class in SDK to convert FetchXML to query.Answered | 4 Replies | 2930 Views | Created by Yogesh Mulay - MCTS - Thursday, January 17, 2013 1:42 PM | Last reply by Yogesh Mulay - MCTS - Thursday, January 17, 2013 2:12 PM -
0 Votes
Podcast Aggregator on WHS
I think you're best bet would be to run any podcast aggregator on your PC and save the podcasts to a network folder on the WHS.Answered | 3 Replies | 8385 Views | Created by tjack777 - Tuesday, January 13, 2009 6:47 PM | Last reply by dear chap - Friday, January 16, 2009 3:28 PM -
0 Votes
CRM 2011 Query Expression with linked entity
0) { foreach (Entity e in results.Entities) { if ...Answered | 3 Replies | 2836 Views | Created by TCavins - Thursday, March 28, 2013 8:26 PM | Last reply by TCavins - Thursday, March 28, 2013 11:32 PM -
0 Votes
Reproduce "Effective Rights" function in an SQL query?
Hi, as Paul wrote, it is not supported, so I will not paste any query here.Answered | 3 Replies | 1069 Views | Created by Jackson Cole - Wednesday, May 10, 2017 12:28 PM | Last reply by Barbara Henhapl - Wednesday, May 10, 2017 6:03 PM -
1 Votes
CRM Online Fetch Based Report - Problem With Expressions
Hi, It will be better if you explain what you want to do with this expression.Answered | 2 Replies | 1647 Views | Created by James Bratley - Tuesday, May 21, 2013 9:30 AM | Last reply by VidhiyaM - Tuesday, May 21, 2013 11:23 AM - Items 1 to 20 of 65195 Next ›
No announcements
