View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
18550 | Bug reports | Response browsing | public | 2022-12-12 18:44 | 2024-01-19 17:23 |
Reporter | DenisChenu | Assigned To | DenisChenu | ||
Priority | none | Severity | minor | ||
Status | assigned | Resolution | reopened | ||
Product Version | 3.28.x | ||||
Summary | 18550: MSSQL Reponse filter with underscore or bracket not working | ||||
Description | When have response with underscore ( | ||||
Steps To Reproduce | Steps to reproduceHave a MSSQL (and another DB to compare) Expected resultHave some value in response Actual resultEmpty result | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | 5.4.14 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | not relevant | ||||
Database type & version | SQLServer (MS) 15.00.4261 | ||||
Server OS (if known) | windows | ||||
Webserver software & version (if known) | IIS | ||||
PHP Version | PHP7.4 | ||||
See Yii 2 Against Yii1 |
|
Own fix here : http://burnignorance.com/database-tips-and-tricks/how-to-escape-wildcard-characters-while-searching-in-sql-server/ |
|
No way to extend CBDCriteria or replace CBDCriteria ??? |
|
@ollehar : the only way to fix it seems to fix manually Yii1 … See https://github.com/yiisoft/yii/issues/4512#issuecomment-1400704265 We close as «Not fixable» an i create a Fork for MSSQL ? |
|
Did i take time to fix it in LimeSurey core |
|
Urgh. Not sure. |
|
Is this fixed in Yii 3 query builder or active record package, I wonder... |
|
Me too … i think i create a fork for one of my client, updating directly Yii But : if i do it for LS :
Tell me :) |
|
Fixed in Yii2, then Yii3 too. |
|
OK, so since master now require PHP 7.4 at least, it's actually possible for us to start to use Yii 3 packages step by step. Dunno if that would work here tho. |
|
take a lot more time , i do my fork :) |
|
Can be incluided in https://github.com/LimeSurvey/LimeSurvey/blob/master/application/core/LSDbCriteria.php |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2022-12-12 18:44 | DenisChenu | New Issue | |
2022-12-12 18:44 | DenisChenu | File Added: survey_archive_MSSQL_compare.lsa | |
2022-12-12 18:44 | DenisChenu | File Added: MSSQL_bracket.mp4 | |
2022-12-12 18:44 | DenisChenu | File Added: MSSQL_underscore.mp4 | |
2022-12-12 18:44 | DenisChenu | Assigned To | => DenisChenu |
2022-12-12 18:44 | DenisChenu | Status | new => assigned |
2022-12-12 18:58 | DenisChenu | Note Added: 73068 | |
2022-12-12 18:58 | DenisChenu | Bug heat | 0 => 2 |
2022-12-12 19:02 | DenisChenu | Note Added: 73069 | |
2022-12-12 19:06 | DenisChenu | Note Edited: 73069 | |
2023-01-21 13:48 | DenisChenu | Note Added: 73521 | |
2023-05-04 16:34 | DenisChenu | Note Added: 74817 | |
2023-05-04 16:35 | DenisChenu | Assigned To | DenisChenu => ollehar |
2023-05-04 16:35 | DenisChenu | Status | assigned => feedback |
2023-05-04 16:35 | DenisChenu | Note Added: 74818 | |
2023-05-04 16:36 | DenisChenu | Note Edited: 74818 | |
2023-05-05 11:46 | ollehar | Note Added: 74831 | |
2023-05-05 11:46 | ollehar | Bug heat | 2 => 4 |
2023-05-05 11:47 | ollehar | Note Added: 74832 | |
2023-05-05 11:47 | ollehar | Note Edited: 74832 | |
2023-05-05 11:50 | DenisChenu | Note Added: 74833 | |
2023-05-05 11:50 | DenisChenu | Status | feedback => assigned |
2023-05-05 11:51 | DenisChenu | Note Added: 74834 | |
2023-05-05 11:51 | DenisChenu | Note Edited: 74834 | |
2023-05-05 12:01 | ollehar | Note Added: 74835 | |
2023-05-05 15:32 | DenisChenu | Note Added: 74843 | |
2023-06-16 10:42 | c_schmitz | Summary | MSSQL Reponse filter with underscore or bracket are broken => MSSQL Reponse filter with underscore or bracket not working |
2023-06-16 10:42 | c_schmitz | Description Updated | |
2023-06-16 10:44 | c_schmitz | Status | assigned => closed |
2023-06-16 10:44 | c_schmitz | Resolution | open => won't fix |
2023-07-27 15:29 | DenisChenu | Assigned To | ollehar => DenisChenu |
2023-07-27 15:29 | DenisChenu | Status | closed => feedback |
2023-07-27 15:29 | DenisChenu | Resolution | won't fix => reopened |
2023-07-27 15:29 | DenisChenu | Note Added: 76303 | |
2024-01-19 17:23 | DenisChenu | Status | feedback => assigned |
2024-01-19 17:23 | DenisChenu | Complete LimeSurvey version number (& build) | 3.28.42 and 5.4.14 => 5.4.14 |