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!

Architect Forums - SalesLogix Scripting & Customization
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.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: IF...ELSE statement in Calculated field?

Veronka Capone
Posts: 113

IF...ELSE statement in Calculated field? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 31 Aug 09 12:14 PM

how to write this expression for a 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.

thanks

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: IF...ELSE statement in Calculated field? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 31 Aug 09 12:18 PM

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.
And/or you could create a View and then Enable it with a One to One relationship to whichever table you are working with.

If you were working with the Web client, you could create Calculated properties within the Interface by writing code, however those columns won't be available for Groups.

[Reply][Quote]

Veronka Capone
Posts: 113

Re: IF...ELSE statement in Calculated field? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 31 Aug 09 12:32 PM

Quote:

Originally posted by Raul A. Chavez

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

Hi Raul,

Sorry, not sure if I understand you correctly: How do I return this SQL Computed column in my grid? through script? I don't want to add a view...

thanks.

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: IF...ELSE statement in Calculated field? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 31 Aug 09 12:57 PM

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.

However, as I stated, if you have to deal with Synchronization then you may have to find alternative ways to create/redefine the column on remotes as needed.

[Reply][Quote]

Veronka Capone
Posts: 113

Re: IF...ELSE statement in Calculated field? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 31 Aug 09 1:06 PM

aaaaaaaaah

yes, yes, yes. That will do.

Thank you !

[Reply][Quote]

Page 1 of 1

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!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 8/29/2025 2:01:30 PM