discourse/plugins/discourse-data-explorer/config/locales/client.en.yml

en:
  admin_js:
    admin:
      site_settings:
        categories:
          discourse_data_explorer: "Discourse Data Explorer"
  js:
    discourse_ai:
      features:
        data_explorer:
          name: "Data Explorer"
          description: "AI-powered query generation for Data Explorer"
          query_generation: "Query Generation"
    errors:
      explorer:
        no_semicolons: "Remove the semicolons from the query."
        dirty: "You must save the query before running."
    data_explorer:
      admin_dashboard_card:
        no_results: "No results"
      manage_reports_hint:
        title: "Create a Data Explorer query"
        description: "Write a custom SQL query to surface anything specific to your community."
    explorer:
      default_query: "Default"
      default_query_notice: "This is a default query, the SQL cannot be edited. To edit the SQL, create a new query."
      queries: "Queries"
      query_created: "Query created!"
      mode:
        label: "Query authoring mode"
        manual: "Write SQL"
        ai: "Generate with AI"
      or: "or"
      admins_only: "The data explorer is only available to admins."
      allow_groups: "Allow groups to access this query"
      title: "Data Explorer"
      create: "Create"
      create_placeholder: "Query name..."
      description_placeholder: "Enter a description here"
      ai:
        description_title: "Generate with AI"
        description_hint: "Describe what you want in plain language. We'll generate the SQL, name, and description for you."
        description_placeholder: "e.g. Show me signups across time"
        regenerate_placeholder: "e.g. Update the query to limit to 50 results"
        prompt_label: "Prompt"
        generate: "Generate"
        regenerate: "Update query"
        generating: "Generating query with AI..."
        generation_timeout: "AI query generation timed out. You can write the SQL manually."
        generation_error: "Something went wrong generating the query."
        save_query: "Save query"
        write_manually: "Write SQL manually"
        sql_label: "SQL"
        optional: "optional"
      import:
        label: "Import"
        unparseable_json: "Unparseable JSON file."
        wrong_json: "Wrong JSON file. A JSON file should contain a 'query' object, which should at least have an 'sql' property."
      help:
        label: "Help"
        modal_title: "Data Explorer Help"
        auto_resolution: "<h2>Automatic entity resolution</h2>
          <p>When your query returns an entity id, Data Explorer may automatically substitute it with
          the entity name and other useful information in query results. Automatic resolution is available for
          <i><b>user_id</b></i>, <i><b>group_id</b></i>, <i><b>topic_id</b></i>, <i><b>category_id</b></i>
          and <i><b>badge_id</b></i>. To try this out run this query:</p>
          <pre><code>SELECT user_id\nFROM posts</code></pre>"
        custom_params: "<h2>Creating custom parameters</h2>
          <p>To create custom parameters for your queries, put this at the top of your query and follow the format:</p>
          <pre><code>-- [params]\n-- int :num = 1\n\nSELECT :num</code></pre>
          <p><i>Note: the first line with [params] is required, along with two dashes preceding it and every
          custom parameter you want to declare.</i></p>"
        default_values: "<h3>Default values</h3>
          <p>You can declare parameters with or without default values. Default values will show up in a text field
          below the query editor, which you can edit to your needs. Parameters declared without default values will
          still generate a text field, but will be empty and highlighted red.</p>
          <pre><code>-- [params]\n-- text :username = my_username\n-- int :age</code></pre>"
        data_types: "<h3>Data types</h3>
          <p>Here are common data types you can use:</p>
          <ul>
          <li><b>integer</b> - signed four-byte Integer</li>
          <li><b>text</b> - variable-length character string</li>
          <li><b>boolean</b> – true/false</li>
          <li><b>date</b> - calendar date (year, month, day)</li>
          <li><b>current_user_id</b> - ID of the user running the query (auto-injected, useful for group reports)</li>
          </ul>
          <p>For more information on data types, visit
          <a href='http://www.postgresql.org/docs/9.3/static/datatype.html#DATATYPE-TABLE' target='_blank'>this website</a>.</p>"
      schema:
        title: "Database Schema"
        filter: "Search..."
        search_tables: "Search tables"
        hide: "Hide schema"
        show: "Show schema"
        sensitive: "The contents of this column may contain particularly sensitive or private information. Please exercise caution when using the contents of this column."
      types:
        bool:
          yes: "Yes"
          no: "No"
          null_: "Null"
      view_json: "View JSON"
      save: "Save changes"
      saverun: "Save changes and run"
      run: "Run"
      undo: "Discard changes"
      delete: "Delete"
      recover: "Undelete query"
      sql_label: "SQL"
      run_with_explain: "Run with query plan"
      run_options: "More run options"
      view:
        label: "Result view"
      chart:
        form:
          label: "Chart type"
          line: "Line"
          bar: "Bar"
          stacked: "Stacked"
          dual_axis: "Dual axis"
        tooltip:
          total: "Total: %{count}"
      chart_empty:
        no_rows: "No rows to chart."
        no_numeric: "This query has no numeric columns to chart."
        no_numeric_with_columns: "This query has no numeric columns to chart (ignored: %{columns})."
        view_as_table: "View as table"
      chart_footnote:
        ignored: "Columns not charted: %{columns}"
      export_as:
        label: "Export as…"
        results_json: "Results (JSON)"
        results_csv: "Results (CSV)"
        query_json: "Query definition (JSON)"
      others_dirty: "A query has unsaved changes that will be lost if you navigate away."
      run_time: "Query completed in %{value} ms."
      cached_result_notice: "Showing cached results from %{relative_time}."
      result_count:
        one: "%{count} result."
        other: "%{count} results."
      max_result_count:
        one: "Showing top %{count} result."
        other: "Showing top %{count} results."
      query_name: "Query"
      query_groups: "Groups"
      link: "Link for"
      report_name: "Report"
      query_description: "Description"
      query_time: "Last run"
      query_user: "Created by"
      column: "Column %{number}"
      save_params: "Set defaults"
      reset_params: "Reset"
      search_placeholder: "Search..."
      no_search_results: "Sorry, we couldn't find any results matching your text."
      form:
        errors:
          invalid: "Invalid"
          no_such_category: "No such category"
          no_such_group: "No such group"
          invalid_date: "%{date} is an invalid date"
          invalid_time: "%{time} is an invalid time"
    group:
      reports: "Reports"
    admin:
      api:
        scopes:
          descriptions:
            data_explorer:
              run_queries: "Run Data Explorer queries. Restrict the API key to a set of queries by specifying queries IDs."
    discourse_workflows:
      node_unavailable:
        requires_data_explorer: "Requires the Data Explorer plugin to be enabled"
      nodes:
        "action:sql": "Data Explorer"
      node_descriptions:
        "action:sql": "Run a read-only SQL query against the database"
      sql:
        operation: "Operation"
        operation_description: "How to run the query"
        queries: "Queries"
        raw: "Raw SQL"
        query_id: "Query"
        query_id_description: "Select a saved query to run"
        query_params: "Query parameters"
        query_params_description: "Fill in the parameters for the selected query"
        query: "SQL query"
        query_description: "Write a read-only SQL query. Declare parameters with Data Explorer syntax and map their values below."
        params: "Query parameters"
        params_description: "Parameters can be used as :my_param in the SQL query."
        add_param: "Add parameter"
        param_name: "Param"
        param_value: "Value"
        output:
          results: "Results"
          no_results: "No results"
    discourse_automation:
      scriptables:
        recurring_data_explorer_result_pm:
          fields:
            recipients:
              label: Send to User, Group or Email
            query_id:
              label: Data Explorer Query
            query_params:
              label: Data Explorer Query parameters
            skip_empty:
              label: Skip sending PM if there are no results
            attach_csv:
              label: Attach the CSV file to the PM
            users_from_group:
              label: Send individual PM to each group member
        recurring_data_explorer_result_topic:
          fields:
            topic_id:
              label: The topic to post query results in
            query_id:
              label: Data Explorer Query
            query_params:
              label: Data Explorer Query parameters
            skip_empty:
              label: Skip posting if there are no results
            attach_csv:
              label: Attach the CSV file to the post