Skip to Content
0

Query for OCLG (Activity)

Jan 25 at 02:36 AM

41

avatar image
I H

Dear Experts,

I want to generate a query report for activity, and have some selection criteria.

One of them is Source Object Type from linked document tab.

the field name is Parenttype.

My query is something similar like this

SELECT....

FROM...

WHERE Parenttype=[%1]

At the selection criteria, it will only returm the number for the parent type.

Let say, if the source object type is opportunity, it will return number 97.

How can I made the selection criteria for the parent type, if it is opportunity, it will return opportunity, instead of 97,

service call, instead of 191

Is there any table that i need to add or link together?

Thank you in advance

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

I H Jan 30 at 03:24 AM
0

Dear Experts,

Any suggestion of this issue?

Thank you

Share
10 |10000 characters needed characters left characters exceeded