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

SalesLogix Picklist options

There are 5 settings for each picklist in SLOX 7.2: Required entry: you will be prompted if the picklist gets the focus but nothing is selected, even you click Cancel button Allow multiple selections Text must match a list item: … Continue reading

Posted in SalesLogix | Leave a comment

OnChange vs. OnExitControl event in SalesLogix

Most of the user input controls have both OnChange and OnExitControl event. If no special reason, OnExitControl event should be handled instead of OnChange. OnChange event will be fired every single time the user enters anything, but OnExitControl is fired … Continue reading

Posted in SalesLogix | Leave a comment

Show DateTime value as boolean in SalesLogix DateGrid

One time I received a request to add a new column to a dategrid. The client wanted to show a datetime field in the grid to indicate if a thing has been completed or not. However there are already too … Continue reading

Posted in SalesLogix | Leave a comment