Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Silver Super Contributor
Posts: 801
Registered: ‎03-24-2009

8.1 SNC03b & Defect 14094816 Application.BasicFunctions.GetGroupSQLInfoEx() is broken for dates

[ Edited ]
The function introduced by this defect fix breaks date handling. It does not cater for date conditions from groups in any other format than US style. If you create a group with a condition of CreateDate within last 7 days then the format in the group is :dateParam1 - when this groups is used within campaigns it fails with enclosed error. The SQL profiler shows the date (in UK dd/mm/yyyy format, hence conversion error). This means you can't use any groups in dates (unless less than 12/12/XX - and, even then, would be wrong) Needs to ISO the date when encountered.
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: 8.1 SNC03b & Defect 14094816 Application.BasicFunctions.GetGroupSQLInfoEx() is broken for dates

Ouch! - big problem since practically everyone (customers) uses dates in a lot of their groups!

 

"Quick fix" is needed!

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Employee
Posts: 629
Registered: ‎04-24-2009

Re: 8.1 SNC03b & Defect 14094816 Application.BasicFunctions.GetGroupSQLInfoEx() is broken for dates

This is addressed by the fix for defect 14096388 (SLX - 8.1 Update 04).

 

Thanks

 

Mike

Silver Super Contributor
Posts: 801
Registered: ‎03-24-2009

Re: 8.1 SNC03b & Defect 14094816 Application.BasicFunctions.GetGroupSQLInfoEx() is broken for dates

Great news! Thanks Mike.
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: 8.1 SNC03b & Defect 14094816 Application.BasicFunctions.GetGroupSQLInfoEx() is broken for dates

Thanks! - got an approx date of release?

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Employee
Posts: 629
Registered: ‎04-24-2009

Re: 8.1 SNC03b & Defect 14094816 Application.BasicFunctions.GetGroupSQLInfoEx() is broken for dates

RJ,

 

I'm uncertain when the 8.1 Update 04 will be released. You might check with support.

 

Thanks

 

Mike

Moderator
Posts: 234
Registered: ‎07-07-2008

Re: 8.1 SNC03b & Defect 14094816 Application.BasicFunctions.GetGroupSQLInfoEx() is broken for dates

RJ,

It's tentatively scheduled for release next month. As always, times can change based on priorities, resources, etc.

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: 8.1 SNC03b & Defect 14094816 Application.BasicFunctions.GetGroupSQLInfoEx() is broken for dates

Tim - Thanks! - I can live with that ;-)

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html