Hallo ihr,
ich habe eine Listenansicht. Eine Spalte aus einer Join Beziehung, und 4 Sub-Querys.
Die Liste wird korrekt angezeigt.
Jedoch wenn ich den CSV export starte, bekomme ich eine Meldung Bad Request. siehe unten.
Ich konnte das Problem jetzt weiter eingrenzen: Ich habe auf dem Formular ein Auswahlfeld, welches ich als Filter für das Schuljahr beutze. Dieser Filter ist in einer Sub-Query.
Wenn ich kein Jahr auswähle, werden mir alle Arbeitsstunden der Eltern angezeigt.
Filtere ich nach Jahr, dann nur die des Schuljahres.
Also die Anzeige klappt in beiden Fällen. Der SCV export klappt aber nur ohne Filter.
Fehlermeldung:
`
Anscheinend gibt es ein Problem mit dieser Website
https://192.168.0.65/csv/download/export.csv?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJyMyBhcHBsaWNhdGlvbiIsInN1YiI6InMuc2NobWlkdCIsImV4cCI6MTc1OTcyOTcwNiwiaWF0IjoxNzU5MTI0OTA2LCJhZG1pbiI6dHJ1ZSwibG9naW5JZCI6MiwidHlwZSI6ImxvY2FsIiwibm9BdXRoIjpmYWxzZX0.luoiuTF9ZVhZHVj3HmkGXdra87PcOt-HkqCEykv8hoo&bool_false=false&bool_true=true&comma_char=;&date_format=d.m.Y&timezone=Europe/Berlin&ignore_header=false&relation_id=ad7cf423-0c4f-46e5-97fa-f4a8527a43f9&columns=[{"id":"49ccce74-5cc1-4c7c-ba43-3a9889bc3c3e","attributeId":"5f7c5aa8-b1f5-42b1-901f-a8d009984a6e","index":0,"groupBy":false,"aggregator":null,"distincted":false,"subQuery":false,"query":null,"captions":{"columnTitle":{"de_de":"Familienname"}},"basis":0,"batch":null,"display":"default","hidden":false,"length":0,"onMobile":true,"styles":["wrap"],"batchVertical":false,"clipboard":false,"wrap":false,"flags":{"alignEnd":false,"alignMid":false,"bold":false,"boolAtrIcon":false,"clipboard":false,"italic":false,"monospace":false,"noShrink":false,"noThousandsSep":false,"previewLarge":false,"vertical":false,"wrap":true}},{"id":"d93d7f8f-f42e-4cca-8c5e-b79ceb190fb8","attributeId":"591af583-3d98-4847-b0e1-03ebd52d4614","index":0,"groupBy":false,"aggregator":"sum","distincted":false,"subQuery":true,"query":{"id":"14f09572-c1b9-4970-bdf3-a471ad075939","relationId":"4653ef81-853d-41d1-b51f-9cba8eb61b28","fixedLimit":0,"joins":[{"relationId":"4653ef81-853d-41d1-b51f-9cba8eb61b28","attributeId":null,"indexFrom":-1,"index":0,"connector":"INNER","applyCreate":true,"applyUpdate":true,"applyDelete":true}],"filters":[{"connector":"AND","operator":"=","index":0,"side0":{"brackets":1,"value":"","attributeId":"2c69f182-11f9-4d45-ab1b-32c14804e74c","attributeIndex":0,"attributeNested":0,"nowOffset":null},"side1":{"brackets":0,"value":null,"attributeId":"6e8ca060-6665-489e-ba92-c4ef323de6cb","attributeIndex":0,"attributeNested":1,"nowOffset":null}},{"connector":"AND","operator":"IS NULL","index":0,"side0":{"brackets":2,"value":1,"attributeId":null,"attributeIndex":0,"attributeNested":0,"nowOffset":null},"side1":{"brackets":1,"value":"","attributeId":null,"attributeIndex":0,"attributeNested":0,"nowOffset":null}},{"connector":"OR","operator":"IS NOT NULL","index":0,"side0":{"brackets":1,"value":1,"attributeId":null,"attributeIndex":0,"attributeNested":0,"nowOffset":null},"side1":{"brackets":0,"value":"","attributeId":null,"attributeIndex":0,"attributeNested":0,"nowOffset":null}},{"connector":"AND","operator":"=","index":0,"side0":{"brackets":0,"value":"","attributeId":"6d42bce4-ce63-4444-8cda-8bd94962c7b3","attributeIndex":0,"attributeNested":1,"nowOffset":null},"side1":{"brackets":3,"value":1,"attributeId":null,"attributeIndex":0,"attributeNested":0,"nowOffset":null}}],"orders":[],"lookups":[],"choices":[]},"captions":{"columnTitle":{}},"basis":0,"batch":null,"display":"default","hidden":false,"length":0,"onMobile":true,"styles":["wrap"],"batchVertical":false,"clipboard":false,"wrap":false,"flags":{"alignEnd":false,"alignMid":false,"bold":false,"boolAtrIcon":false,"clipboard":false,"italic":false,"monospace":false,"noShrink":false,"noThousandsSep":false,"previewLarge":false,"vertical":false,"wrap":true}},{"id":"f4860d78-ff2f-4eca-bd48-0b353b52cfeb","attributeId":"51dc5dc0-6535-455b-b331-49c70dcaf66a","index":0,"groupBy":false,"aggregator":"list","distincted":false,"subQuery":true,"query":{"id":"44145059-b03a-4799-9957-bb90d00046b1","relationId":"7159b863-3b9a-4f35-9a5a-885eebf24ab0","fixedLimit":0,"joins":[{"relationId":"7159b863-3b9a-4f35-9a5a-885eebf24ab0","attributeId":null,"indexFrom":-1,"index":0,"connector":"INNER","applyCreate":false,"applyUpdate":false,"applyDelete":false},{"relationId":"ad7cf423-0c4f-46e5-97fa-f4a8527a43f9","attributeId":"62fb1ae2-94b9-47df-8f70-ad719aec4cf1","indexFrom":0,"index":1,"connector":"LEFT","applyCreate":false,"applyUpdate":false,"applyDelete":false}],"filters":[{"connector":"AND","operator":"=","index":0,"side0":{"brackets":1,"value":"","attributeId":"2c69f182-11f9-4d45-ab1b-32c14804e74c","attributeIndex":1,"attributeNested":1,"nowOffset":null},"side1":{"brackets":1,"value":null,"attributeId":"2c69f182-11f9-4d45-ab1b-32c14804e74c","attributeIndex":0,"attributeNested":0,"nowOffset":null}}],"orders":[],"lookups":[],"choices":[]},"captions":{"columnTitle":{"de_de":"Eltern"}},"basis":0,"batch":null,"display":"default","hidden":false,"length":0,"onMobile":true,"styles":["wrap"],"batchVertical":false,"clipboard":false,"wrap":false,"flags":{"alignEnd":false,"alignMid":false,"bold":false,"boolAtrIcon":false,"clipboard":false,"italic":false,"monospace":false,"noShrink":false,"noThousandsSep":false,"previewLarge":false,"vertical":false,"wrap":true}},{"id":"35d931ee-f9a2-4813-a0ce-2a598ce219b0","attributeId":"fa114902-ccf1-4de7-9eba-8754704f1f07","index":0,"groupBy":false,"aggregator":"list","distincted":false,"subQuery":true,"query":{"id":"5ae1b616-72c3-4e3d-a3f5-5cdc71926325","relationId":"50838636-773e-4766-9d4c-b04fe585ca05","fixedLimit":0,"joins":[{"relationId":"50838636-773e-4766-9d4c-b04fe585ca05","attributeId":null,"indexFrom":-1,"index":0,"connector":"INNER","applyCreate":false,"applyUpdate":false,"applyDelete":false},{"relationId":"ad7cf423-0c4f-46e5-97fa-f4a8527a43f9","attributeId":"a5c0c6c6-c4ca-4e4b-8ef4-0e79f4372467","indexFrom":0,"index":1,"connector":"LEFT","applyCreate":false,"applyUpdate":false,"applyDelete":false}],"filters":[{"connector":"AND","operator":"=","index":0,"side0":{"brackets":1,"value":"","attributeId":"2c69f182-11f9-4d45-ab1b-32c14804e74c","attributeIndex":1,"attributeNested":1,"nowOffset":null},"side1":{"brackets":1,"value":null,"attributeId":"2c69f182-11f9-4d45-ab1b-32c14804e74c","attributeIndex":0,"attributeNested":0,"nowOffset":null}}],"orders":[],"lookups":[],"choices":[]},"captions":{"columnTitle":{"de_de":"Kind"}},"basis":0,"batch":null,"display":"default","hidden":false,"length":0,"onMobile":true,"styles":["wrap"],"batchVertical":false,"clipboard":false,"wrap":false,"flags":{"alignEnd":false,"alignMid":false,"bold":false,"boolAtrIcon":false,"clipboard":false,"italic":false,"monospace":false,"noShrink":false,"noThousandsSep":false,"previewLarge":false,"vertical":false,"wrap":true}},{"id":"7806e5f6-1aae-4f39-a534-cf441d40cca2","attributeId":"1ffb692f-d78a-40b0-bf26-74b66abf13ee","index":0,"groupBy":false,"aggregator":"list","distincted":false,"subQuery":true,"query":{"id":"6716b678-b0b2-4beb-9d9f-6e03c1cb7132","relationId":"7159b863-3b9a-4f35-9a5a-885eebf24ab0","fixedLimit":0,"joins":[{"relationId":"7159b863-3b9a-4f35-9a5a-885eebf24ab0","attributeId":null,"indexFrom":-1,"index":0,"connector":"INNER","applyCreate":true,"applyUpdate":true,"applyDelete":true},{"relationId":"ad7cf423-0c4f-46e5-97fa-f4a8527a43f9","attributeId":"62fb1ae2-94b9-47df-8f70-ad719aec4cf1","indexFrom":0,"index":1,"connector":"LEFT","applyCreate":false,"applyUpdate":false,"applyDelete":false}],"filters":[{"connector":"AND","operator":"=","index":0,"side0":{"brackets":1,"value":"","attributeId":"2c69f182-11f9-4d45-ab1b-32c14804e74c","attributeIndex":1,"attributeNested":1,"nowOffset":null},"side1":{"brackets":1,"value":null,"attributeId":"2c69f182-11f9-4d45-ab1b-32c14804e74c","attributeIndex":0,"attributeNested":0,"nowOffset":null}}],"orders":[],"lookups":[],"choices":[]},"captions":{"columnTitle":{"de_de":"Email"}},"basis":0,"batch":null,"display":"default","hidden":false,"length":0,"onMobile":true,"styles":["wrap"],"batchVertical":false,"clipboard":false,"wrap":false,"flags":{"alignEnd":false,"alignMid":false,"bold":false,"boolAtrIcon":false,"clipboard":false,"italic":false,"monospace":false,"noShrink":false,"noThousandsSep":false,"previewLarge":false,"vertical":false,"wrap":true}}]&joins=[]&expressions=[{"attributeId":"5f7c5aa8-b1f5-42b1-901f-a8d009984a6e","index":0,"groupBy":false,"aggregator":null,"distincted":false},{"aggregator":"sum","query":{"relationId":"4653ef81-853d-41d1-b51f-9cba8eb61b28","limit":0,"joins":[{"relationId":"4653ef81-853d-41d1-b51f-9cba8eb61b28","attributeId":null,"indexFrom":-1,"index":0,"connector":"INNER","applyCreate":true,"applyUpdate":true,"applyDelete":true}],"expressions":[{"attributeId":"591af583-3d98-4847-b0e1-03ebd52d4614","index":0,"groupBy":false,"aggregator":null,"distincted":false}],"filters":[{"connector":"AND","operator":"=","index":0,"side0":{"brackets":1,"value":"","attributeId":"2c69f182-11f9-4d45-ab1b-32c14804e74c","attributeIndex":0,"attributeNested":0,"nowOffset":null},"side1":{"brackets":0,"value":null,"attributeId":"6e8ca060-6665-489e-ba92-c4ef323de6cb","attributeIndex":0,"attributeNested":1,"nowOffset":null}},{"connector":"AND","operator":"IS NULL","index":0,"side0":{"brackets":2,"value":1,"attributeId":null,"attributeIndex":0,"attributeNested":0,"nowOffset":null},"side1":{"brackets":1,"value":"","attributeId":null,"attributeIndex":0,"attributeNested":0,"nowOffset":null}},{"connector":"OR","operator":"IS NOT NULL","index":0,"side0":{"brackets":1,"value":1,"attributeId":null,"attributeIndex":0,"attributeNested":0,"nowOffset":null},"side1":{"brackets":0,"value":"","attributeId":null,"attributeIndex":0,"attributeNested":0,"nowOffset":null}},{"connector":"AND","operator":"=","index":0,"side0":{"brackets":0,"value":"","attributeId":"6d42bce4-ce63-4444-8cda-8bd94962c7b3","attributeIndex":0,"attributeNested":1,"nowOffset":null},"side1":{"brackets":3,"value":1,"attributeId":null,"attributeIndex":0,"attributeNested":0,"nowOffset":null}}],"orders":[]}},{"aggregator":"list","query":{"relationId":"7159b863-3b9a-4f35-9a5a-885eebf24ab0","limit":0,"joins":[{"relationId":"7159b863-3b9a-4f35-9a5a-885eebf24ab0","attributeId":null,"indexFrom":-1,"index":0,"connector":"INNER","applyCreate":false,"applyUpdate":false,"applyDelete":false},{"relationId":"ad7cf423-0c4f-46e5-97fa-f4a8527a43f9","attributeId":"62fb1ae2-94b9-47df-8f70-ad719aec4cf1","indexFrom":0,"index":1,"connector":"LEFT","applyCreate":false,"applyUpdate":false,"applyDelete":false}],"expressions":[{"attributeId":"51dc5dc0-6535-455b-b331-49c70dcaf66a","index":0,"groupBy":false,"aggregator":null,"distincted":false}],"filters":[{"connector":"AND","operator":"=","index":0,"side0":{"brackets":1,"value":"","attributeId":"2c69f182-11f9-4d45-ab1b-32c14804e74c","attributeIndex":1,"attributeNested":1,"nowOffset":null},"side1":{"brackets":1,"value":null,"attributeId":"2c69f182-11f9-4d45-ab1b-32c14804e74c","attributeIndex":0,"attributeNested":0,"nowOffset":null}}],"orders":[]}},{"aggregator":"list","query":{"relationId":"50838636-773e-4766-9d4c-b04fe585ca05","limit":0,"joins":[{"relationId":"50838636-773e-4766-9d4c-b04fe585ca05","attributeId":null,"indexFrom":-1,"index":0,"connector":"INNER","applyCreate":false,"applyUpdate":false,"applyDelete":false},{"relationId":"ad7cf423-0c4f-46e5-97fa-f4a8527a43f9","attributeId":"a5c0c6c6-c4ca-4e4b-8ef4-0e79f4372467","indexFrom":0,"index":1,"connector":"LEFT","applyCreate":false,"applyUpdate":false,"applyDelete":false}],"expressions":[{"attributeId":"fa114902-ccf1-4de7-9eba-8754704f1f07","index":0,"groupBy":false,"aggregator":null,"distincted":false}],"filters":[{"connector":"AND","operator":"=","index":0,"side0":{"brackets":1,"value":"","attributeId":"2c69f182-11f9-4d45-ab1b-32c14804e74c","attributeIndex":1,"attributeNested":1,"nowOffset":null},"side1":{"brackets":1,"value":null,"attributeId":"2c69f182-11f9-4d45-ab1b-32c14804e74c","attributeIndex":0,"attributeNested":0,"nowOffset":null}}],"orders":[]}},{"aggregator":"list","query":{"relationId":"7159b863-3b9a-4f35-9a5a-885eebf24ab0","limit":0,"joins":[{"relationId":"7159b863-3b9a-4f35-9a5a-885eebf24ab0","attributeId":null,"indexFrom":-1,"index":0,"connector":"INNER","applyCreate":true,"applyUpdate":true,"applyDelete":true},{"relationId":"ad7cf423-0c4f-46e5-97fa-f4a8527a43f9","attributeId":"62fb1ae2-94b9-47df-8f70-ad719aec4cf1","indexFrom":0,"index":1,"connector":"LEFT","applyCreate":false,"applyUpdate":false,"applyDelete":false}],"expressions":[{"attributeId":"1ffb692f-d78a-40b0-bf26-74b66abf13ee","index":0,"groupBy":false,"aggregator":null,"distincted":false}],"filters":[{"connector":"AND","operator":"=","index":0,"side0":{"brackets":1,"value":"","attributeId":"2c69f182-11f9-4d45-ab1b-32c14804e74c","attributeIndex":1,"attributeNested":1,"nowOffset":null},"side1":{"brackets":1,"value":null,"attributeId":"2c69f182-11f9-4d45-ab1b-32c14804e74c","attributeIndex":0,"attributeNested":0,"nowOffset":null}}],"orders":[]}}]&filters=[{"connector":"AND","operator":"=","index":0,"side0":{"brackets":1,"value":"","attributeId":"7117a1ac-4b32-44e1-b911-bd8f548b5d05","attributeIndex":0,"attributeNested":0,"nowOffset":null},"side1":{"brackets":1,"value":true,"attributeId":null,"attributeIndex":0,"attributeNested":0,"nowOffset":null}}]&orders=[{"ascending":false,"expressionPos":1}]&total_limit=500×tamp=1759130785 hat möglicherweise ein temporäres Problem oder ist umgezogen.
Fehlercode: 400 Bad Request
Die Website könnte vorübergehend nicht erreichbar sein, versuchen Sie es bitte später nochmals.
`
