Customer experience | Sales, Customer Insights,...

ConditionOperator.In example

(0) Share

Report

Posted on by rajkm

I need to import entityimage(byte array[]) from D365 CE Contact entity.

I need to bring all contacts with entityimageurl is not null.

I have imported contact entity to local sqldb using DES. I can see imageurl field but not entityimage field(byte array)

I have created console application which

1. Reads all contacts with entityimageurl IS NOT NULL (stores all contactsid into an array)

2. The same contactid(s) I need to supply as filters to

QueryExpression qe = new QueryExpression("contact");
qe.ColumnSet.AddColumns("contactid", "entityimage", "createdon", "modifiedon");
qe.Criteria.AddFilter(filter1);
qe.Criteria.AddFilter(filter2);
//qe.Criteria.AddFilter(filter2end); //used when using between dates and times
//qe.Criteria.AddFilter(filter3);

EntityCollection result = Service.RetrieveMultiple(qe);

How can I pass contacts array to QueryExpression?

In sql world, I need something like IN operator

Regards

Raj

All responses (3)

Answers (0)

rajkm 65 on at

Like (0)

Report

RE: ConditionOperator.In example

Hi Manoj Mane

Thanks for the reply.

If the query returns even 900 rows, I am getting error "Query timeout or max size limit of 208MB reached

I thought of looping for each ContactId returned from sql query but I was told that it will send multiple requests to CRM and it may crash the live system.

What is the alternate to return image(byte array) fields

Thanks
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (0)

Report

RE: ConditionOperator.In example

Hello,

Check this - stackoverflow.com/.../ms-dynamics-queryexpression-with-conditionoperator-in-result-in-no-result-but
Suggested answer

Manoj Mane 1,020 on at

Like (1)

Report

RE: ConditionOperator.In example

Hi rajkm,

You can refer the below query syntax.

In this contacts is your array.

var queryExpression = contacts.map(contact => { return 'SELECT * FROM contacts WHERE firstName = "' + contact.firstName + '" AND lastName = "' + contact.lastName + '" AND
phoneNumber = "' + contact.phoneNumber + '"'; });

Thanks,
Manoj Mane.

Please mark this as VERIFIED if it helps.