x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 1 reply
  • Subscribers 74 subscribers
  • Views 73 views
  • Users 0 members are here
Browse Forums
Announcements
106
topics
32
replies
General Discussion
6k
topics
18k
replies
MichalPoncak

Views and protected fields.

Posted By

Hello,

There is a need for my requirements to access a field called "comm_type" from Communication table within a custom view.

This field seems to be protected somewhere and i dont know where. How can i make this field accessible by views?

Any suggestions are welcome. Thank you.

  • 0

    You can't. This field is not available. You need to expose it via an alias in the view. For example:

    create view vMyTestView

    as

    select comms.*,

    comm_type as comm_custom_type

    from communication

    where comm_deleted is null

    This should expose the field. If you wanted it to have a more user friendly name in CRM, then you need to add a new translation:

    Family: ColNames

    FamilyType: Tags

    Code: comm_custom_type

    UK/US: Type

*Community Hub is the new name for Sage City