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

how to change relationship form value

Mavis — Tue, 15 Dec 2020 07:13:52 GMT

hi,All

I set "Open Related Form" on [relationshiptype] so that I can edit the relationship with a popup window when I click "Add Relationship".

But I want to bring out the default values in the popup window, I tried the following actions

//my code

//This is the code I tried to write in JavaScript

if ("" === this.getProperty("requ_name",""))
{
var UserId = this.getInnovator().getUserID();
if (UserId)
{
  //User
  UserId = UserId.substr(0,32);
  var User = this.getInnovator().getItemById("User", UserId);
  if (User.getItemCount()==1)
  {
this.setProperty("requ_name", User.getAttribute("id"));
    this.setPropertyAttribute("requ_name", "keyed_name", User.getProperty("keyed_name", ""));

     // The first way ,but it responds with this message { "undefined" : "document.getElementById(...) is null" }
     document.getElementById("requ_name").value = User.getProperty("keyed_name", "") ;
    handleItemChange("requ_name", document.getElementById("requ_name").value);

     // Second way, but it responds with this message { "undefined" : "handleItemChange is not defined" }
     handleItemChange("requ_name", User.getProperty("keyed_name", ""));
    //document.thisItem.setProperty("requ_name", User.getProperty("keyed_name", ""));

     // The third way, but it responds with this message { "undefined" : "document.getElementsByName(...)[1] is undefined" }
     var vid=document.getElementsByName("requ_name")[1].id;
    document.getElementById（vid）.value = User.getProperty（“ keyed_name”，“”）; document.thisItem.setProperty（“ requ_name”，User.getProperty（“ keyed_name”，“”）））;

}

Please advise me.

Thank you.

How to refresh or reload the relationship tab

Mavis — Wed, 15 Sep 2021 05:30:55 GMT

Hi, All.
I have a Itemtype (source) named DocApply.
DocApply has a relationship called DocApply_deplist which connects DocApply to DocApply_dep (related).
I added an onchange event to DocApply's property (no) to bring the related data to DocApply_dep when (no) is changed.
The problem I encounter now is as follows

DocApply_dep has a field with the dep_name data type of Item
When I successfully write the data into DocApply_dep, but the dep_name of the relationship tab on the screen is blank, I want her label to be displayed, but I don't know how to do it, can anyone suggest me?

//Here is the javascript code I wrote
//It is executed in (docapply.no) onchange event

var tabbar = parent.relationships.relTabbar;
tabID = tabbar.GetTabId("部門會簽");
var currTabID = parent.relationships.currTabID;
var FirstTabID = tabbar.GetTabId("Signoffs");

var tmpItem;
var DocApply_depRelId = top.aras.getItemFromServerByName("RelationshipType","DocApply_deplist","id").node.getAttribute('id');

var dep = "gm,ap,ep,sw,rd,hpla,po,ee,pa,cm,ed,lm,tt,pt,ad_mm,qc,ms_1,it,ad,hr,fa,fc"

if (srcElement.value !== "")
{
var qcondition = "<itemtype>Arima_ECR_ECN</itemtype><id>"+ECNid+"</id><dep>"+dep+"</dep>";
var Depinfo = top.aras.applyMethod("Find_Old_CountersignDep", qcondition);
Depinfo = Depinfo.replace("<Result>","");
Depinfo = Depinfo.replace("</Result>","");
//return-> id:keyed_name,id:keyed_name,...

var Dep_data = Depinfo.split(",");
for (var i = 0;i<Dep_data.length ; i++)
{
var Dep_info = Dep_data[i].split(":");

tmpItem = top.aras.newItem("DocApply_dep");
  top.aras.itemsCache.addItem(tmpItem);
  top.aras.setItemProperty(tmpItem,"dep_name",Dep_info[0]); // id

  var newRelship = top.aras.newRelationship(DocApply_depRelId,parent.item,false,null,tmpItem,"DocApply_dep",false,true,"DocApply_deplist");
}

}

if (currTabID !== FirstTabID)
{
top.document.frames[2].iframesCollection[tabID].contentWindow.location.reload();
}

Is it possible to use the change event trigger of an item to get the name of the field?

Mavis — Tue, 12 Jan 2021 02:00:32 GMT

hi All,

According to this image,

my method name is " change_field ".

The field names of text boxes framed by dashed lines on the screen are "A", "B", "C", and "D".
The text boxes that are framed with dashed lines have a text box below them that is not framed with dashed lines.
The field names are "A1", "B1", "C1", and "D1" respectively.

I want to get the field name of the current trigger method in the method "change_field", and change the value of other text boxes according to the field name.

Example: The user changes the text box with the field name "A" and triggers the method "change_field".
I need to get the field name of the current text box called "A" in the method "change_field" and read the field name of the current text box called "A" to change the value of the field name of the text box called "A1".

But I don't know how to write the syntax of 「get the field name of the current text box as "A"」

If somebody knows and can help I would really appreciate that.

Thank you.

Is there a way to import Excel into PLM using Action?

Mavis — Tue, 06 Jul 2021 09:34:14 GMT

I want to make an Action to read the local EXCEL file.

Anyone give me a hint to solve it?

Thanks!

Discussion Starter I

Wed, 23 Jun 2021 04:13:54 GMT

Start a discussion in a forum that receives 5 replies.

VB,how to Update the parent property in the onafterupdate event

Mavis — Mon, 21 Jun 2021 08:06:40 GMT

I have an item type and a relationship
I want to calculate the sum of one of the columns of the relationship when the user presses the save button
and update it to the parent item.

If I put the method in the onafterupdate of the parent item, it will do an infinite loop
If I put the method in the onafterupdate of the relationship, when I update the value of more than one relationship, it will prompt me that 「Aras.Server.Core.ItemIsNotLockedException」...

'this is my parent onafterupdate method code

Dim inn As Innovator = Me.getInnovator()
Dim score_1 as Integer = Me.getProperty("score_1") ' parentItem.自評分數

Me.fetchRelationships("Performance_SelfScore")
Dim rs as Item = Me.getRelationships("Performance_SelfScore") 'get relationship
Dim rsCnt as Integer = rs.getItemCount()

If rsCnt < 1 Then

Else
Dim i,self_score,sum_self_score as Integer
sum_self_score=0

For i=0 to rs.getItemCount() -1
self_score = rs.getItemByIndex(i).getProperty("self_score")
sum_self_score = sum_self_score + self_score

Next
Dim score1 as String = Me.getProperty("score_1")
Dim successor_job_cname as String = Me.getProperty("successor_job_cname")

Me.setProperty("score_1",sum_self_score)

'
'↓↓The following code is what I use to update the parent property
'The first way

'Dim Self_Eval As Item = Me.newItem("Performance_Self_Evaluation","edit")
' Self_Eval.setAttribute("where","id ='" + Me.getID() + "'")
'    Self_Eval.setProperty("score_1",sum_self_score)
'    Self_Eval.setProperty("successor_job_cname","approve_mg")'day_auth.getProperty("approve_mg"))
'    Self_Eval = Self_Eval.apply()
'If Self_Eval.isError() Then
' Return inn.newError ("Performance_VB_test:Error Update Performance_Self_Evaluation " & Self_Eval.getErrorDetail())
'End If

'
'Second method
'Dim Self_Eval As Item = inn.getItemById("Performance_Self_Evaluation", Me.getID())
'   Self_Eval.setAction("edit")
'     Self_Eval=Self_Eval.apply()
'     Self_Eval.setProperty("score_1",sum_self_score)
'

'The third way
'Me.setAction("edit")
'Me.setProperty("score_1",sum_self_score)
'Dim resultItem As Item = Me.apply()
'Me.setAction("")
'↑↑

score1 = Me.getProperty("score_1")
successor_job_cname = Me.getProperty("successor_job_cname")

End If

Can anyone give me any idea?

How to get the source item properties in the related item onafteradd event?

Mavis — Thu, 25 Feb 2021 07:00:40 GMT

hi All,

I have an type(source item) called A.

A has relationship called B, which relates A to C(related item)

I wrote a VB server event and in related item(C) onafteradd to execute
I want to get the properties of the source item before the relationship item is saved (onafteradd) and make a judgment with the properties of the relationship item.

my question is:

I'm trying to find the source_id of the relationship(B) to get the source item(A).
But I can't find the source id of the relationship because it's a new relationship that hasn't been created yet.

Dim B_relid As string = Me.getProperty("id")
Dim B as Item = Me.newItem("B","get")
B.setAttribute("select","source_id")
B.setProperty("related_id",B_relid)
B = B.apply()

Dim A_id as String = B.getproperty("source_id")
Dim A As Item = myInnovator.GetItemById("A", A_id) ' error because A_id is empty

Dim A1 As string =A.getProperty("a1")

Can anyone tell me the code how to get the source item property using VB?

Thank you!

Get beforeupdate Relationships value from parent item

Zachary — Thu, 19 Sep 2019 05:46:46 GMT

there is a item name -Part

and it has relation -Part_relation

there are a date field and name field in Part_relation

when user update , I want to check the field'value Cannot be earlier than Today

When encountering an error, I will return inn.newError(name + date+" error")

it is my question

When encountering multiple errors, how can I get Part_relation 's information (on the view) show on Error message

in Part's beforeUpdate event?

I think "this.getRelationships();" works, but I failed after testing.

----------------------------------------------------

string log ="";
Innovator inn = this.getInnovator();

Item rootitem = inn.getItemById(this.getType(), this.getID());

//on the view's all relationship
Item thisrela = this.getRelationships();

string today = DateTime.Now.ToString("yyyy/MM/dd");
DateTime nowdate = Convert.ToDateTime(today);

for(int a=0 ; a<thisrela.getItemCount(); a++){
Item tR = thisrela.getItemByIndex(a);----> it can't run
//on view's date
　　string updateday = Convert.ToDateTime(tR.getProperty("ts_complete_date")).ToString("yyyy/MM/dd");

　　DateTime update = Convert.ToDateTime(updateday);
　　if(DateTime.Compare(nowdate,update)>0){
　　　log += "tR.getProperty("name")+update+" Error.";
　　}
}

if(log!=""){
return inn.newError(log);
}

How to get the relationship count before the parent itemtype save

tenny — Fri, 05 Feb 2021 06:38:55 GMT

Hello everyone,

I need to check that user has added at least one relationship before save base on some item types fields， anyone know which event I should use and how to do that? Example is just like the picture below.

How to get the value of relationship item type using the return value of fetchRelationships

Mavis — Tue, 09 Feb 2021 05:56:56 GMT

hi,All

'my code

'This is the code I tried to write in VB

Me.fetchRelationships("File")
Dim file as Item = Me.getRelationships("File")

Dim t_file_id as string
If file.getItemCount()>0
Dim fileCnt as Integer=file.getItemCount()

For x=0 To fileCnt-1
t_file_id = file.getItemByIndex(x).getProperty("related_id")
file1= file.getItemsByXPath("Relationships/Item[@id='"+t_file_id+" ']")
file1.getProperty("doc_name") ' return Not a single item
Next

End If

'file

'The value obtained is shown below

How do I get the doc_name value?

If somebody knows and can help I would really appreciate that.

Thank you.

Ask A Question I

Mon, 28 Sep 2020 09:36:11 GMT

Ask a question in a forum.

How to use the result of getAssignedActivities() to get the value of the ID field

Mavis — Mon, 28 Sep 2020 09:36:11 GMT

hi All,

I used the getAssignedActivities() method from outside aras to find 14 pieces of data.
But when I try to get the ID field using getItemByIndex(i).getProperty("ID"), he returns null

//my code

Item activities = inn.getAssignedActivities("Active", "B7E018BB45C40BB6BC48E3CA2612A971");

int actCnt = activities.getItemCount();
if (actCnt > 0)
{
for (int i = 0; i <= actCnt; i++)
{
string actId = activities.getItemByIndex(i).getProperty("ID");
}
}

Thanks.

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

how to change relationship form value

How to refresh or reload the relationship tab

Is it possible to use the change event trigger of an item to get the name of the field?

Is there a way to import Excel into PLM using Action?

Discussion Starter I

VB,how to Update the parent property in the onafterupdate event

How to get the source item properties in the related item onafteradd event?

Get beforeupdate Relationships value from parent item

How to get the relationship count before the parent itemtype save

How to get the value of relationship item type using the return value of fetchRelationships

Ask A Question I

How to use the result of getAssignedActivities() to get the value of the ID field

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