8/23/2025 10:31:03 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.
|
|
|
|
"Current Group" Printing - Where clause not parsed correctly
Posted: 05 Jun 08 8:31 AM
|
Hello,
I have just completed our upgrade to 7.2.2 (from 6.2.6) and aside from many quirky screen repaint issues just about everything is working perfectly, with the following exception:
We have an custom advanced lookup screen that uses sub queries in the where clause to create the tmp group via Application.BasicFunctions.CreateTempGroup method. The query lookup returns the desired records, but when I try use the "Show Records that Match: [Current group]" to print a report containing the lookup results, the following error pops up.
An error occurred executing global script (System:Global Reports).
Error in include script (SYSTEM:SLX CRYSTAL REPORT): Failed to parse SQL
at line 334, char 14.
Which is referring to this line of code.
GetRSFForMainViewCurrentGroup = mReport.GetRecordSelectionForMainViewCurrentGroup(MainTable)
As shown below, the closing three parenthesis are being truncated during the parsing of the group's where clause.
I can't find the code that does the parsing. If anyone has any thoughts on how I can resolve this, please let me know.
This is the group query:
------------------------
SELECT A1.CONTACTID, A1.LASTNAME, A2.ISBILLING A2_ISBILLING, A1.NAMELF, A1.ACCOUNT,
A1.WORKPHONE, A1.DONOTSOLICIT, A1.ISSERVICEAUTHORIZED, A1.CREATEDATE, A1.CREATEUSER,
A1.MODIFYDATE, A1.MODIFYUSER, A1.NAME, A1.LASTNAME_UC
FROM CONTACT A1 LEFT OUTER JOIN CEI_CONTACTDETAILS A2 ON (A1.CONTACTID=A2.CONTACTID)
WHERE (A1.CONTACTID IN
(Select A9999.ContactID
From
Contact A9999
Where
A9999.ContactID In
(Select Distinct A1.ContactID
From
Contact A1
Left Outer Join CEIContactHRDetails A2 On (A1.ContactID = A2.ContactID)
Left Outer Join CEIContactHRRepHistory A3 On (A1.ContactID = A3.ContactID)
Left Outer Join CEIContactHREquipment A4 On (A1.ContactID = A4.ContactID)
Left Outer Join CEI_ContactDetails A5 On (A1.ContactID = A5.ContactID)
Where
A1.ContactID In
(Select ContactID From CEI_ContactDetails Where IsCandidate = 'T')
And A1.ContactID In
(Select ContactID
From CEI_ContactDetails
Where CandStatus In
('Coming On The Bench','Coming On The Bench Star','On Contract')))))
ORDER BY A1.LASTNAME_UC ASC, A1.FIRSTNAME ASC
This is the where clause parsed during the [Current Group] printing - as seen in the SLX Profiler
-------------------------------------------------------------------
SELECT A9999.CONTACTID
FROM
CONTACT A9999
WHERE A9999.CONTACTID IN
(SELECT DISTINCT A1.CONTACTID
FROM
CONTACT A1
LEFT OUTER JOIN CEICONTACTHRDETAILS A2 ON (A1.CONTACTID = A2.CONTACTID)
LEFT OUTER JOIN CEICONTACTHRREPHISTORY A3 ON (A1.CONTACTID = A3.CONTACTID)
LEFT OUTER JOIN CEICONTACTHREQUIPMENT A4 ON (A1.CONTACTID = A4.CONTACTID)
LEFT OUTER JOIN CEI_CONTACTDETAILS A5 ON (A1.CONTACTID = A5.CONTACTID)
WHERE
A1.CONTACTID IN
(SELECT CONTACTID FROM CEI_CONTACTDETAILS WHERE ISCANDIDATE = 'T')
AND A1.CONTACTID IN
(SELECT CONTACTID
FROM CEI_CONTACTDETAILS
WHERE CANDSTATUS IN
('COMING ON THE BENCH','COMING ON THE BENCH STAR','ON CONTRACT'
Thank you - Rob.
|
|
|
|
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!
|
|
|
|
|
|
|
|