GQL Statement

IF(
  GRAPH().future?,
  -> { DIVIDE(Q(total_costs),AREA(number_of_residences)) },
  -> { 0 }
)

Result

Gql::CommandError:

undefined method `number_of_residences' for <Area nl>:Qernel::Area

        graph.area.send(key)
                  ^^^^^
Did you mean?  number_of_cars

Backtrace

/app/app/models/gql/query_interface/lookup.rb:46:in `area'
/app/app/models/gql/runtime/functions/lookup.rb:179:in `AREA'
/app/tmp/etsource/gqueries/output_elements/dashboard/dashboard_total_costs_per_household.gql:4: in `query in dashboard_total_costs_per_household'
/app/app/models/gql/runtime/functions/control.rb:7:in `IF'
(eval):1:in `block in sanitized_proc'
/app/vendor/bundle/ruby/3.1.0/bundler/gems/rubel-e36554afd5f6/lib/rubel/core.rb:9:in `instance_exec'
/app/vendor/bundle/ruby/3.1.0/bundler/gems/rubel-e36554afd5f6/lib/rubel/core.rb:9:in `execute'
/app/app/models/gql/query_interface/base.rb:70:in `rubel_execute'
/app/app/models/gql/query_interface/base.rb:46:in `subquery'
/app/app/models/gql/query_interface/query_cache.rb:17:in `subquery'
/app/app/models/gql/query_interface/query_memoization.rb:13:in `subquery'
/app/app/models/gql/query_interface/base.rb:26:in `query'
/app/app/models/gql/gql.rb:360:in `query_future'
/app/app/models/gql/gql.rb:341:in `block in query_standard_with_timing'
/app/app/models/gql/gql.rb:398:in `with_timing'
/app/app/models/gql/gql.rb:341:in `query_standard_with_timing'
/app/app/models/gql/gql.rb:184:in `block in query_with_modifier'
/app/app/lib/instrumentable.rb:5:in `block in instrument'
/app/vendor/bundle/ruby/3.1.0/gems/activesupport-7.0.8.5/lib/active_support/notifications.rb:206:in `block in instrument'
/app/vendor/bundle/ruby/3.1.0/gems/activesupport-7.0.8.5/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
/app/vendor/bundle/ruby/3.1.0/gems/sentry-rails-5.19.0/lib/sentry/rails/tracing.rb:54:in `instrument'
/app/vendor/bundle/ruby/3.1.0/gems/activesupport-7.0.8.5/lib/active_support/notifications.rb:206:in `instrument'
/app/app/lib/instrumentable.rb:4:in `instrument'
/app/app/models/gql/gql.rb:181:in `query_with_modifier'
/app/app/models/gql/gql.rb:161:in `query'
/app/app/controllers/inspect/lazy_gql.rb:13:in `public_send'
/app/app/controllers/inspect/lazy_gql.rb:13:in `method_missing'
/app/app/controllers/inspect/gqueries_controller.rb:29:in `show'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_controller/metal/basic_implicit_render.rb:6:in `send_action'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/abstract_controller/base.rb:215:in `process_action'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_controller/metal/rendering.rb:165:in `process_action'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/abstract_controller/callbacks.rb:234:in `block in process_action'
/app/vendor/bundle/ruby/3.1.0/gems/activesupport-7.0.8.5/lib/active_support/callbacks.rb:118:in `block in run_callbacks'
/app/vendor/bundle/ruby/3.1.0/gems/actiontext-7.0.8.5/lib/action_text/rendering.rb:20:in `with_renderer'
/app/vendor/bundle/ruby/3.1.0/gems/actiontext-7.0.8.5/lib/action_text/engine.rb:69:in `block (4 levels) in <class:Engine>'
/app/vendor/bundle/ruby/3.1.0/gems/activesupport-7.0.8.5/lib/active_support/callbacks.rb:127:in `instance_exec'
/app/vendor/bundle/ruby/3.1.0/gems/activesupport-7.0.8.5/lib/active_support/callbacks.rb:127:in `block in run_callbacks'
/app/vendor/bundle/ruby/3.1.0/gems/sentry-rails-5.19.0/lib/sentry/rails/controller_transaction.rb:19:in `block in sentry_around_action'
/app/vendor/bundle/ruby/3.1.0/gems/sentry-ruby-5.19.0/lib/sentry/hub.rb:109:in `block in with_child_span'
/app/vendor/bundle/ruby/3.1.0/gems/sentry-ruby-5.19.0/lib/sentry/span.rb:226:in `with_child_span'
/app/vendor/bundle/ruby/3.1.0/gems/sentry-ruby-5.19.0/lib/sentry/hub.rb:107:in `with_child_span'
/app/vendor/bundle/ruby/3.1.0/gems/sentry-ruby-5.19.0/lib/sentry-ruby.rb:498:in `with_child_span'
/app/vendor/bundle/ruby/3.1.0/gems/sentry-rails-5.19.0/lib/sentry/rails/controller_transaction.rb:16:in `sentry_around_action'
/app/vendor/bundle/ruby/3.1.0/gems/activesupport-7.0.8.5/lib/active_support/callbacks.rb:127:in `block in run_callbacks'
/app/vendor/bundle/ruby/3.1.0/gems/activesupport-7.0.8.5/lib/active_support/callbacks.rb:138:in `run_callbacks'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/abstract_controller/callbacks.rb:233:in `process_action'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_controller/metal/rescue.rb:23:in `process_action'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_controller/metal/instrumentation.rb:67:in `block in process_action'
/app/vendor/bundle/ruby/3.1.0/gems/activesupport-7.0.8.5/lib/active_support/notifications.rb:206:in `block in instrument'
/app/vendor/bundle/ruby/3.1.0/gems/activesupport-7.0.8.5/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
/app/vendor/bundle/ruby/3.1.0/gems/sentry-rails-5.19.0/lib/sentry/rails/tracing.rb:54:in `instrument'
/app/vendor/bundle/ruby/3.1.0/gems/activesupport-7.0.8.5/lib/active_support/notifications.rb:206:in `instrument'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_controller/metal/instrumentation.rb:66:in `process_action'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_controller/metal/params_wrapper.rb:259:in `process_action'
/app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.8.5/lib/active_record/railties/controller_runtime.rb:27:in `process_action'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/abstract_controller/base.rb:151:in `process'
/app/vendor/bundle/ruby/3.1.0/gems/actionview-7.0.8.5/lib/action_view/rendering.rb:39:in `process'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_controller/metal.rb:188:in `dispatch'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_controller/metal.rb:251:in `dispatch'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_dispatch/routing/route_set.rb:49:in `dispatch'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_dispatch/routing/route_set.rb:32:in `serve'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_dispatch/journey/router.rb:50:in `block in serve'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_dispatch/journey/router.rb:32:in `each'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_dispatch/journey/router.rb:32:in `serve'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_dispatch/routing/route_set.rb:852:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/rack/agent_hooks.rb:30:in `traced_call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/rack/browser_monitoring.rb:33:in `traced_call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/http_accept_language-2.1.1/lib/http_accept_language/middleware.rb:14:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/warden-1.2.9/lib/warden/manager.rb:36:in `block in call'
/app/vendor/bundle/ruby/3.1.0/gems/warden-1.2.9/lib/warden/manager.rb:34:in `catch'
/app/vendor/bundle/ruby/3.1.0/gems/warden-1.2.9/lib/warden/manager.rb:34:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/rack-2.2.10/lib/rack/tempfile_reaper.rb:15:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/rack-2.2.10/lib/rack/etag.rb:27:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/rack-2.2.10/lib/rack/conditional_get.rb:27:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/rack-2.2.10/lib/rack/head.rb:12:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_dispatch/http/permissions_policy.rb:38:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_dispatch/http/content_security_policy.rb:36:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/rack-2.2.10/lib/rack/session/abstract/id.rb:266:in `context'
/app/vendor/bundle/ruby/3.1.0/gems/rack-2.2.10/lib/rack/session/abstract/id.rb:260:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_dispatch/middleware/cookies.rb:704:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_dispatch/middleware/callbacks.rb:27:in `block in call'
/app/vendor/bundle/ruby/3.1.0/gems/activesupport-7.0.8.5/lib/active_support/callbacks.rb:99:in `run_callbacks'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_dispatch/middleware/callbacks.rb:26:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/sentry-rails-5.19.0/lib/sentry/rails/rescued_exception_interceptor.rb:12:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_dispatch/middleware/debug_exceptions.rb:28:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/sentry-ruby-5.19.0/lib/sentry/rack/capture_exceptions.rb:30:in `block (2 levels) in call'
/app/vendor/bundle/ruby/3.1.0/gems/sentry-ruby-5.19.0/lib/sentry/hub.rb:258:in `with_session_tracking'
/app/vendor/bundle/ruby/3.1.0/gems/sentry-ruby-5.19.0/lib/sentry-ruby.rb:411:in `with_session_tracking'
/app/vendor/bundle/ruby/3.1.0/gems/sentry-ruby-5.19.0/lib/sentry/rack/capture_exceptions.rb:21:in `block in call'
/app/vendor/bundle/ruby/3.1.0/gems/sentry-ruby-5.19.0/lib/sentry/hub.rb:59:in `with_scope'
/app/vendor/bundle/ruby/3.1.0/gems/sentry-ruby-5.19.0/lib/sentry-ruby.rb:391:in `with_scope'
/app/vendor/bundle/ruby/3.1.0/gems/sentry-ruby-5.19.0/lib/sentry/rack/capture_exceptions.rb:20:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_dispatch/middleware/show_exceptions.rb:29:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/railties-7.0.8.5/lib/rails/rack/logger.rb:40:in `call_app'
/app/vendor/bundle/ruby/3.1.0/gems/railties-7.0.8.5/lib/rails/rack/logger.rb:25:in `block in call'
/app/vendor/bundle/ruby/3.1.0/gems/activesupport-7.0.8.5/lib/active_support/tagged_logging.rb:99:in `block in tagged'
/app/vendor/bundle/ruby/3.1.0/gems/activesupport-7.0.8.5/lib/active_support/tagged_logging.rb:37:in `tagged'
/app/vendor/bundle/ruby/3.1.0/gems/activesupport-7.0.8.5/lib/active_support/tagged_logging.rb:99:in `tagged'
/app/vendor/bundle/ruby/3.1.0/gems/railties-7.0.8.5/lib/rails/rack/logger.rb:25:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_dispatch/middleware/remote_ip.rb:93:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_dispatch/middleware/request_id.rb:26:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/rack-2.2.10/lib/rack/method_override.rb:24:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/rack-2.2.10/lib/rack/runtime.rb:22:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/activesupport-7.0.8.5/lib/active_support/cache/strategy/local_cache_middleware.rb:29:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_dispatch/middleware/executor.rb:14:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_dispatch/middleware/static.rb:23:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/rack-2.2.10/lib/rack/sendfile.rb:110:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/actionpack-7.0.8.5/lib/action_dispatch/middleware/host_authorization.rb:131:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/rack-cors-1.1.1/lib/rack/cors.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/railties-7.0.8.5/lib/rails/engine.rb:530:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/newrelic_rpm-8.5.0/lib/new_relic/agent/instrumentation/middleware_tracing.rb:100:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/puma-5.6.9/lib/puma/configuration.rb:252:in `call'
/app/vendor/bundle/ruby/3.1.0/gems/puma-5.6.9/lib/puma/request.rb:77:in `block in handle_request'
/app/vendor/bundle/ruby/3.1.0/gems/puma-5.6.9/lib/puma/thread_pool.rb:340:in `with_force_shutdown'
/app/vendor/bundle/ruby/3.1.0/gems/puma-5.6.9/lib/puma/request.rb:76:in `handle_request'
/app/vendor/bundle/ruby/3.1.0/gems/puma-5.6.9/lib/puma/server.rb:443:in `process_client'
/app/vendor/bundle/ruby/3.1.0/gems/puma-5.6.9/lib/puma/thread_pool.rb:147:in `block in spawn_thread'

Description

Characteristics

Groups
Unit	euro
File path	/app/tmp/etsource/gqueries/output_elements/dashboard/dashboard_total_costs_per_household.gql

References