Category Archives: SalesLogix

Retire an user error message

  delete from sysdba.usersecfunctions where userid =’U6UJ9A00001M’ update sysdba.account set accountmanagerid =’ADMIN’ where accountmanagerid =’U6UJ9A00001M’ update sysdba.contact set accountmanagerid =’ADMIN’ where accountmanagerid =’U6UJ9A00001M’ update sysdba.opportunity set accountmanagerid =’ADMIN’ where accountmanagerid =’U6UJ9A00001M’ UPDATE sysdba.ACCOUNT SET SECCODEID =’ADMIN’ WHERE SECCODEID =’U6UJ9A00001M’ UPDATE … Continue reading

Posted in SalesLogix | Leave a comment

Tips on Lookups

To have the lookups show all record automatically on initial launch, put a always true condition in LookupRestrictField, LookupRestrictOp, and LookupRestrictValue. ie. OWNERID <> 1234 A lookup can be included in the bundle

Posted in SalesLogix | Leave a comment

Remove a table manually from SLOX

drop table YourTableName delete from sectabledefs where tablename = ‘YourTableName’ delete from joindata where fromtable = ‘YourTableName’ or totable = ‘YourTableName’ delete from resynctabledefs where tablename = ‘YourTableName’ ======================= Caution: Deleting a column through the Architect will also remove any … Continue reading

Posted in SalesLogix | Leave a comment

Create a QA/Dev version of SLOX

I made this bat file to quickly refresh our QA with live data: DEL \\LIVE_SERVER\d$\temp\PROD.bak SQLCMD -SLIVE_SERVER -Q”BACKUP DATABASE [SLOX_PAC_PROD] TO  DISK = N’D:\Temp\PROD.bak’ WITH NOFORMAT, INIT,  NAME = N’SLOX_PAC_PROD-Full Database Backup’, SKIP, NOREWIND, NOUNLOAD,  STATS = 10″ COPY /Y … Continue reading

Posted in SalesLogix | Leave a comment

Unofficial documentation for SalesLogix DataGrid Control

The datagrid control is very convenient by poorly documented. I had to dig into by trial and error.  I will keep adding my notes to this entry. Properties Sortable:  see this post Format String:  currency: $,0.00;-$,0.00. %.2m works for field … Continue reading

Posted in SalesLogix | Leave a comment

Sortable property in SalesLogix DataGrid control and few other tricks

When checked, the sort happens in client but very slow (2+ seconds on 1500 records) When unchecked, sorting still supported but it’s on server side (SQL query). So the name of the property should really be ‘Client Sorting’ If the … Continue reading

Posted in SalesLogix | Leave a comment

Add a link to DataGrid control

To add a functional link (i.e. Edit/Delete etc),: Add any columns to the grid. Change the type to Hyperlink. May toggle ‘Read-Only’ (since you don’t really want to change the value), but do NOT check ‘Disable Editor’  (otherwise the link … Continue reading

Posted in SalesLogix | Leave a comment