4/19/2024 6:32:15 PM
|
| |
| 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!
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.
|
|
|
|
Creating group with multiple conditions
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 |
|
|
|
Re: Creating group with multiple conditions
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 |
|
|
| |
|
Re: Creating group with multiple conditions
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.....
|
|
|
|
Re: Creating group with multiple conditions
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.
|
|
|
|
Re: Creating group with multiple conditions
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 |
|
|
|
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!
|
|
|
|
|
|
|
|