Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Friday, May 25, 2018 
 
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 ThreadView:  Search:  
 Author  Thread: Creating group with multiple conditions
Rob Bartram
Posts: 98
 
Creating group with multiple conditionsYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 08 Jul 08 10:39 PM
Hello,

Any one know how to create a group with multiple conditions? I have a custom mainview based on a table CEIHOTLIST and I'm working on creating an advanced lookup.

I'm building a subquery to use in the where close that I pass to the .CreateTempGroup method. It works, but when I save the group, editing in the Query builder means that I have to parse through the long sub query, when I would prefer to have each individual condition shown on it's own line.

This is my code (the strSQL simplified for this Example):

strSQL = "(Select aa.ContactID from CEIHOTLIST aa Where aa.LASTNAME like 'Smith%' and aa.FIRSTNAME like 'John%')"
Application.BasicFunctions.CreateTempGroup "CEIHOTLIST","tmpGroup","ContactID"," in ",strSQL,""

This is what I get one condition in the Query Builder resembling:

Condition 1: "ContactID", "In" , "(Select aa.ContactID from CEIHOTLIST aa Where aa.LASTNAME like 'Smith%' and aa.FIRSTNAME like 'John%')", "End"

What I would like to see instead is:

Condition 1: "LastName", "Starting With", "Smith", " And"
Condition 2: "FirstName", "Starting With", "John", "End"

This would make it much easier to edit the group. Does anyone have any idea how I can get this to work?

...Rob
[Reply][Quote]
Stephen Pond
Posts: 4
 
Re: Creating group with multiple conditionsYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 08 Sep 08 2:43 PM
Hello Rob,

I am working on something very similiar and just ran into the exact same scenerio. If I find something out, I will post it here,

Stephen
[Reply][Quote]
Rob Bartram
Posts: 98
 
Re: Creating group with multiple conditionsYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 08 Sep 08 2:54 PM
Thank you. I still have not found any solutions. Please keep me posted.

...Rob
[Reply][Quote]
RJ Samp
Posts: 973
Top 10 forum poster: 973 posts
 
Re: Creating group with multiple conditionsYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 10 Sep 08 1:30 PM
SalesLogix does this
Field
Operator
Value

" WHERE FIELD OPERATOR 'Value' "
So structure your conditionSSS accordingly by piling onto the Operator

Field: ACCOUNTID
OPERATOR: IN('a,'b','c') AND TYPE IN('Active','Open') AND STATUS = 'A' AND '1' = Value: 1

Result
" WHERE ACCOUNTID IN('a,'b','c') AND TYPE IN('Active','Open') AND STATUS = 'A' AND '1' = '1' "

The other one I've done is make an IMMENSELY large text string of AccountID
's......and then do an IN on them.....

[Reply][Quote]
Rob Bartram
Posts: 98
 
Re: Creating group with multiple conditionsYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 10 Sep 08 1:43 PM
Thank you RJ. I'll have to give it a try. Just to confirm, after such a lookup is executed and then saved by the user, when the user edits the saved lookup, do they see multiple condition entries or just one "ACCOUNTID IN" entry?

I too have done the IMMENSELY long string of ACCOUNTIDs, but that does not allow for saving the results as a dynamic lookup.
[Reply][Quote]
lorenzo
Posts: 35
 
Re: Creating group with multiple conditionsYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 04 Dec 12 3:54 PM
fiogf49gjkf0d

Hi i have a similar problem, i woluld like to group the result of the group.


There is any way to overloads the function Application.BasicFunctions.CreateTempGroup to add new parameters?


Thanks

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

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 5/25/2018 1:34:46 PM