Skip to Content

Query for OCLG (Activity)

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 30 at 03:24 AM

    Dear Experts,

    Any suggestion of this issue?

    Thank you

    Add comment
    10|10000 characters needed characters exceeded