No announcements
Found 317606 threads
-
0 VotesSDK.Query.QueryExpression - Count in Select clause
Using c#, I need to build a query using the SDK.Query.QueryExpression library for Microsoft Dynamics 2015. I am unable to figure out how to order and count the number of ...Answered | 3 Replies | 2190 Views | Created by Christo Vermeulen - Thursday, September 3, 2015 12:11 PM | Last reply by Mr. Santosh Bhagat - Tuesday, September 15, 2015 10:35 AM
-
0 Votes
Select clause
Do you need to run the query in SQL? You can use the advanced find to do it in UI.Jackie Chen, Microsoft Online Community Support. Please remember to click “Mark as ...Unanswered | 1 Replies | 1009 Views | Created by Brownink58 - Wednesday, August 7, 2013 5:07 PM | Last reply by Jackie Chen[MSFT] - Monday, August 12, 2013 2:54 AM -
0 Votes
NOT IN clause
campaign response is manually created, user can always select the contact this is for. For any other automated ones make sure the system filling populates this contact ...Proposed | 3 Replies | 953 Views | Created by Joakim_Bergmark_APSIS - Tuesday, March 10, 2015 9:14 PM | Last reply by Minal Dahiya - Friday, March 13, 2015 10:33 AM -
1 Votes
Count unique values in a field that is not included into the group by clause
DateFrozen. Each combination of PatID and DateFrozen constitutes a record. Embryos frozen from the same patient 1 or 2 days apart are stored in the same Tank, Canister and Cane. I ...Proposed | 1 Replies | 13472 Views | Created by andras53 - Monday, January 10, 2011 10:07 PM | Last reply by Sheng Jiang 蒋晟 - Monday, April 25, 2011 9:57 PM -
0 Votes
CRM Online 'Having' clause in fetchXml
Hi, I have a request which has to use aggregation, more specifically, 'Having' clause in fetchXml. The equivalent SQL query ...Unanswered | 2 Replies | 2677 Views | Created by chicago bq - Tuesday, August 2, 2016 4:06 PM | Last reply by DavidJennaway - Thursday, August 4, 2016 8:34 AM -
0 Votes
Filter clause in microsoft sync 2.1
in the select changes stored proc, so any condition that wont break the WHERE clause will work...Answered | 8 Replies | 7144 Views | Created by Veera G - Thursday, May 3, 2012 1:26 PM | Last reply by JuneT - Wednesday, July 11, 2012 1:11 AM -
1 Votes
Select count(*) in a CRM 2011 view column
Vikranth http://howto-mscrm.blogspot.com "Please Mark it as answer if it helps in resolving your query"Answered | 3 Replies | 2448 Views | Created by Gabriel.Fernandez.Perez - Wednesday, December 12, 2012 11:16 AM | Last reply by Vikranth Pandiri - Wednesday, December 12, 2012 1:02 PM -
0 Votes
Sync Framework Toolkit Filter Clause Config Wizard Where Clause
;'tableA' the table the wizard it pre-populates the filter clause with [side].colA = @colA but what I want to do is filter TableA Where colA <> '6' like the sql statement ...Proposed | 5 Replies | 6319 Views | Created by V.Moss - Monday, October 15, 2012 5:44 PM | Last reply by vmoss - Thursday, October 25, 2012 4:59 PM -
0 Votes
How do I use "IN" clause in LINQ?
Hello Everyone I have a list of guids. e.g contact id(s). It can contact 1 or more guids. How do I write IN clause in LINQ when I am ...Proposed | 2 Replies | 2983 Views | Created by WPF_Dev - Friday, April 20, 2012 4:09 PM | Last reply by pogo69 - Friday, April 20, 2012 8:34 PM -
1 Votes
<count>0<count>
<count>0<count> what does this mean?DustinAnswered | 1 Replies | 5069 Views | Created by mindonmoney100 - Sunday, May 13, 2012 8:25 AM | Last reply by Vicky Song - Monday, May 14, 2012 5:30 AM -
2 Votes
Multiple condition on Filtering clause
if the 'List of Category' for a user is in a table, you can define a filter column for the user. the filter clause would look like ...Answered | 3 Replies | 6426 Views | Created by hanami279 - Wednesday, November 17, 2010 5:49 PM | Last reply by JuneT - Thursday, November 18, 2010 4:01 AM -
0 Votes
Sync Framework 2.1 Filter 'IN' Clause
JuneT, Thanks for the reply. Ideally I would like a query similar to the below but the 'IN' clause could be quite ...Answered | 10 Replies | 1515 Views | Created by pr_wainwright - Friday, November 7, 2014 5:23 PM | Last reply by pr_wainwright - Thursday, November 20, 2014 8:12 AM -
1 Votes
Using JOIN in Select statement
Hi All i am using the below SQL statement in VB.net but it give me the error "Syntax error in FROM clause." dont know what is wrong i this ...Unanswered | 3 Replies | 525 Views | Created by Ali Jan Eqbali - Monday, July 11, 2016 6:58 AM | Last reply by DA924x - Monday, July 11, 2016 12:54 PM -
0 Votes
Advanced find "NOT" clause
Is it possible to do an advanced find query with a NOT have clause... Basically we would like to be able to find all contacts which have not had an appointment scheduled ...Answered | 4 Replies | 5105 Views | Created by Paulo - Pareto Platform - Wednesday, August 18, 2010 3:57 PM | Last reply by Mayank Pujara - Thursday, August 19, 2010 8:49 AM -
0 Votes
Complicated WHERE clause
, applicationOrganizations, applicationOrganizations.application.person" OrderBy="it.organizationName" Where="EXISTS(SELECT VALUE t FROM ...Unanswered | 1 Replies | 2794 Views | Created by GWJones12 - Friday, September 21, 2012 10:40 PM | Last reply by Alexander Sun - Monday, September 24, 2012 7:16 AM -
0 Votes
How do I use "in" where clause in LINQ when retrieving records/entities in Microsoft CRM?
_adUserDatas.fan select _adUserDatas; When I changed it to use the contacts entity in Microsoft CRM, it is throwing an exception and it says my where ...Unanswered | 2 Replies | 649 Views | Created by MrJayViper - Friday, July 11, 2014 3:23 AM | Last reply by Sachith Vidanage - Friday, July 11, 2014 6:04 AM -
0 Votes
Select item in UltraListView
how could i select item in UltraList view whem I Mouse right clicked on itUnanswered | 1 Replies | 8675 Views | Created by Asker_Girl - Wednesday, August 5, 2009 10:31 AM | Last reply by Asker_Girl - Sunday, August 9, 2009 6:45 AM -
0 Votes
Custom field: Use where clause with tasks?
not WHERE clause in custom field calculation, I don't know how to do that and is it possible? Thank you for your help :)Unanswered | 2 Replies | 2045 Views | Created by freedumz - Wednesday, March 20, 2019 10:35 AM | Last reply by Prasanna Adavi - Monday, April 8, 2019 1:32 PM -
0 Votes
Login Count
Credentials.We have to get "Logincount" as many time he/she loged in to the portal. We are also using Global.asax file. Login Count is an attribute(Field) ...Discussion | 0 Replies | 2516 Views | Created by Marketing_ecssi.com - Monday, December 12, 2011 5:06 AM -
0 Votes
Citation count
dear admin, it has been for long time, the citations count to my papers do not appear in microsoft academic search and in my profile. - Items 1 to 20 of 317606 Next ›
No announcements
