You will want to look in the ITEM_HISTORY table. That table has a history of activity. Out-of-the-box, not all file (attachment) operations are recorded in history. For instance, viewing a file. If you need to capture viewing then there is a configuration setting to enable recording that in history.

You can search by item bom table but not the affected item bom table. Sorry. Those other two methods end up being the only way to look at redlines: program (SDK) or database (SQL).

Kevin’s answer is out-of-box. You can get fancy and create a web based Excel like page that integrates with Agile. Yes, it would be a custom development effort

You can also do this without a PX. SaveAs is a privilege. As you know, privileges have criteria. You can give your user a SaveAs privilege with criteria of when they can do SaveAs.

I have seen the use of document hierarchies in PLM  for such needs. Think of a BOM only made up of documents. For instance,  market requirements can start with global requirements at the top, regional under them and country under those. The same concept for a product hierarchy: base product info at the top with variants under them–the reverse of a product BOM.

Here is a SQL procedure to delete an ATO.

—————————————————————————————
— Procedure to delete an ATO
—————————————————————————————
create or replace procedure plmdoc_deleteATO(p_ato in varchar2) is
v_id outbound.id%type;

begin
select id into v_id from outbound where outbound_number = p_ato;

delete page_two where id = v_id and class = 11761;
delete page_three where id = v_id and class = 11761;
delete outbound where id = v_id;

delete outbound_lock where id = v_id;
delete outbound_objects where outbound_id = v_id;
delete outbound_wheresent where outbound_id = v_id;

delete workflow_process where change_id = v_id;
delete change_history where change_id = v_id;
end;
/

After it is installed execute like this,

PLSQL> call plmdoc_deleteATO(‘ATO000021’);

Dashboard DX is like a PX. It is Java code that implements either ICustomTable or ICustomChart. It looks like you might be trying to call a URL from your Dashboard. Have you followed these instructions from the documentation?

4.3.5 Defining Custom (URL) Extensions

A Dashboard PX of the type URL is configured to initiate from Dashboard Management. When defining Custom extensions, simply select Custom as the table type. See “To Add a URL to a Tab:” below. No other mapping is required for Dashboard PX’s of type URL.

To Add a URL to a Tab:

1. Define a new tab, for example, Dashboard Extensions as shown above.
2. In the new tab (Dashboard Extensions), click the Tables icon. The Dashboard Management – Dashboard Extensions page appears.
3. In this page, click the New Dashboard Table icon to open the Create Dashboard Table dialog and define the new table.
4. Select Custom from View List Type drop-down list. The Create Dashboard Table dialog displaying fields listed in the following appears.
5. Complete the Create Dashboard Table dialog fields and then click OK.

Starting with 9.3.5 (I believe) and an SSL environment, you will need to add these lines to a stand-alone program before the connect factory is called.

System.setProperty(“java.protocol.handler.pkgs”,”URL”);

System.setProperty(“ssl.SocketFactory.provider”,”url”);

System.setProperty(“UseSunHttpHandler”, “true”);

If the user does not have admin privileges the report can still be shown and executed but the user will get a message that they do not have privileges. So, no, that user will not be able to see report content.

I believe an approval has to be by an individual. Not a group.