6/19/2025 3:29: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 writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Unbound data grid; zero records
Posted: 07 Aug 07 11:12 AM
|
Hi,
I'm essentially trying to create new Tickets tab in Account Details that will show the tickets for not only whatever account one is looking at, but for any accounts further down the hierarchy from it as well. I've essentially taken the regular Tickets tab and given it a new data grid, unbound this time, with SQL that (for testing purposes) has criteria of a specific list of ACCOUNTID values. Once I get this working, I'll develop the code to dynamically change that list when moving from account to account, but for now I'm already stuck. When I copy the SQL into SQL Server and run it, it returns the correct records. When I build an identical tickets group, it runs. But in the form, it doesn't.
Is there a parameter I'm missing? I made the parameters on this data grid the same as on the OOTB data grid, with the exception of the BindID being blank and the above change to the SQL parameter (and a change to the columns to include the account's name). Is there a parameter besides BindID that has to be set to something in order for it to work without being bound, or can you simply not not bind a data grid?
TIA |
|
|
| |
|
Re: Unbound data grid; zero records
Posted: 07 Aug 07 2:17 PM
|
| Thanks, Frank. There are around a thousand desired accounts (all accounts with accounts further down the hierarchy). Also, to determine what's below an account requires code because you must cycle through levels of the hierarchy. Only my test hard-coded query works in groups, unfortunately. |
|
|
|
Re: Unbound data grid; zero records
Posted: 07 Aug 07 2:43 PM
|
There are many things to look into. Are you replacing the Grid's SQL statement? If so, do you have a matching field for each column on the grid?
Have you tried refreshing the grid?
Also, if you removed the BindID, but left the field on the Gray area (under the Table name) it will apply it as a condition as well.
Additionally, you would be amazed at what you can do within the conditions with an SQL statement, specially if the logi is based on the BindID.
Now, if you really want to figure out if the SQL statement is being generated, run the SLX profiler while you open this form. |
|
|
|
Re: Unbound data grid; zero records
Posted: 07 Aug 07 4:43 PM
|
I actually deleted the old datagrid and started over to avoid cling-ons, but ...
Post-tracing I didn't compare the SQL generated to specified, but when I slapped generated into SQL Server it didn't return rows there either and I was able to troubleshoot it. I was disappointed afterwards that it still didn't have results until I took your other advice and refreshed and .... Presto! Thanks, Raul. |
|
|
|
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!
|
|
|
|
|
|
|
|