Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Sunday, November 23, 2014 
 
slxdeveloper.com Community Forums  
   
 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

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 © 2014 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): 11/23/2014 5:38:09 AM