fix: excel时间转文本，使用文本下拉框搜索失败

jinlong-T · jinlong-T · commit 429ceec5063d · 2024-10-08T18:48:47.000+08:00
diff --git a/core/backend/src/main/java/io/dataease/provider/engine/doris/DorisQueryProvider.java b/core/backend/src/main/java/io/dataease/provider/engine/doris/DorisQueryProvider.java
@@ -145,6 +145,8 @@ public String createQuerySQL(String table, List<DatasetTableField> fields, boole
                 if (f.getDeExtractType() == 1) {
                     if (f.getDeType() == 2 || f.getDeType() == 3) {
                         fieldName = String.format(DorisConstants.UNIX_TIMESTAMP, originField) + "*1000";
+                    } else if (f.getDeType().equals(DeTypeConstants.DE_STRING)) {
+                        fieldName = String.format(DorisConstants.CAST, originField, DorisConstants.VARCHAR);
                     } else {
                         fieldName = originField;
                     }

Original file line number	Diff line number	Diff line change
`@@ -145,6 +145,8 @@ public String createQuerySQL(String table, List<DatasetTableField> fields, boole`
`145`	`145`	`if (f.getDeExtractType() == 1) {`
`146`	`146`	`if (f.getDeType() == 2 \|\| f.getDeType() == 3) {`
`147`	`147`	`fieldName = String.format(DorisConstants.UNIX_TIMESTAMP, originField) + "*1000";`
	`148`	`+ } else if (f.getDeType().equals(DeTypeConstants.DE_STRING)) {`
	`149`	`+ fieldName = String.format(DorisConstants.CAST, originField, DorisConstants.VARCHAR);`
`148`	`150`	`} else {`
`149`	`151`	`fieldName = originField;`
`150`	`152`	`}`