Errors during generation of change report as admin with src/dst filters

[tpurschke]

          Errors during generation of change report as Admin with src/dst filters:

UI: Generate report - Unclassified error: : field 'rule_froms' not found in type: 'changelog_rule_bool_exp' . See log for details!

2024-03-18T16:29:10.545092+00:00 ubu22srv fworch-ui:  2024-03-18T16:29:10+00:00 Error - API Connection (GraphQlApiConnection.cs in line 138), Error while sending query to GraphQL API. Caught by GraphQL client library.
2024-03-18T16:29:10.545589+00:00 ubu22srv fworch-ui:  Message: field 'rule_froms' not found in type: 'changelog_rule_bool_exp'
2024-03-18T16:29:10.545662+00:00 ubu22srv fworch-ui:  2024-03-18T16:29:10+00:00 Error - API Connection (GraphQlApiConnection.cs in line 173), Error while sending query to GraphQL API. Query: fragment networkObjectOverview on object { obj_ip obj_ip_end obj_name obj_id type: stm_obj_typ { id: obj_typ_id name: obj_typ_name } obj_color_id}fragment networkServiceOverview on service { svc_id svc_name svc_uid svc_port svc_port_end service_type: stm_svc_typ { id: svc_typ_id name: svc_typ_name } svc_color_id protocol_name: stm_ip_proto { id: ip_proto_id name: ip_proto_name }}fragment userOverview on usr { user_id user_uid user_name stm_usr_typ { usr_typ_name }}fragment ruleOverview on rule { rule_id rule_uid dev_id rule_action section_header: rule_head_text rule_comment rule_track rule_disabled src_zone: zone { zone_name zone_id } rule_metadatum { rule_metadata_id rule_created rule_first_hit rule_last_hit rule_last_modified rule_last_certified rule_last_certifier_dn rule_to_be_removed rule_decert_date rule_recertification_comment } rule_src_neg rule_dst_neg rule_svc_neg rule_num_numeric rule_name access_rule nat_rule xlate_rule rule_froms(where: {object: {obj_create: {_lte: $relevantImportId}, obj_last_seen: {_gte: $relevantImportId}}}) { usr { ...userOverview } object { ...networkObjectOverview } } dst_zone: zoneByRuleToZone { zone_name zone_id } rule_tos(where: {object: {obj_create: {_lte: $relevantImportId}, obj_last_seen: {_gte: $relevantImportId}}}) { usr { ...userOverview } object { ...networkObjectOverview } } rule_services(where: {service: {svc_create: {_lte: $relevantImportId}, svc_last_seen: {_gte: $relevantImportId}}}) { service { ...networkServiceOverview } }} query changeReport( $limit: Int $offset: Int $start: timestamp! $stop: timestamp! $relevantImportId: bigint $src0: String! ) { management(where: { hide_in_gui: {_eq: false } stm_dev_typ: {dev_typ_is_multi_mgmt: {_eq: false} is_pure_routing_device: {_eq: false} } } order_by: {mgm_name: asc}) { id: mgm_id name: mgm_name devices (where: { hide_in_gui: {_eq: false }, stm_dev_typ: {is_pure_routing_device:{_eq:false} } } order_by: { dev_name: asc }) { id: dev_id name: dev_name changelog_rules( offset: $offset limit: $limit where: { _or:[ {_and: [{change_action:{_eq:"I"}}, {rule: {access_rule:{_eq:true}}}]}, {_and: [{change_action:{_eq:"D"}}, {ruleByOldRuleId: {access_rule:{_eq:true}}}]}, {_and: [{change_action:{_eq:"C"}}, {rule: {access_rule:{_eq:true}}}, {ruleByOldRuleId: {access_rule:{_eq:true}}}]} ] _and: [{_or: [{ device: {dev_id: {_eq:2} }}, { device: {dev_id: {_eq:1} }}]}, { _and: [ { import_control: { stop_time: { _gte: $start } } } { import_control: { stop_time: { _lte: $stop } } } ] change_type_id: { _eq: 3 } security_relevant: { _eq: true }}, {rule_froms: { object: { objgrp_flats: { objectByObjgrpFlatMemberId: { obj_name: { _ilike: $src0 } } } } }}] } order_by: { control_id: asc } ) { import: import_control { time: stop_time } change_action old: ruleByOldRuleId { mgm_id: mgm_id ...ruleOverview } new: rule { mgm_id: mgm_id ...ruleOverview } } } } }, variables: {"start":"2024-01-01","stop":"2025-01-01","src0":"%ip4_test_group%","limit":100,"offset":0}
2024-03-18T16:29:10.545762+00:00 ubu22srv fworch-ui:   ---
2024-03-18T16:29:10.545795+00:00 ubu22srv fworch-ui:  Exception thrown:
2024-03-18T16:29:10.545821+00:00 ubu22srv fworch-ui:   Exception
2024-03-18T16:29:10.545850+00:00 ubu22srv fworch-ui:  Message:
2024-03-18T16:29:10.545876+00:00 ubu22srv fworch-ui:   field 'rule_froms' not found in type: 'changelog_rule_bool_exp'
2024-03-18T16:29:10.545907+00:00 ubu22srv fworch-ui:   
2024-03-18T16:29:10.545933+00:00 ubu22srv fworch-ui:  Stack Trace:
2024-03-18T16:29:10.545962+00:00 ubu22srv fworch-ui:   at FWO.Api.Client.GraphQlApiConnection.SendQueryAsync[QueryResponseType](String query, Object variables, String operationName) in /usr/local/fworch/lib/files/FWO.Api.Client/GraphQlApiConnection.cs:line 142
2024-03-18T16:29:10.552335+00:00 ubu22srv fworch-ui:  2024-03-18T16:29:10+00:00 Error - Generate report (MainLayout.razor in line 310), User: admin, Role: admin, Unspecified error occured:
2024-03-18T16:29:10.552440+00:00 ubu22srv fworch-ui:   ---
2024-03-18T16:29:10.552475+00:00 ubu22srv fworch-ui:  Exception thrown:
2024-03-18T16:29:10.552514+00:00 ubu22srv fworch-ui:   Exception
2024-03-18T16:29:10.552558+00:00 ubu22srv fworch-ui:  Message:
2024-03-18T16:29:10.552595+00:00 ubu22srv fworch-ui:   field 'rule_froms' not found in type: 'changelog_rule_bool_exp'
2024-03-18T16:29:10.552629+00:00 ubu22srv fworch-ui:   
2024-03-18T16:29:10.552660+00:00 ubu22srv fworch-ui:  Stack Trace:
2024-03-18T16:29:10.552693+00:00 ubu22srv fworch-ui:   at FWO.Api.Client.GraphQlApiConnection.SendQueryAsync[QueryResponseType](String query, Object variables, String operationName) in /usr/local/fworch/lib/files/FWO.Api.Client/GraphQlApiConnection.cs:line 142
2024-03-18T16:29:10.552725+00:00 ubu22srv fworch-ui:     at FWO.Report.ReportChanges.Generate(Int32 changesPerFetch, ApiConnection apiConnection, Func`2 callback, CancellationToken ct) in /usr/local/fworch/lib/files/FWO.Report/ReportChanges.cs:line 25
2024-03-18T16:29:10.552766+00:00 ubu22srv fworch-ui:     at FWO.Ui.Pages.Reporting.Report.GenerateReport() in /usr/local/fworch/ui/files/FWO.UI/Pages/Reporting/Report.razor:line 383
2024-03-18T16:29:10.552809+00:00 ubu22srv fworch-ui:  FWORCHAlert - source: "ui", userId: "3", title: "Generate report", description: "Unclassified error: : field 'rule_froms' not found in type: 'changelog_rule_bool_exp'
2024-03-18T16:29:10.552843+00:00 ubu22srv fworch-ui:   . See log for details!", alertCode: "UiError"
2024-03-18T16:29:11.525877+00:00 ubu22srv fworch-ui:  2024-03-18T16:29:11+00:00 Error - Ip displaying (DisplayBase.cs in line 120), Wrong ip format 3.2.2.0/24 - 3.2.2.0/24
2024-03-18T16:29:11.525976+00:00 ubu22srv fworch-ui:  Message: An invalid IP address was specified.
2024-03-18T16:29:11.526017+00:00 ubu22srv fworch-ui:  2024-03-18T16:29:11+00:00 Error - Ip displaying (DisplayBase.cs in line 120), Wrong ip format 3.2.2.0/24 - 3.2.2.0/24
2024-03-18T16:29:11.526039+00:00 ubu22srv fworch-ui:  Message: An invalid IP address was specified.

Originally posted by @tpurschke in https://github.com/CactuseSecurity/firewall-orchestrator/pull/2357#pullrequestreview-1943571055