How do I write this expression for a SalesLogix calulated field?

Question:

How do I write this expression for a SalesLogix calulated field?

SELECT
CASE WHEN ISNULL(Repl_Quote, ”) <> ” AND ISNULL(Repair_Quote, ”) <> ” THEN ‘Replacement & Repair’
ELSE CASE WHEN ISNULL(Repl_Quote, ”) <> ” THEN ‘Repair’ ELSE ‘Replacement’ END
END
FROM ticket_quote

I need this field to be displayed in a simple grid.

Answer:

You can’t do that as a SalesLogix calculated field.

If you don’t have to worry about synchronization, you could instead use SQL Computed columns.

You go into SLX and add a Column, lets call it CAL1 (use whatever name you want to).
Once the column has been created, go into SQL and change its definition, place the Case statement into the Computation of the column.

From SLX, the column will look and feel like any other column.

 

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) news and product updates!

You have Successfully Subscribed!