2/19/2025 6:59:05 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.
|
|
|
|
webclient: datagrid, ID to name field
Posted: 23 Jan 08 6:45 PM
|
ok guys here is the situation:
I created an Entity XX off of Account. 1 Account --> M XX
Created the Child Property from Account to XX via Account.AccountID = XX.AccountID
I created a new form with grid from Account, to hold a datagrid with fields from XX
2 of the fields in XX are a ContactID field for "Customer" and a UserID field for "Consultant"
Now after deploying, etc, when i go to view the grid, i see all the data, but the Customer and Consultant fields show the ID's, which are the values in the DB, but I would like to pull in the FirstName and Lastname values instead of the ID.
Do I have to create joins in the Administrator or how can I get this to work? Can any of you point me in the right direction?
thanks,
|
|
|
|
Re: webclient: datagrid, ID to name field
Posted: 23 Jan 08 11:00 PM
|
You need to create relationships in the AA.
1) Create a M:1 relationship from XX to Contact - include property on XX but no collection property on Contact
2) Create a M:1 relationship from XX to User (not UserInfo) - Include property on XX but not on User
Make sense?
-Ryan |
|
|
| |
|
Re: webclient: datagrid, ID to name field
Posted: 24 Jan 08 4:42 PM
|
I created the relationships as you noted, and I can add the fields individually but when I try to combine first and last name in one field I get this error:
Line 71: if (this.Visible)
Line 72: {
Line 73: dsAccountCostSavings.SourceObject = BindingSource.Current;
Line 74: }
Line 75: }
The way that im trying to combine them is the following, I have a Bound field in my data grid and in the DataField property I have XXRelationshipUser.FirstName, XXRelationshipUser.LastName and in the TextFormatString I have {0}, {1}
Is this not valid with simple BoundFields? |
|
|
|
Re: webclient: datagrid, ID to name field
Posted: 24 Jan 08 4:46 PM
|
That is not valid. The Contact entity already has a property with both first and last combined. Look for the property called NameLF and use that instead.
BTW, if you wanted to combine properties like that you could create a custom property where you combine them as needed and return the complete string - then bind that to whatever you wanted.
-Ryan |
|
|
|
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!
|
|
|
|
|
|
|
|