5/3/2026 4:43:01 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.
|
|
|
|
Set SLX Datagrid result set to SQL result
Posted: 18 Jun 08 6:50 AM
|
Goal: Allow user in customer portal to search tickets by prettykey contains search value. Someone made the call to remove all the groupbuilder (???!!!) functionality from the portal so this functionality is not available.
Since prettykey is stored in two fields I am thinking an SQL result set might be easiest (for my skill set and the current level of slx web documentation). I am thinking I can put a textbox and button on the form - the user will enter part of the pretty key, I will run SQL and populate the grid with the result set.
Are there any examples of doing this out there? Is doing this with an SLX grid much different than doing this with an asp.net datagrid? Any input appreciated. Thanks |
|
|
|
Re: Set SLX Datagrid result set to SQL result
Posted: 21 Jun 08 1:43 PM
|
If you look at the ActivityManagerList.ascx you will find an example of binding to a DataSet.
Although this example is a bit schewed, it is still a good one.
In this case, they get the data from a call in the Activity Object that returns and IList object, but then they dynamically build a DataTable.
I see no reason why you couldn't just retreive the data table directly yourself by executing the appropriate SQL statement, then again, I have yet to try that. But again, the fact of the matter is that the grid in this example is bound to a DataSet but just simply setting the Data Source. |
|
|
| |
|
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!
|
|
|
|
|
|
|
|