Hello!
I need to select all phonecalls where field "From" not contains any values (after selected I want to update this record).
How I could make that from C# (I have created workflow activity)?
I try to use QueryByAttribute and QueryExpression but I didn't make it (I got an error..)
Could anybody help me?
*This post is locked for comments
Share
Report
All responses (
Answers (
var query = new QueryExpression
{
ColumnSet = new ColumnSet(false),
EntityName = "phonecall"
};
query.Criteria.AddCondition("from", ConditionOperator.Null);
var phoneCalls = service.RetrieveMultiple(query);
Thanks for help!
I solved my task.
For debugging, just through InvalidPluginExecutionException somewhere and pass a message.. if it's async workflow, you'll see that exception in the system jobs. If it's a sync workflow, you'll see it in the user interface right away.
I'd go with what Vikas has suggeted, really. You can download Fetch from AdvancedFind and use it in your code.. Although, I'm not sure why he put quotes around fetchxmlstring there (typo mistake:) ), but this should work:
************
Download the FetchXML from advance find. Then use below to get records
var entities = service.RetrieveMultiple(new FetchExpression(fetchxmlstring)).Entities;
--
Anatoliy,
That should help - ssharmacrm.wordpress.com/.../how-to-debug-a-custom-workflow-activity-in-dynamics-crm
I have an issue: how I could debugging custom workflow activity? As variant - create console application with same code.. May be you know better cases?
Hello Anatoliy,
what the error you are getting in this.?
Download the FetchXML from advance find. Then use below to get records
service.RetrieveMultiple(new FetchExpression("fetchxmlstring");
You can use the FetchXML Builder in the XRM toolbox and save it as a C# QueryExpression
// Instantiate QueryExpression QEphonecall
var QEphonecall = new QueryExpression("phonecall");
QEphonecall.Distinct = true;
// Add columns to QEphonecall.ColumnSet
QEphonecall.ColumnSet.AddColumns("subject", "statecode", "prioritycode", "scheduledend", "createdby", "regardingobjectid", "activityid");
QEphonecall.AddOrder("subject", OrderType.Ascending);
// Add link-entity QEphonecall_activityparty
var QEphonecall_activityparty = QEphonecall.AddLink("activityparty", "activityid", "activityid");
QEphonecall_activityparty.EntityAlias = "aa";
// Define filter QEphonecall_activityparty.LinkCriteria
QEphonecall_activityparty.LinkCriteria.AddCondition("partyid", ConditionOperator.Null);
Hi,
In order to query party list fields, see the link below.
https://community.dynamics.com/crm/b/crmshafraz/archive/2009/08/19/querying-a-partylist-field
#1
André Arnaud de Cal...
292,850
Super User 2025 Season 1
#2
Martin Dráb
231,723
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
