Custom Entity SQL Error when running block

Posted By bradd_1 over 10 years ago

I created a new custom entity (OpportunityContact).

I created a new tab in the Opportunity Tabs to run a block. That block is a listblock that contains the opct_description field and opct_personid field.

My issue is when I click on the tab from Opportunity. I get a SQL error and the block doesn't run. The problem is the system is using oppo_opportunityid in the where clause rather than opct_opportunityid..

How do I correct this incorrect field?

0 Sage CRM over 10 years ago

The view that the list is based on must contain the oppo_opportunityid field so that it can display the contacts that belong to the opportunity in context.

See the article community.sagecrm.com/.../creating-lists-using-runblock.aspx

"When creating List blocks that are to be called from a particular context it is most important that the primary key of the entity is context is included in the view the List is based on. "
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sage CRM over 10 years ago

Terrible grammar I know.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 bradd_1 over 10 years ago

Well at least I was on the right track. I was just editing the view when I got the notification about your reply. Thanks Jeff!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage CRM

Custom Entity SQL Error when running block

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING