Nathan さんのグループアクティビティ

Poly Items

ddidonato — Thu, 14 May 2020 14:36:15 GMT

I'm using a Poly Item for ItemType A and ItemType B. Both A and B have the same Foreign Property that I would like to use in my Poly Item. I'm getting the error " The property must be common to all sources or the property has inappropriate data type." Does Poly Items accept Foreign Properties? Is there a work around?

Mouse Over Help Problem

Nathan — Thu, 14 May 2020 18:56:00 GMT

Good day all. I was looking at the Mouse Over Help project. I copied the script into a method, but when I run it there is an event handler error "Unable to set property 'title' of undefined or null reference. I'm not sure how to correct this. Any help would be appreciated. Thank you.

How to refresh a form after a applySQL

jeromecha — Tue, 26 May 2020 14:28:45 GMT

Hello,

I want to handling the minor_revision with a plus '+' beside the field minor_rev.

I used the code of the add-on Adding-Minor-Revision-Handling

The end of the code is :

........

String itemTypeTable = thisItemType.Replace(" ","_");
String SQL = "UPDATE [" + itemTypeTable + "] SET ";
SQL += "[" + itemTypeTable + "].minor_rev='" + newMinorRev + "'";
SQL += " WHERE [" + itemTypeTable + "].id='" + newVerItem.getID() + "'";

Item res = inn.applySQL(SQL);

return this;

The value of the minor rev is update in the database but not on the screen. I need to save the Item (document) to have the new value of the minor_rev field in the screen

How can I update the form (the screen) to have the right value of the field after a inn.applySQL ?

ItemType Relationship Required

Nathan — Mon, 27 Apr 2020 16:40:26 GMT

Good day all. Is there a way to make a relationship required? When submitting a request for a new document we would like the Sites relationship to be a requirement for submitting. I'm still new, so I am not sure how to make this happen. Thanks for the help.

Export Relationships to Import to Another ItemType

Nathan — Thu, 13 Aug 2020 21:16:09 GMT

Good day all. I would like to export all of the Relationship info from one ItemType so I can import it to another ItemType. Currently our database is configured so the Parts List (BOM) is a document and not part of the Part, both are custom ItemTypes. I would like to be able to export the BOM information from the Parts List so I can add it to the Part (trying to bring our database closer to OOTB). Thank you for any recommendations that you can provide.

Report - Method - Stylesheet Question

Nathan — Thu, 24 Sep 2020 21:15:59 GMT

Aras 11 SP10

Good day all. I am trying to create a report that will pull all of the attached items from a document. I have a method that will get the information, but I can't get it to output correctly for the report (can't figure out the correct Stylesheet format). At the moment the method is referencing a single document by the ID number, but I will change this to cover a lot of the documents. I need a single line per related item, with the following fields (I will need to add more fields when this is working).

Document ID

Document Name

Related ID

Related Name

When I run the report all of the related_id information is crammed into the Related ID cell. The Document ID cells will include the related_id number & the id number of the Relationship tab. Any help would be appreciated. Thank you.

Stylesheet

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:aras="http://www.aras-corp.com">
<xsl:output method="html" omit-xml-declaration="yes" standalone="yes" indent="yes" cdata-section-elements="script msxsl:script"></xsl:output>
<xsl:template match="/">
  <html>
   <head></head>
   <style type="text/css" userData="Global">
    .cellSolidRightBottom {
    border-right:1px #000000 solid;
    border-bottom:1px #000000 solid;
    }
    .cellSolidRight {
    border-right:1px #000000 solid;
    }
    .cellHeader {
    background-color:#CCCCCC;
    border-top:1px #000000 solid;
    border-right:1px #000000 solid;
    border-bottom:1px #000000 solid;
    padding:2px;
    text-align:center;
    text-transform:capitalize;
    text-align:center;
    font-family:helvetica;
    font-weight:bold;
    font-size:8pt;
    }
   </style>
   <body topmargin="50" leftmargin="50">
    <table border="0" cellspacing="0" cellpadding="0" width="670">
     <tr>
      <td width="260"></td>
      <td width="130"></td>
      <td width="130"></td>
      <td width="260"></td>
      <td width="130"></td>
      <td width="130"></td>
      <tr valign="top">
       <td align="left" uniqueID="ms_id77" colspan="6">    </td>
      </tr>
     </tr>
     <tr valign="bottom">
      <td colspan="6" style="font-family:helvetica;font-size:15pt;color:#DA1943;padding:2px;" align="left" uniqueID="ms_id79">Parts List BOM Info</td>
     </tr>
     <tr valign="bottom">
      <td colspan="6" style="font-family:helvetica;font-size:10pt;padding:2px;" align="left" uniqueID="ms_id80">
       Generated on:
       <base id="ms_id81"/>
        <script>var d = new Date(); var months = ["January","February","March","April","May","June","July","August","September","October","November","December"]; document.getElementById("ms_id81").innerHTML = d.getDate()+" "+months[d.getMonth()]+" "+d.getFullYear(); </script>
      </td>
     </tr>
     <tr>
      <td class="cellHeader" uniqueID="ms_id100" style="border-left:1px #000000 solid;">Parts List ID</td>
      <td class="cellHeader" uniqueID="ms_id101">Parts List Number</td>
      <td class="cellHeader" uniqueID="ms_id102">Parts List Name</td>
      <td class="cellHeader" uniqueID="ms_id103">Related ID</td>
      <td class="cellHeader" uniqueID="ms_id104">Related Number</td>
      <td class="cellHeader" uniqueID="ms_id105">Related Name</td>
     </tr>
     <xsl:apply-templates mode="ORPH" select="//Item">   </xsl:apply-templates>
    </table>
   </body>
   <script src="../../javascript/PopupMenu.js"></script>
   <script src="../../javascript/PopupMenu.js"></script>
  </html>
</xsl:template>
<xsl:template mode="ORPH" match="//Item">
  <tr>
         <td class="cellSolidRightBottom" uniqueID="ms_id92" align="left" style="border-left:1px #000000 solid;">
            <xsl:value-of select="id"></xsl:value-of>
        </td>
         <td class="cellSolidRightBottom" uniqueID="ms_id92" align="left" style="border-left:1px #000000 solid;">
            <xsl:value-of select="item_number"></xsl:value-of>
        </td>
         <td class="cellSolidRightBottom" uniqueID="ms_id92" align="left" style="border-left:1px #000000 solid; word-wrap:break-word">
            <xsl:value-of select="name"></xsl:value-of>
        </td>
         <td class="cellSolidRightBottom" uniqueID="ms_id92" align="left" style="border-left:1px #000000 solid;">
            <xsl:value-of select="//related_id/Item[@id]"></xsl:value-of>
        </td>
         <td class="cellSolidRightBottom" uniqueID="ms_id92" align="left" style="border-left:1px #000000 solid;">
            <xsl:value-of select="//related_id/Item[@item_number]"></xsl:value-of>
        </td>
         <td class="cellSolidRightBottom" uniqueID="ms_id92" align="left" style="border-left:1px #000000 solid;">
            <xsl:value-of select="//related_id/Item[@id]"></xsl:value-of>
        </td>
  </tr>
</xsl:template>
</xsl:stylesheet>

Query Def & TGV - All Grid Rows Must Have Unique IDs

Nathan — Fri, 28 Aug 2020 19:33:35 GMT

Good day all. I am getting this error when trying to verify my Query Definition and Tree Grid View are set up. I add a field to a custom ItemType for tracking software, Manufacturer. When I se the query & test it, I can get all of the data I want, so I create the TGV. If I have Manufacturer & Software mapped I can see a row for Manufacturer, but not the Software. If I don't have Manufacturer mapped, I receive the error. I'm not sure what I am missing here. I just did the same thing with another set of ItemTypes.

The Manufacturer ItemType has name checked as Unique and identified as the Keyed Name. Software has item_number checked as Unique, with item_number & sw_version identified as Keyed Name. One of the ItemTypes that it works on (the Software side of the query) doesn't have anything checked as Unique.

Thanks for any help that you can provide.

Aras to JIRA Help

Nathan — Thu, 03 Sep 2020 16:51:06 GMT

Good day all. I want to connect Aras to JIRA. I found this article How to integrate JIRA into Aras Innovator with information on how to accomplish this. I was wondering if anyone has accomplished this? I have some questions about the ARAS_JIRA_Settings method.

Innovator inn = this.getInnovator();

Item JIRA_settings = inn.newItem("JIRA_settings","");

JIRA_settings.setProperty("JIRA_projectkey", "-proj_key-");

JIRA_settings.setProperty("JIRA_token", "-paste-token-here-");

JIRA_settings.setProperty("JIRA_user", "your@email.com");

JIRA_settings.setProperty("JIRA_baseURL", "https://[your-jira-instance]/rest/api/2");

return JIRA_settings;

I found info about the project key. It is assigned when making the JIRA project.

What token is needed for this? Where does this come from?

The way this is written, it makes me think that it will be a single e-mail address used for connections Is this correct?

Thank you for any help you can provide.

Is this possible if get an ItemType inside another query within AML?

Jacky Phan — Tue, 28 Jul 2020 09:16:58 GMT

I have two ItemTypes Person and Address. There is a property Person.address_id that stores the config_id of an address, for a particular purpose it is just a string type, not refer ItemType. I use below query to select a person (*):

<Item action='get' type='PERSON' select ='address_id'>
<id>'abcdxyz'</id>
</Item>

I want to add some AML code to get Address Item with the id provided in above statement, something likes:

<Item action='get' type='ADDRESS'>
<id>The (*) query that returns an address id</id>
</Item>

I know that we can achieve the goal by writing a server method, but I just curious is there any way to get that within AML query?

Many thanks,

Report Date Format

Nathan — Mon, 17 Aug 2020 20:57:26 GMT

Good day all. I am trying to set up a custom report that will return the item_number, name, & revision_date for documents. The information is eing output, but the revision_date includes the time. How do I set it so it will only include the date? Thanks for the help.

Missing Tabs of Form

Nathan — Fri, 14 Aug 2020 16:48:19 GMT

Good day all. I just created a new ItemType (Software). I built it to resemble the Part ItemType. Everything seems to be fine, except none of the Relationship tabs are showing when the form populates. I've compared the SW form to the Part form & can't see anything that I missed. I am not seeing anything in the ItemType either. I've tried searching for an answer, but the only thing I seem to find is that there is a Hide ab button somewhere (old posts). Thank you for the help.

Cover Page & User Input

Nathan — Mon, 01 Jun 2020 19:49:44 GMT

Good day all. I could use some advice on creating a cover page for our BOM report. If you have read some of my previous posts, you may know that our database is a bit messed up. I can't change our report. I have created another report and formatted it the way our team has asked for. I can pull all of the information in ARAS into the report. The problem I have is the information that is not in ARAS (or not part of the Parts List). This is what I am trying to accomplish.

1. When the report is ran, a pop-up window will appear to ask for the information that is not part of the Parts List.

A. The number of pages in the BOM (user can just add the number, last page of the report)

B. Who the Drafter is (without associating a form directly to an ItemType, I don't know how to have the user pick from the User ItemType)

C. A Notes section.

I tried following 8.1 User Input for Reporting Services-based Reports from the XSLT Report Tool Users Guide (dated 4 Jan 2018). When I run the report a pop-up window appears and I can type in the information I want, but not select the User. When I click on Submit the window disappears & nothing else happens. I'm not sure what I am missing with this. Thanks for any help that can be provided.

ARAS v11 SP10

LifeCycle Get History Comment -> Can we retrieve the user input on runtime?

AngelaIp — Wed, 27 May 2020 17:40:25 GMT

Hi Community,

I have a short question regarding the 'Prompt History Comment' feature that we can use in LIfeCycles.

When we choose "Get Comment = 1" for a LifeCycle Transition, the end user will be asked with a dialog to add some notes why the lifecycle was changed. This is for e.g. useful, when a LifeCycle was Cancelled and user can explain why they cancelled it. The comment than appears in the History of the item.

When my LifeCycle is Cancelled, affected users will get informed by email. It would be helpful if the history comment would be included in the mails. Is it possible to pass the user input to an Email Message? Of course I could make a query for the new history entry, but I want to avoid query on the History, cause it´s quite performance consuming.

Hope anyone has an idea! Thanks for any help!

Angela

Ask A Question II

Mon, 01 Jun 2020 19:49:44 GMT

Ask 10 questions in a forum.

Report to Find Items w/ Null Relationship

Nathan — Tue, 12 May 2020 17:10:34 GMT

Good day all. I am having a hard time trying to create a report to find Documents without files attached. This is the current config.

Aras v11 SP10

s_Document - Poly Source for the following ItemTypes.

s_Delivered Document

s_Drawing

s_Parts List

s_Manual

s_Specification

s_RefLibrary

All of there ItemTypes have RelationshipTypes with File. How do I create a report to return all of the Documents that do not have a file attached? I tried to use a variation of the Query for an item and return its configuration example from the Programmers guide. I changed all of the information from Part & BOM to s_Drawing and File. When I Run Server Method, it produces an error of Not a single item. Thank you for the help with this.

Nathan さんの グループ アクティビティ