custom workflow activity

(1) Share

Report

Posted on by Mona Chavan

255

I am very new for writing custom workflow activity

can anybody tell me how can i retrive last modified related records from subgrid for perticular record using fetch xml.

Scenaro:

i have case entity and Case-contact

case entity have subgrid of Case-contact

i want to retrive last modified Case contact if case have multiple Case contacts.

can anyone share code for this.

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

Pawar Pravin 5,237 on at

Like (0)

Report
RE: custom workflow activity

Hi Mona,

I would suggest you to create query in advance find as shown in below snapshot.

add sub-grid entity as "Look For" and add related entity.

then click on edit column and add sort column with modified

query should look like below

Was this reply helpful? Yes No
Verified answer

Naveen Ganeshe 3,397 User Group Leader on at

Like (1)

Report
RE: custom workflow activity

Hello Mona,

See below fetch. It will return you only the last modified record:

Also, don't forget to change the attribute: "incidentfieldname" and entity name "casecontact" with the actual ones.

Hope it will help you

Was this reply helpful? Yes No
Mona Chavan 255 on at

Like (0)

Report

RE: custom workflow activity

Thanks all for reply.

now for the last modified client contact i have related appointment activities.

from these activities i need to pickup last modified appointment .

but in advance find i am not able to get "modified on" attribute for for appointments in edit columns

so i can use two fetch xml

1)to get last modified client contact (only for client contact)

2) To get appoitments related to retrived client contact by passing id to this fetch xml

Is this right?

Was this reply helpful? Yes No
Suggested answer

Pawar Pravin 5,237 on at

Like (0)

Report

RE: custom workflow activity

I can see "modified on" in advance find

Anyway if you are unable to see in advance find still you can add it manually in fetchxml.

Was this reply helpful? Yes No
Mona Chavan 255 on at

Like (0)

Report

RE: custom workflow activity

Yes it is visible when i search Appointment separately in "Look for" , but if i am looking in one advance find it self with the relation from case-->Client contact-->appointments

the its is not visible. refer the screen shot below.

Note:in filter criteria i need to select client contcats base on mentioned conditions as well

so to get Appointments last modified from above fetch i am not able to add "modified on" column for appointment entity.

so is it good to write two fetch xml

step 1) to get last modified client contact

step 2)fetch last modified Appointmnet and passing the step 1 client contact id to this fetch.(i will get last modified appointment for the client contact if there are multiple appointments)

what am i thinking is right?

Was this reply helpful? Yes No
Suggested answer

Pawar Pravin 5,237 on at

Like (0)

Report

RE: custom workflow activity

Yes, I think you should have to use two different fetchxml if that is the case if you are unable to see it in add column

Was this reply helpful? Yes No