Customer experience | Sales, Customer Insights,...

From and To fields in phone call form

(0) Share

Report

Posted on by Maryam_m

hello every one

Can anyone tell me where can I find the from and to fields in phone call form? I need to select them in sql query but I cant find them in dynamics crm 365

This is my query:

select from,to from phonecall

but from and to are invalid columns in sql. I also search in activity party and activity pointer for this two fields but I couldn't find them!!!

All responses (3)

Answers (0)

Maryam_m 62 on at

Like (0)

Report

RE: From and To fields in phone call form

Hi Carlos.

Thanks for your answer I saw the link that you sent and studied that but still I cant understand how and by what query I can see the from and to fields in sql
Suggested answer

PabloCRP 1,086 on at

Like (0)

Report
RE: From and To fields in phone call form

Hi try using this,

SELECT [from],[to] FROM phonecall

regards
Carlos Eduardo Font... on at

Like (1)

Report

RE: From and To fields in phone call form

Hello Maryam,

I hope you are doing well and safe.

The better way to see it is using activityparty table. Check the oficial documentation about it here: docs.microsoft.com/.../activityparty-entity

Let me know if something else is needed.

Kind regards,