Steve Jones's Profile
Agile Angel
2137
Points

Questions
0

Answers
151

  • Agile Angel Asked on March 31, 2020 in Agile PLM (v9).

    Patrick indirectly answered your question, no, there isn’t a flag.

    Another way is a create item PX. When someone manually creates an item the PX is triggered and writes in history that it is a manual create–or update Patrick’s field. Import does not trigger that PX .

    • 114 views
    • 2 answers
    • 0 votes
  • Agile Angel Asked on March 20, 2020 in Agile PLM (v9).

    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.

    This answer accepted by Alan. on March 23, 2020 Earned 15 points.

    • 146 views
    • 1 answers
    • 0 votes
  • Agile Angel Asked on March 14, 2020 in Agile PLM (v9).

    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).

    • 146 views
    • 1 answers
    • 0 votes
  • Agile Angel Asked on March 12, 2020 in Agile PLM (v9).

    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

    • 117 views
    • 2 answers
    • 0 votes
  • 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.

    • 151 views
    • 3 answers
    • 0 votes
  • Agile Angel Asked on February 27, 2020 in Product Governance and Compliance.

    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.

    • 128 views
    • 3 answers
    • 0 votes
  • Agile Angel Asked on January 31, 2020 in Agile PLM (v9).

    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’);

    • 245 views
    • 2 answers
    • 0 votes
  • Agile Angel Asked on January 31, 2020 in Product Collaboration.

    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.

    Note:

    URL Process Extensions are defined in the Process Extensions Library to initiate from Dashboard Management.

    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.
    Dashboard Table Description Possible Settings
    Name Type a name for the URL String
    Description Type a description String
    View List Type Lists types of table. Select Custom Chart, Table, Custom, Advance Search
    Dashboard Extension Lists all process extensions created for Custom type list. Employee Portal, Yahoo, Google, Process Extension_URLs
    Visible To enable in Web Client Yes/No

     

    • 389 views
    • 1 answers
    • 0 votes
  • Agile Angel Asked on January 29, 2020 in Agile PLM (v9).

    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”);

    • 1133 views
    • 7 answers
    • 0 votes
  • Agile Angel Asked on January 20, 2020 in Product Collaboration.

    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.

    • 151 views
    • 1 answers
    • 0 votes