如何在Oracle APEX报表中仅为特定条件行添加编辑按钮

Got it, let's break down how to add an edit button only for rows where job = 'MANAGER' in your Oracle APEX report, with a redirect to another app page. I'll cover two straightforward approaches that work for most report types:

If you're using an Interactive Report, this is the simplest method—no custom PL/SQL required:

• Add a Button Column to Your Report

  1. Open your report page and navigate to the report's edit interface.
  2. In the "Columns" section, click "Add Column" and select the "Button" type.
  3. Name the button something descriptive (e.g., EDIT_MANAGER) and set the button text to "Edit".

• Set the Button's Display Condition

  1. In the button column's properties, scroll to the "Server-side Condition" section.
  2. Set "Type" to PL/SQL Expression.
  3. Enter the expression: :JOB = 'MANAGER' (replace :JOB with your actual column name—match the case of your data, or use UPPER(:JOB) = 'MANAGER' to avoid case sensitivity issues).

• Configure the Redirect Action

  1. Back in the button column's properties, find the "Action" section.
  2. Select Redirect to Page in this Application.
  3. Enter your target page number (e.g., 10).
  4. Under "Set Items", map your report's primary key column to the target page's item (e.g., P10_EMPNO:EMPNO—left is the target page's item name, right is your report's primary key column). This lets the target page load the correct record for editing.

If you're using a Classic Report or need more control over the button's HTML, use a PL/SQL expression column to dynamically render the button:

• Add a PL/SQL Expression Column

  1. Edit your report and add a new column with type PL/SQL Expression.
  2. Paste this expression (replace placeholders with your actual values):

     CASE WHEN job = 'MANAGER' THEN
       apex_button.get(
         p_action => 'REDIRECT',
         p_label => 'Edit',
         p_url => apex_page.get_url(
           p_page => 10, -- Replace with your target page ID
           p_items => 'P10_EMPNO', -- Replace with target page's item name
           p_values => empno -- Replace with your report's primary key column
         ),
         p_attributes => 'class="t-Button t-Button--small t-Button--hot"' -- Optional: Use APEX's built-in button styles
       )
     ELSE
       NULL
     END
     

• Adjust Column Properties

  1. Set the column's "Escape Special Characters" property to No—this ensures the HTML button renders correctly instead of showing raw code.
  2. You can set the column header to blank for a cleaner look.

Pro Tips to Avoid Issues #

• Case Sensitivity: If your job column has mixed case values, use UPPER(job) = 'MANAGER' in your condition to catch all variations.
• Parameter Passing: Always pass the primary key to the target page—without it, the edit page won't know which record to load.
• Testing: After setting up, run the page and verify:
  1. Only rows with job = 'MANAGER' show the Edit button.
  2. Clicking the button redirects to the correct page with the right record loaded.

内容的提问来源于stack exchange，提问作者Astro