{"record":{"id":"9102a1b9c5793b3c","repo":"appsmithorg/appsmith","slug":"pe-arg-5000-9102a1","errorCode":"PE-ARG-5000","errorMessage":"{} not found in the known column names: {}","messagePattern":"(.+?) not found in the known column names: (.+?)","errorType":"error_code","errorClass":"AppsmithPluginException","httpStatus":500,"severity":"error","filePath":"app/server/appsmith-interfaces/src/main/java/com/appsmith/external/services/ce/FilterDataServiceCE.java","lineNumber":293,"sourceCode":"            limit = \"20\";\n        }\n        values.add(new PreparedStatementValueDTO(limit, DataType.INTEGER));\n\n        // Set offset value and data type for prepared statement substitution\n        String offset = paginateBy.get(PAGINATE_OFFSET_KEY);\n        if (isBlank(offset)) {\n            offset = \"0\";\n        }\n        values.add(new PreparedStatementValueDTO(offset, DataType.INTEGER));\n    }\n\n    private void validateProjectionColumns(List<String> projectionColumns, Map<String, DataType> schema) {\n        if (CollectionUtils.isEmpty(projectionColumns)) {\n            return;\n        }\n        for (String columnName : projectionColumns) {\n            if (!schema.containsKey(columnName)) {\n                throw new AppsmithPluginException(\n                        AppsmithPluginError.PLUGIN_EXECUTE_ARGUMENT_ERROR,\n                        columnName + \" not found in the known column names: \" + schema.keySet());\n            }\n        }\n    }\n\n    private void validateSortByColumns(List<Map<String, String>> sortBy, Map<String, DataType> schema) {\n        if (isSortConditionEmpty(sortBy)) {\n            return;\n        }\n        for (Map<String, String> sortCondition : sortBy) {\n            String columnName = sortCondition.get(SORT_BY_COLUMN_NAME_KEY);\n            if (!isBlank(columnName) && !schema.containsKey(columnName)) {\n                throw new AppsmithPluginException(\n                        AppsmithPluginError.PLUGIN_EXECUTE_ARGUMENT_ERROR,\n                        columnName + \" not found in the known column names: \" + schema.keySet());\n            }\n            if (!isBlank(columnName)) {","sourceCodeStart":275,"sourceCodeEnd":311,"githubUrl":"https://github.com/appsmithorg/appsmith/blob/8cd9021c24cdbea1c3c12c966073708e83db60c2/app/server/appsmith-interfaces/src/main/java/com/appsmith/external/services/ce/FilterDataServiceCE.java#L275-L311","documentation":"An argument-validation error from `validateProjectionColumns`: you asked the UQI filter to project (display) a column name that does not exist in the auto-derived schema (`schema.keySet()`). The schema is built from the first row of the data, so a projection column must match a key actually present in that row.","triggerScenarios":"Calling the filter flow with `projectionColumns` containing a name that is not a key in the generated schema map - typically a typo, a stale field name, or referencing a column that only appears in later rows.","commonSituations":"Renaming a field upstream and forgetting to update the projection list; case mismatch (schema is case-sensitive under H2 with `DATABASE_TO_UPPER=FALSE`); projecting a computed/aliased field that does not exist in the raw items.","solutions":["Print `schema.keySet()` (shown in the error) and compare against your projection list.","Correct the spelling/case of the offending column, or remove it from `projectionColumns`.","If the field genuinely exists in the data, ensure the first item in `items` contains it - schema is derived from `items.get(0)`."],"exampleFix":"// before\nprojectionColumns = [\"UserNAme\"]  // typo / wrong case\n\n// after\nprojectionColumns = [\"UserName\"]   // matches a key in schema.keySet()","handlingStrategy":"validation","validationCode":"Map<String, DataType> schema = filterDataService.generateSchema(items, conversionMap);\nList<String> projectionColumns = List.of(\"UserName\");\nList<String> unknown = projectionColumns.stream()\n        .filter(c -> !schema.containsKey(c))\n        .collect(Collectors.toList());\nif (!unknown.isEmpty()) {\n    throw new IllegalArgumentException(\"Unknown projection columns: \" + unknown\n            + \". Valid: \" + schema.keySet());\n}","typeGuard":null,"tryCatchPattern":null,"preventionTips":["Derive the schema from the same `items` you pass to the filter and validate projection names against `schema.keySet()` first.","Drive projection column lists from the schema keys in the UI rather than free-text input.","Remember schema is case-sensitive and inferred from items.get(0)."],"tags":["appsmith","uqi","projection","schema","validation"],"backgroundTag":null,"analyzedSha":"8cd9021c24cdbea1c3c12c966073708e83db60c2","analyzedAt":"2026-08-12T22:14:19.293Z","schemaVersion":2},"datasetVersion":"2026-08-12T23:17:12.415Z"}