how to verify value of a simple text field in My CRM console application

(0) Share

Report

Posted on by Community Member

now my requirement from customer..
i have bill id from third part system.
i wanted to verify bill id is exist or not in entity(kcd_creditrisk) ,field name(kcd_billingid) as simple test..
please help me .
Venkat

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Ivan Ficko 1,380 on at

Like (0)

Report
You need to write a simple query that retrieves all entities that have kcd_billingid equals to your bill id value.

var fetchXml=@"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'> <entity name='kcd_creditrisk'> <attribute name='kcd_creditriskid' /> <filter type='and'> <condition attribute='kcd_billingid' operator='eq' value='<YOUR_BILL_ID_VALUE_HERE>' /> </filter> </entity> </fetch>"; var exists = service.RetrieveMultiple(new FetchExpression(fetchXml)).Entities.Any();

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ficko,

in provided code

<attribute name='kcd_creditriskid' />----> is it guid id?

Venkat

Was this reply helpful? Yes No
Suggested answer

Ivan Ficko 1,380 on at

Like (0)

Report

Yes, this value is GUID of your entity.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Hi Venkat,

happy to help you again :-)

Please use the following code:

QueryByAttribute query = new QueryByAttribute("kcd_creditrisk"); query.ColumnSet = new ColumnSet("createdon"); query.Attributes.AddRange("kcd_billingid"); query.Values.AddRange(thebillingidvalue); Entity entity = svc.RetrieveMultiple(query).Entities.ToList().FirstOrDefault(); // credit risk found if (entity != null) { // do something } // credit risk NOT found else { // do something else }

Please let me know.

If you found the answer helpful, please mark as Verified

Join my network on LinkedIn Follow me on Twitter

Thank You & Best Regards

Francesco Picchi

Microsoft Dynamics CRM Consultant, Bologna, ITALY

Independent Contractor

http://www.francescopicchi.com

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi venkataramana,

if you solved the problem thanks to an answer, please mark it as verified to encourage the community to provide more and more a better support. Thank you. Francesco

If you found the answer helpful, please mark as Verified

Join my network on LinkedIn Follow me on Twitter

Thank You & Best Regards

Francesco Picchi

Microsoft Dynamics CRM Consultant, Bologna, ITALY

Independent Contractor

http://www.francescopicchi.com

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi venkataramana,

if you solved the problem thanks to an answer, please mark it as verified to encourage the community to provide more and more a better support. Thank you. Francesco

If you found the answer helpful, please mark as Verified

Join my network on LinkedIn Follow me on Twitter

Thank You & Best Regards

Francesco Picchi

Microsoft Dynamics CRM Consultant, Bologna, ITALY

Independent Contractor

http://www.francescopicchi.com

Was this reply helpful? Yes No
TomSmelser 1,570 on at

Like (0)

Report

If you are returning multiple records in your query the you want to check each one.

Something like this would work:

foreach (Entity rec in ec.Entities)
{
if (rec.Contains("kcd_billingid"))
{
// value exists
}
}

Was this reply helpful? Yes No
Suggested answer

SavvyLuke 655 on at

Like (0)

Report
Why not just check using GetAttributeValue after you do your query expression. For example:

Guid billingId = Guid.Empty;
//queryexpression stuff here billingId = ec.GetAttributeValue<Guid>("kcd_billingid");

Was this reply helpful? Yes No