Tag: SalesLogix Support

Question: SQL Server Native Connection, ADO Command, and Parameters Does anyone have an example of using ADO CommandText with input parameters and a native SQL Server connection? ? parameters and the SLX OLE DB Provider work fine.....except it has the tremendous additional query overhead of the SECCODE joins for Non ADMIN users.....SLX OLE DB Provider performance for a scan of 100,000+ records is NOT acceptable. 'Named' Parameters like ? or @P1 don't work with the SQL Server 2005 connection, yet..... any hints? Maybe a stored procedure command call instead? SELECT A1.OPPORTUNITYID FROM OPPORTUNITY A1 WHERE OPPORTUNITYID LIKE ? or the equivalent would be perfect.

We have a list of activities. The list is imported to an unassociated table (import history). We are capturing ActivityID and a date/timestamp. Can we complete the activities in the list via a script? (bypass the complete activity form) using the timestamp from the table for complete date (rather than "As Scheduled or Now) SLX 7.2

I am trying to edit a pre-existing group created in SalesLogix client. When I view the SQL query, I see that there are conditions applied to this group. However, I do not see the 'Conditions' tab in Query Builder. How was the previous user able to set the conditions? Also, can groups be not edited through SLX Architect?

We're on 7.5.4 LAN. We have about 13 remote users currently. Everything seemed to be humming along just fine until I noticed that about 5 days ago, the TEF's, although are being created just fine, are not moving from Logs --> OUTFILES folder on Sync server to the FTP OUTFILES directory...... except for one user. Her files are still moving as they should. Is there an issue I should know about??

In 7.0, when you minimized Insert New Ticket, you could navigate around SalesLogix. In 7.5.2, when you minimize Insert New Ticket and try to do something else, focus just goes back to the minimized Insert New Ticket form. This happens on the evaluation database as well as my customer's database. What am I missing? Did something change? Same behavior for Insert Defect, Contract, Return.

Anyone know of a way to dynamically populate a multi-select pick list with values that are pulled from a database table?

I want 3 users to be able to edit picklists without having any other administrative access. I gave them access to the tools-->manage-->picklists menu item but any changes they make can only be seen by themselves and not other users. Ive come across something like this before and did a sql update to make the modifyuser of the picklist item ADMIN which makes it visible to all users but its not feasible to do this every single time these 3 users edit a picklist. Have i missed something in the permission process?

V7.5 Can any one suggest me how to create new navbar ie Projects like Contact,Address,Accounts,Calender,Leads etc...?

Is there a way of getting reference to the record selected in a list view of a SalesLogix group? For example if I create a contact group of all contacts with a response to a campaign (joining the targetresponse table) and select one record, will I be able to get the targetresponseid so that I can highlight that particular targetresponse record in a tab. In other words is there a way of storing globally the .GetCurrentField("A3_TARGETRESPONSEID") of a contact group?

We are in a situation where we have many SalesLogix templates which are obsolete and we want to get rid of them. When I right click on the template plugin in the plugin manager- the delete option is disabled. Do I have any option to enable the delete option? If yes- then from where can I turn it on?