You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
sql: SELECT unId, spu, data ->> '$.finalSampleIdentifyTime' as finalSampleIdentifyTime, data->>'$.editionReviewerAnalysisTime' AS editionReviewerAnalysisTime, cmsPlanningTime, sampleMerchandiser, data->>'$.printingChannel' AS printingChannel, status, isSpecial
FROM am_return_analysis_process
WHERE
1 AND data->>'$.printingChannel' = '1' AND ( sampleMerchandiser LIKE '%"linhuijun"%') AND status = 'analystChecked' AND status != 'repealed'
EXCEPTION : "cannot calculate position of - within ->> '$.finalSampleIdentifyTime' as finalSampleIdentifyTime, data->>'$.editionReviewerAnalysisTime' AS editionReviewerAnalysisTime, cmsPlanningTime, sampleMerchandiser, data->>'$.printingChannel' AS printingChannel, status, isSpecial
FROM am_return_analysis_process
WHERE
1 AND data->>'$.printingChannel' = '1' AND ( sampleMerchandiser LIKE '%"linhuijun"%') AND status = 'analystChecked' AND status != 'repealed'" in /include/composer/vendor/greenlion/php-sql-parser/src/PHPSQLParser/positions/PositionCalculator.php on line 249. Timestamp : 1724641000
The text was updated successfully, but these errors were encountered:
sql: SELECT
unId
,spu
,data
->> '$.finalSampleIdentifyTime' asfinalSampleIdentifyTime
,data
->>'$.editionReviewerAnalysisTime' ASeditionReviewerAnalysisTime
,cmsPlanningTime
,sampleMerchandiser
,data
->>'$.printingChannel' ASprintingChannel
,status
,isSpecial
FROM
am_return_analysis_process
WHERE
1 AND
data
->>'$.printingChannel' = '1' AND (sampleMerchandiser
LIKE '%"linhuijun"%') ANDstatus
= 'analystChecked' ANDstatus
!= 'repealed'EXCEPTION : "cannot calculate position of - within ->> '$.finalSampleIdentifyTime' as
finalSampleIdentifyTime
,data
->>'$.editionReviewerAnalysisTime' ASeditionReviewerAnalysisTime
,cmsPlanningTime
,sampleMerchandiser
,data
->>'$.printingChannel' ASprintingChannel
,status
,isSpecial
FROM
am_return_analysis_process
WHERE
1 AND
data
->>'$.printingChannel' = '1' AND (sampleMerchandiser
LIKE '%"linhuijun"%') ANDstatus
= 'analystChecked' ANDstatus
!= 'repealed'" in /include/composer/vendor/greenlion/php-sql-parser/src/PHPSQLParser/positions/PositionCalculator.php on line 249. Timestamp : 1724641000The text was updated successfully, but these errors were encountered: