Select all phonecalls where "From" is null

(0) Share

Report

Posted on by Anatoliy Veshemirsky

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

I have the same question (0)

All responses (14)

Answers (3)

Community Member on at

Like (0)

Report

RE: Select all phonecalls where "From" is null

Try below

Was this reply helpful? Yes No
Suggested answer

Nithya Gopinath 17,078 on at

Like (0)

Report

RE: Select all phonecalls where "From" is null

Hi Anatoliy,

Why should you use C# code for the same? Using advanced find, we can filter out the phone call records and could bulk edit these records accordingly.

Was this reply helpful? Yes No
Anatoliy Veshemirsky on at

Like (0)

Report

RE: Select all phonecalls where "From" is null

I need to do this from C# (in my workflow activity)

Was this reply helpful? Yes No
Anatoliy Veshemirsky on at

Like (0)

Report

RE: Select all phonecalls where "From" is null

I try to do it:

QueryByAttribute phonecall = new QueryByAttribute("phonecall");

phonecall.ColumnSet = new ColumnSet(true);

phonecall.AddAttributeValue("from",Guid.Empty);

phonecall.AddAttributeValue("directioncode",0);

EntityCollection retrieved = _service.RetrieveMultiple(phonecall);

but it doesn't work..

Was this reply helpful? Yes No
Suggested answer

Nithya Gopinath 17,078 on at

Like (0)

Report

RE: Select all phonecalls where "From" is 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

Was this reply helpful? Yes No
Verified answer

Thomas David Dayman 11,323 on at

Like (0)

Report

RE: Select all phonecalls where "From" is null

You can use the FetchXML Builder in the XRM toolbox and save it as a C# QueryExpression

http://prntscr.com/f1sh4r

// 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);

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

RE: Select all phonecalls where "From" is null

Download the FetchXML from advance find. Then use below to get records

service.RetrieveMultiple(new FetchExpression("fetchxmlstring");

Was this reply helpful? Yes No
EmployeeOcta 6 on at

Like (0)

Report

RE: Select all phonecalls where "From" is null

Hello Anatoliy,

what the error you are getting in this.?

Was this reply helpful? Yes No
Anatoliy Veshemirsky on at

Like (0)

Report

RE: Select all phonecalls where "From" is null

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?

Was this reply helpful? Yes No
Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (0)

Report

RE: Select all phonecalls where "From" is null

Anatoliy,

That should help - ssharmacrm.wordpress.com/.../how-to-debug-a-custom-workflow-activity-in-dynamics-crm

Was this reply helpful? Yes No