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

Activation Error Activation Key validation failed. Please contact Aras (licenses@aras.com) if you feel you have recieved this message in error

Alexandrecimp — Mon, 27 Jan 2020 11:07:55 GMT

Hello,

note that if you get this message when you try to activate a feature it means you have reached the maximum activation and you shall ask for more.

Activation Error

Activation Key validation failed. Please contact Aras (licenses@aras.com) if you feel you have recieved this message in error

I have lost half a day because i could have not find any topic.

Kind regards,

Is it possible to upgrade revision in REST for a manual object

Alexandrecimp — Tue, 22 Oct 2019 15:43:15 GMT

Hello community,

we are trying to update the Version of a manual Objet in REST.

Do you have any method to call ? its seems doc instruction doesn't work so far.

Thank you.

Get the last state of an Object with query definition or REST

Alexandrecimp — Wed, 06 Nov 2019 09:56:35 GMT

Hello ARAS community,

once again o would have your advice.

to be clear, this is what we have in the table of an object :

id REF_NUMBER_ MODIFIED_ ON STATE IS_CURRENT MAJOR_REV
2154BB99E5F046 B 2019-11-06 09:43:54.560 Working 1 A
2A7B8BD203A54C C 2019-11-06 09:44:03.450 Working 1 A
5E2A1CD82CD14A A 2019-11-06 09:45:41.210 Saved 1 A
B3CE5360E24449B A 2019-11-06 09:43:48.837 Working 0 A

I need as a result to get the line 1, 2 and 4. this correspond to get all the object at the state Working and only the most recent one.

My problem is if i use as filter (state = 'working') AND (is_current = 1) i only get line 1 and 2. the 3 cannot be segregated.

Is it possible ?

Thank you :)

Trying to creat a link through server side method with AML

Alexandrecimp — Thu, 27 Feb 2020 17:23:49 GMT

Hello,

AML works in Nash.

When an user is created i want to put his identity into another identity.

This method is plugged on after add event of identity item type.

Could you tell me id i missed someting ? Should i put an apply somewhere ?

Innovator _innovator = this.getInnovator();

System.Diagnostics.Debugger.Launch();

//get id of the identity of the user created

var New_identity = this.getID();

Item New_identity_item = this.newItem("Identity","get");
New_identity_item.setProperty("id",New_identity);
New_identity_item = New_identity_item.apply();

var Is_Alias_1 = New_identity_item.getProperty("is_alias");
if ("1".Equals(Is_Alias_1))

{

//3007DCA0B6B949A0A0B5E51AF85A6B52 ***_Checker

string aml = string.Format(
@"
<AML>
<Item type = 'Member' action ='add'>
<source_id>3007DCA0B6B949A0A0B5E51AF85A6B52</source_id>
<related_id>{0}</related_id>
</Item>
</AML>",New_identity);

}

System.Diagnostics.Debugger.Break();

return this;

Thanks you 🙂

How to edit an item in AML with import/export tool

Alexandrecimp — Wed, 19 Feb 2020 10:42:48 GMT

hello,

i post that here as a reminder because i was not able to find information about this :

<AML>

<Item type="ItemType" id="0E4B48B11212429DB971*BFB026ADB97" action="edit"> Add / Delete
<allow_private_permission>1</allow_private_permission>
<auto_search>0</auto_search>
<class_structure><![CDATA[<class id="0E4B48B112124*9DB9714BFB026ADB97"><class id="87D3738F6C794C94*E823642A9E50A38" name="Formal" /><class id="D457200A964B48509468B7E5497C9D43" name="Informal" /><class id="D16D866888014CC3A*F06A50B6DA653E" name="**" /></class>]]></class_structure>
<enforce_discovery>1</enforce_discovery>
<hide_where_used>0</hide_where_used>
<history_template keyed_name="Default" type="History Template">3BC16EF9E52B4F9792AB76*CE0492F29</history_template>
<implementation_type>table</implementation_type>
<instance_data>***</instance_data>
<is_dependent>0</is_dependent>
<is_relationship>0</is_relationship>
<is_versionable>1</is_versionable>
<label xml:lang="en">***</label>
<label_plural xml:lang="en">**t</label_plural>
<manual_versioning>0</manual_versioning>
<revisions keyed_name="Default" type="Revision">7FE395DD8B9F4E10907*6A34B733D75E</revisions>
<show_parameters_tab>1</show_parameters_tab>
<structure_view>tabs on</structure_view>
<unlock_on_logout>0</unlock_on_logout>
<use_src_access>0</use_src_access>
<name>***</name>

<Relationships>

<Item type="ItemType Life Cycle" id="B6ABA8AAD6934C6DBF*0A320136B24FE" action="add"> Delete
<class_path>Informal</class_path>
<related_id keyed_name="name" type="Life Cycle Map">582B759C17CC4*979466C730E7ECCFE5</related_id>
<sort_order>256</sort_order>
<source_id keyed_name="**" type="ItemType" name="**">0E4B48B11212429*B9714BFB026ADB97</source_id>
</Item>

<Item type="ItemType Life Cycle" id="B6ABA8AAD6934C6DBF*0A320136B24FE" action="add"> Delete
<class_path>Informal</class_path>
<related_id keyed_name="name" type="Life Cycle Map">582B759C17CC4797946*C730E7ECCFE5</related_id>
<sort_order>256</sort_order>
<source_id keyed_name="**" type="ItemType" name="GTSI_GTR_SNAPSHOT">0E4B48B11212429DB*714BFB026ADB97</source_id>
</Item>

</Relationships>

</AML>

Workflow and Team configuration

Alexandrecimp — Thu, 28 Nov 2019 16:23:14 GMT

Hello ARAS community,

one time again i would be gracefull to advise me ^^.

1/my workflow is driven by teams.

i have build a vote step like this :

Reject check and check are voting activity with as Managed By, Role and Assignment this team "alex_team".

When i am at this step every user in the team will have the task (in basket task) to check or reject check.

I need that everyone has voted before closing the activity.

Problem if i delete someone from the team he still has the task in his basket...

So the activity is never close and the workflow is stopped. Any idea about the configuration ?

Thank you so much :)

How to build an aml request using a request in a request ?

Alexandrecimp — Thu, 28 Nov 2019 16:16:06 GMT

Hello Aras Community,

i am would like to perform this SQL request but in using AML :

Innovator _innovator = this.getInnovator();

StringBuilder sql = new StringBuilder();

sql.AppendLine("SELECT ID, ***_code, config_id, state, Major_Rev, Generation, is_current FROM innovator.[***_ROOT_***] ***1 WHERE ***1.generation =(SELECT MAX(generation) from innovator.[***_ROOT_***] ***2 where ***2.state = 'Working' AND ***2.config_id = ***1.config_id)order by modified_on");

Item ***_result = _innovator.applySQL(sql.ToString());

return ***_result;

Basically i need to do a request in a request.

Do you think this is possible ?

thank you so much for any help.

Special AML Actions

Christopher Gillis — Thu, 28 Mar 2019 19:00:00 GMT

In addition to the standard actions like Add, Unlock, Update, Delete, etc, Aras also provides a number of useful special actions OOTB that can be called through AML. In this blog post, we'll go over what some of these actions do and how to format the AML to use them. For a full list of actions available through AML we recommend checking out this wiki created by Eric Domke, a member of the open Aras community. If you want to follow along and try out the examples in this blog, check out how to apply AML queries directly against the server.

GetItemRepeatConfig

This action performs a recursive query to return multiple levels of an Item->Relationship->Item structure. The most common way this action is used is to return Part->Part BOM->Part data from a top-level assembly Part. The basic structure of this AML will look like below.

<AML>
<Item type="Part" select="name,item_number,id" action="GetItemRepeatConfig" id="YOUR_PART_ID">

<Relationships>

<Item type="Part BOM" select="related_id,quantity" repeatProp="related_id" repeatTimes="10"/>

</Relationships>

</Item>
</AML>

You'll notice that there are two attributes on the relationship Item node that are unique to this action: repeatProp and repeatTimes. The repeatTimes attribute specifies how many times the recursive query should be performed. A value of '0' in this attribute will cause the recursive query to continue until the last item in the structure is found. The repeatProp attribute specifies what property to perform the recursive query on. Typically, this action will be used for relationships, so the repeatProp will almost always be "related_id".

getItemNextStates

This action can be run on an Item that has a Life Cycle associated with it to quickly return what the next possible states in the life cycle are. This action is especially useful for validation if you have any code that programmatically promotes an item to another life cycle state.

<AML>

<Item type="YOUR_ITEM_TYPE_NAME" action="getItemNextStates" id="YOUR_ITEM_ID" />

</AML>

This AML structure is very simple as it just requires the ID and ItemType of the item you're working on.

PE_GetRelatedParts

This action is used to perform reverse lookup queries such as getting the Assembly Parts that a child part belongs to. This action is included in the Product Engineering (PE) application which comes standard in almost all installations of Aras Innovator; however, this action can be used with any ItemType including those outside of the PE application.

<AML>
<Item type="Part" select="item_number" action="PE_GetRelatedParts" id="YOUR_PART_ID" resolution="Version">

<Relationships>
<Item type="Part BOM">
<source_id>
<Item type="Part"/>
</source_id>
</Item>

</Relationships>

</Item>
</AML>

For this action, the structure of the AML is primarily what drives the query. There is a required unique attribute in this action called resolution that you can pass in a value of "Version" for as in the example above.

Also note that unlike the two other special actions we've mentioned in this blog, PE_GetRelatedParts is just a Method inside of Aras Innovator. You can also check out our previous post to see how you can use your own custom Methods inside of your AML queries.

Using this Action in a Relationship Tab

The Related Parts relationship tab on the Manufacturer Part ItemType is actually a bit of misnomer in that it displays any parent Parts that have a relationship to that Manufacturer Part. This relationship tab uses a special view that's powered by the PE_GetRelatedParts action, and you can use this view for your own relationships as well.

If we login as an administrator and navigate to TOC > Administration > RelationshipTypes, we can open the Manufacturer Part Part relationship. Here, we can see that a special view has been set in the Relationship View tab. This will override the default relationship grid with whatever alternate view you specify here.

We can see that this view is pointing to a file called ReverseItemsGrid.html. If you look inside this file, you'll see it's a specially formatted grid that's populated by a query using PE_GetRelatedParts. The Parameters field represents the arguments that will be used to run the query.

'ITName='+itemTypeName+'&itemID='+itemID+'&reverseITName=Part&reverseRelationshipName=Part AML'

There's four parameters here that are specified which we can map into the AML like below.

<AML>
<Item type="ITName" select="item_number" action="PE_GetRelatedParts" id="itemID" resolution="Version">

<Relationships>
<Item type="reverseRelationshipName">
<source_id>
<Item type="reverseITName"/>
</source_id>
</Item>

</Relationships>

</Item>
</AML>

Two of these parameters are set in such a way that they will be automatically populated based on the Item that the user is currently viewing: 'ITName='+itemTypeName+'&itemID='+itemID+'. This means that for most use cases, the only parameters you'll need to change will be reverseITName and reverseRelationshipName. For example, we could add a new relationship to Part that allows Users to see what Assemblies the Part they're viewing is in. If we did this, our Parameters for this RelationshipView would be as follows.

'ITName='+itemTypeName+'&itemID='+itemID+'&reverseITName=Part&reverseRelationshipName=Part BOM'

Conclusion

All the actions in this blog post are used in the OOTB functionality of Aras Innovator and have been exposed via AML for your convenience. If you have any experience using these actions before, please share your story in the comments!

REST API transfert access property without generation

Alexandrecimp — Mon, 14 Oct 2019 17:12:48 GMT

Hello ARAS community 🙂

We would like to change using REST the attribute Locked_by_id of an object. (typically give right to someone else to unlock/lock it.

Do you know if it is possible ?

we try this following the Doc but so far it doesn't work :

PUT host/.../$ref Prefer: return=minimal { "@odata.id": "">host/.../User(‘C542FC153AE647A59CD6F6967295EF6B’)" }

The idea is to enable someone to work on an item unlocked by someone else who is absent and so don't stay bloqued.

Thank you :)

Discussion Starter I

Wed, 16 Oct 2019 11:28:23 GMT

Start a discussion in a forum that receives 5 replies.

Get query builder answer via REST API

Alexandrecimp — Thu, 26 Sep 2019 14:45:32 GMT

Hello ARAS community,

could you tell me if its possible to get aml result of a query via REST API ? (POSTMAN).

I can easily find my query via postman but i cannot execute it.

I tried to creat a method with inside a call to my query and then call the method via POSTMAN but so far it is not working :

Innovator innovator = this.getInnovator(); / this.newIOMInnovator(); //i think its a Csharp method.
var qry_id = "3880DB6828CC43F7AFE580FD7AB267B4"; // QUERY ID

// get query definition with relationships
var queryDef = inn.newItem("qry_QueryDefinition","get");
queryDef.setID(qry_id);
queryDef.setAttribute("levels","2");
queryDef = queryDef.apply();

// create offset/fetch settings string
var offset = "1";
var ftch = "1";
var offset_fetch = "<configuration><option><offset>" + offset +
"</offset><fetch>" + ftch +
"</fetch></option></configuration>";

thank you 🙂

Ask A Question I

Thu, 26 Sep 2019 05:38:50 GMT

Ask a question in a forum.

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

Activation Error Activation Key validation failed. Please contact Aras (licenses@aras.com) if you feel you have recieved this message in error

Is it possible to upgrade revision in REST for a manual object

Get the last state of an Object with query definition or REST

Trying to creat a link through server side method with AML

How to edit an item in AML with import/export tool

Workflow and Team configuration

How to build an aml request using a request in a request ?

Special AML Actions

GetItemRepeatConfig

getItemNextStates

PE_GetRelatedParts

Using this Action in a Relationship Tab

Conclusion

REST API transfert access property without generation

Discussion Starter I

Get query builder answer via REST API

Ask A Question I

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