7/4/2025 2:32:44 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.
|
|
|
|
Group Entity Link not working on extended entity fields
Posted: 04 Sep 09 11:42 AM
|
We are starting to move from the Network client to Web...install is currently 7.5 no service packs.
I am running into an issue with groups. In our Opportunities, we have another table Opp_Info, which is basically just an extension of the opportunity table. I have set that up in Application Architect as an extended entity. All is good with that. I have been modifying the opportunity forms to include fields from opp_info, and it is happy.
However we have a lot of pre-existing groups which use fields from this extended table. This was fine in the network client, as the whole line linked to the opportunity detail, but now each field is linked individually. I see in the query builder layout tab, an option which is labeled "Entity Linked". I would assume that this is what is used to make that field link to the detail, however if I set that for any Opp_Info fields I get the following error:
GetGroupDataReader Failed: :
Invalid column name 'OPP_INFOID'
The field OPP_INFOID does not exist...the opp_info field key is opportunityid, which is what is defined in the entity.
Am I doing this correctly? Is there any other way to define what fields are linked to what in a group? |
|
|
|
Re: Group Entity Link not working on extended entity fields
Posted: 08 Sep 09 5:39 AM
|
I presume you have an entity called Opp_Info otherwise you will need to create it looking at your opp_info table.
You have a relationship under opportunity linking id to opp_info.opportunityid? - if not create
When you go to create group under opportunity you should see OPPORTUNITY at top of query builder screen and then opp_info will appear under it if relationship exist. you can then expand this opp_info entity and add items to the layout from it. |
|
|
|
Re: Group Entity Link not working on extended entity fields
Posted: 08 Sep 09 8:40 AM
|
I am not having a problem adding items from Opp_Info into the group. The opp_info entity and relationship have been set up correctly. The problem I'm having is getting a particular column to link to the opportunity detail. When you are editing a column in the query builder it has the following properties:
Field Name:
Caption:
Visible:
Width:
Capt. Align:
Text Align:
Format Type:
Format:
Entity Linked:
CSS Class:
It is when I check that "Entity Linked" box that I get the error (not right when I click it, but when I go back to look at the group). If I check that box on a field that comes from the Opportunity table, then it links it properly. If I check it on a field that comes from Opp_Info, then I get an error.
|
|
|
|
Re: Group Entity Link not working on extended entity fields
Posted: 08 Sep 09 9:45 AM
|
i got an extention to the account and got account.accfin.id to work because entity is extension didn't need to tick link entity in query was linked automatically so can select and automatically takes you to account.
equivalent i think to your field opportunity.opp_info.id
Make sure that a matching record exists in the dtabase for opportunity and opp_info.
i.e. get the sql from the query and check you have records existing in it.
|
|
|
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|