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: Returning the SECCODEID in the Query Builder?

Cory Haibloom
Posts: 39

Returning the SECCODEID in the Query Builder? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Mar 10 4:32 PM

I know it's possible to return the USERID in a query builder condition using :USERID and setting the condition to use the value as a literal. Is there a similar way to return the SECCODEID? If so, I can't seem to find it...

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: Returning the SECCODEID in the Query Builder? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Mar 10 7:50 PM

:userid == the ID of the Current User.

When you refer to SeccodeID, what ID do you want to return?
The User's Security Team?
If so, use :ownerid

Now, if you are referring to the User's Default Owner as setup on the Options, use a Literal and enter the following:
(SELECT OPTIONVALUE FROM USEROPTIONS WHERE CATEGORY = 'General' AND NAME = 'InsertSecCodeID' AND USERID = :userid)

[Reply][Quote]

Cory Haibloom
Posts: 39

Re: Returning the SECCODEID in the Query Builder? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 31 Mar 10 11:30 AM

Thanks (as always), Raul!

:ownerid was exactly what I needed.

Cory

[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): 7/8/2025 4:55:06 AM