Ron - Monday, May 14, 2007 2:41 PM:
When creating a problem report (PR) and adding the affected item I have noticed that if I select a document the affected item displays the Document number, but if selecting a part it will display the Item ID and not the Part number.
How can I correct it to show the part number?
Ron
SamsAn - Tuesday, May 15, 2007 2:52 AM:
Standard Solution database has Part ItemType with item_number property (its label is Part Number, is_required=1, keyed_name_order=1). Thus every saved Part instance has not empty Part Number and its keyed_name equals to Part Number value. Affected Item field on PR's form displays keyed_name property of the instance. Item ID (i guess like 41E1E1B95E96422FB45D9C835896BBAC) is displayed in your case. Thus the Part's instance keyed_name is 41E1E1B95E96422FB45D9C835896BBAC. It may be when the Part item (selected in popup for Affected Item property) has one of the following parameters:
A. The item is new (it's not saved yet into the database). Keyed_name is generated on server, thus it's empty is this case, thus ID is used to display. (Probably, it's exactly your case).
B. is_required=0 for Part Number property in Part ItemType configuration and the selected part has empty Part Number (keyed_name is ID in this case).
C. keyed_name_order is empty for Part Number property.
Hope it helps,
SamsAn.
Ron - Tuesday, May 15, 2007 8:46 AM:
Thanks for the reply, but I am still confused. Both Document and Part "item_number" and "keyed_name" are configured the same. In both cases the "item_number is a required field and must be unique and indexed. As for not saved into the database, I am not sure what you mean by this, all items were bulk loaded into our test environment using the same method (yes they are at a preliminary state). The Keyed_name_order is blank for both cases.
Still confused..
Ron
SamsAn - Tuesday, May 15, 2007 9:14 AM:
"The Keyed_name_order is blank for both cases" is the reason of item ID in Affected Item field (you have no properties with keyed_name_order filled, thus ID is used as keyed_name for Parts).
To correct it:
1. Edit Part ItemType and set keyed_name_order=1 for item_number property.
2. Select Parts in TOC (the main Innovator Tree) and click Tools/Admin/Rebuild Keyed Names command in the main menu (keyed names will be rebuilt for Part instances).
Now Part Numbers will be displayed for Affected Item values.
Hope it helps,
SamsAn.
Ron - Tuesday, May 15, 2007 10:16 AM:
SamsAn
Thanks for your help, after rebuilding the keyed names it now displays correctly. All is well in the Innovator world again.
Now on to the next task.
Thanks again
Ron
tbwork - Friday, May 27, 2011 11:38 AM:
I have the following issue
- Creating a new PR
- Entering all fields, save, unlock and exit
- Open same PR again
- Then all fields are empty again, except the attachments are still there.
Please help, on how to fix this issue.
Thanks.
Thomas
Brian - Wednesday, June 1, 2011 6:57 AM:
Hi Thomas,
Are you using the standard Aras Innovator Solutions or are you using one of the Demo Databases?
At least one of the Demo databases does not have the fields on the PR form connected to the underlying data.
To correct this go to the PR Form and edit it and enter the "Source" information for each of the fields on the form.
Cheers,
Brian.
tbwork - Friday, June 3, 2011 3:21 PM:
Hello Brian,
I am using the DEMO database and tried to follow your above suggestion.
However, there does not seem to be appropriate source fields available (e.g. environment, description, etc cannot be selected from the list).
Can you tell me, how forms are linked to tables in the database?
Thank you.
Thomas
Brian - Sunday, June 5, 2011 7:58 PM:
Hi Thomas,
In the top section of the Form editor there is a selection box called "Data Source" under the "Field Type" tab.
This controls what Item Type Property the Form field is bound to.
See this image:
http://www.flickr.com/photos/41745749@N06/5801806169/in/photostream/lightbox/
(I can't get this forum to accept media images in-line)
For the PR form on the Demo database most of these Data Source entries are blank.
Just edit them to point to the appropriate property and then save the form.
Cheers,
Brian.
tbwork - Monday, June 6, 2011 8:24 AM:
Thank you Brian.
I understand the process of updating the data source for each item.
However, the drop down menu for the data source does not contain the relevant field. I assume that the form is pointing to the wrong table in the database, and/or the menu is populated incorrectly.
Can you let me know, how I can update/modify the content of the source items available?
Thanks.
Thomas
Brian - Monday, June 6, 2011 8:37 AM:
Hi Thomas,
I remember now (having just looked at a fresh copy of the demo database).
I think you will find the the "correct" table is hooked up but the table doesn't have those fields in place. The form was put together to show what it looked./might look like but wasn't in the "script" for demonstrating the database itself.
Find the Item Type that the form is attached to (is it "PLMe PR" that you are using?) and add the extra fields. Then go to the form and hook them up.
Cheers,
Brian.
tbwork - Monday, June 6, 2011 9:04 AM:
Brian,
thanks, that works great.
I probably should switch to a 'bare' copy of InnovatorSolution to make sure I don't hit unforeseen road blocks as this one.
Thanks again for your prompt response, and for increasing my knowledge of the inner workings of ARAS. Very helpful.
Thomas.
