Queryexpression retrieve

(0) Share

Report

Posted on by ah1994

195

i wanna create or update values of country based on the values of city in the account entity.can somebody guide me to obtain this.i want to retrieve city .for example city=chennai. i wanna update india(manually i want to update).so i wanna retrieve city and update country. both city and country is in account entity

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

joman 617 on at

Like (0)

Report

If you describe more clearly, what do you need, i'll help you.

As I understand, you need to write Queryexpression to retrieve something. So Describe, What do you want to query and what conditions do you need.

How city and country links with each other?

Was this reply helpful? Yes No
Gopalan Bhuvanesh 11,401 on at

Like (0)

Report

Hi

There is no data for country and city available OOB.

Was this reply helpful? Yes No
Suggested answer

ganeshm on at

Like (0)

Report

Entity contact = (Entity)context.InputParameters["Target"];

ColumnSet cols = new ColumnSet(new String[] { "col1", "col2" });

Entity entname = service.Retrieve("entityname", entity.Id, cols);

using retrieve u can get the current instance of the record ,so retrieve it compare it

Was this reply helpful? Yes No
ah1994 195 on at

Like (0)

Report

i want to retrieve city .for example city=chennai. i wanna update india(manually i want to update).so i wanna retrieve city and update country. both city and country is in account entity

Was this reply helpful? Yes No
joman 617 on at

Like (0)

Report

Is Country entity? Is Country contains field city?

Was this reply helpful? Yes No
ah1994 195 on at

Like (0)

Report

both country and city are fields which was in account entity

Was this reply helpful? Yes No
joman 617 on at

Like (0)

Report
fields: "Address1_City" and "Address1_Country"?

It just varchar fields. If you need to fill a county, you need to make a list witch contains pair City Country to fill like you need.

Do you have this list? Is it Dynamics entity? What name and fields in it?

There is your QueryExpression. All you need is to place right names of entity and columns:

QueryExpression GetCountry = new QueryExpression()
{
EntityName = "your_CountryCityList",
ColumnSet = new ColumnSet("your_CountryName"),
Criteria =
{
FilterOperator = LogicalOperator.And,
Conditions =
{
new ConditionExpression("your_CityName", ConditionOperator.Equal, "YourCity"),
}
}
}; EntityCollection Ret = service.RetrieveMultiple(GetCountry);

Was this reply helpful? Yes No
Suggested answer

Nithya Gopinath 17,078 on at

Like (1)

Report
Hi,

You could use the code below.

QueryExpression query = new QueryExpression { EntityName = "account", ColumnSet = new ColumnSet("address1_city", "address1_country"), Criteria = new FilterExpression { Conditions = { new ConditionExpression { AttributeName = "address1_city", Operator = ConditionOperator.NotNull } } } }; EntityCollection ec = service.RetrieveMultiple(query); if (ec.Entities.Count > 0) //Check for EntityCollection count { foreach (var item in ec.Entities) { if (item.Attributes["address1_city"].ToString() == "Chennai") { item.Attributes["address1_country"] = "India"; service.Update(item); } } }

Hope this helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks! It worked for us.

Was this reply helpful? Yes No