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!

Administration Forums - General Administration
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to General Administration | New Thread

View: Search:

Author

Thread: Simple Question

Michael Lupino
Posts: 46

Simple Question Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 15 Mar 10 11:36 AM

I'm trying to build a group containing two literals (one is userid and the other is now literal), My question is, is that possible?

My group looks something like this:

evalutes an opp.estimatedclose (dt) less than :now and
opp.status is equal to "open" and
opp.accountmanagerid starting with :userid

When i run my group, it returns no results however I know that there are results to return (if the query is running correctly) any thoughts or assistance is appreciated.

Thanks,
Michael

[Reply][Quote]

Phil Parkin
Posts: 819

Re: Simple Question Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 15 Mar 10 11:54 AM

Can you paste in the SQL from the group definition (as displayed when you click on the 'View SQL' button)?

[Reply][Quote]

Lane
Posts: 121

Re: Simple Question Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 15 Mar 10 1:31 PM

Use the queryeditor View SQL
run the view sql in query analyser till it works
then backtrack the editor parameters till you match the syntax.

use getdate() for :now and expect a utc offset.

[Reply][Quote]

Lane
Posts: 121

Re: Simple Question Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 15 Mar 10 1:32 PM

Use the queryeditor View SQL
run the view sql in query analyser till it works
then backtrack the editor parameters till you match the syntax.

use getdate() for :now and expect a utc offset.

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: Simple Question Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 16 Mar 10 12:35 PM

Quote:

Originally posted by Michael Lupino

evalutes an opp.estimatedclose (dt) less than :now and
opp.status is equal to "open" and
opp.accountmanagerid starting with :userid

Run the SLX Profiler, open the group and capture the SQL statements that was generated (before and after parsing). The profiler will indicate if there were parsing errors.

At first look, you should set opp.accountmanagerid "equals to" :userid. Not that Starting with would fail, but you get better performance on the "equals to" query.

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: Simple Question Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 16 Mar 10 12:40 PM

Quote:

Originally posted by Lane

use getdate() for :now and expect a utc offset.

As an alternative, you could use GetUTCDate() to avoid that UTC Offset.

[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 © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/29/2024 5:25:41 PM