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

External Hyperlink

chenze — Thu, 05 Apr 2018 10:15:35 GMT

Hallo, recently I’ve created an self-defined ItemType with a Null-Relationship. I’ve added a string property “URL Link” to it so that it should link to external URLs. (e.g. “https://www.aras.com/”) But it is a plain text, how can I set it as Hyperlink? Thank you.

Configurable InBasket - Error on Save

greglc — Fri, 18 Jan 2019 03:55:14 GMT

My company is using Aras Innovator 11.11.

Following the Aras Innovator 11.0 - Configurable InBasket.pdf to the letter for adding a new column to existing InBasket PolySource ItemTypes (Workflow and Project), I get an error after adding the property to the Inbasket Task (parent) ItemType and clicking save.

I'm adding property called related_eco, Data Type = Item, Data Source = Express ECO.

The error suggests I have an invalid column name, but I can't discern the cause of the error. Has anyone encountered this, or can anyone point out the probably obvious error I've made? Here's the error text (sorry, it's a long error):

Invalid column name 'related_eco'. Invalid column name 'related_eco'. in SQL: CREATE FUNCTION [secured].[INBASKET_TASK] ( @type VARCHAR(32), @identity_list VARCHAR(MAX), @ip_address VARCHAR(32), @cur_user_id CHAR(32), @perms_having_can_get NVARCHAR(MAX) ) RETURNS TABLE AS RETURN ( SELECT [secured].[PROJECT_TASK].assigned_to AS assigned_to, [secured].[PROJECT_TASK].classification AS classification, [secured].[PROJECT_TASK].config_id AS config_id, [secured].[PROJECT_TASK].container AS container, [secured].[PROJECT_TASK].container_type_id AS container_type_id, [secured].[PROJECT_TASK].created_by_id AS created_by_id, [secured].[PROJECT_TASK].created_on AS created_on, [secured].[PROJECT_TASK].css AS css, [secured].[PROJECT_TASK].current_state AS current_state, [secured].[PROJECT_TASK].due_date AS due_date, [secured].[PROJECT_TASK].generation AS generation, [secured].[PROJECT_TASK].icon AS icon, [secured].[PROJECT_TASK].id AS id, [secured].[PROJECT_TASK].instructions AS instructions, [secured].[PROJECT_TASK].is_current AS is_current, [secured].[PROJECT_TASK].is_released AS is_released, [secured].[PROJECT_TASK].item AS item, [secured].[PROJECT_TASK].item_type_id AS item_type_id, [secured].[PROJECT_TASK].keyed_name AS keyed_name, [secured].[PROJECT_TASK].language_code_filter AS language_code_filter, [secured].[PROJECT_TASK].locked_by_id AS locked_by_id, [secured].[PROJECT_TASK].major_rev AS major_rev, [secured].[PROJECT_TASK].managed_by_id AS managed_by_id, [secured].[PROJECT_TASK].minor_rev AS minor_rev, [secured].[PROJECT_TASK].modified_by_id AS modified_by_id, [secured].[PROJECT_TASK].modified_on AS modified_on, [secured].[PROJECT_TASK].my_assignment AS my_assignment, [secured].[PROJECT_TASK].name AS name, [secured].[PROJECT_TASK].new_version AS new_version, [secured].[PROJECT_TASK].not_lockable AS not_lockable, [secured].[PROJECT_TASK].owned_by_id AS owned_by_id, [secured].[PROJECT_TASK].permission_id AS permission_id, [secured].[PROJECT_TASK].related_eco AS related_eco, [secured].[PROJECT_TASK].start_date AS start_date, [secured].[PROJECT_TASK].state AS state, [secured].[PROJECT_TASK].status AS status, [secured].[PROJECT_TASK].team_id AS team_id, COALESCE ('9DC36DF7F0234A3E8CFFE2A20AB78CCE', NULL) AS ITEMTYPE,[secured].[PROJECT_TASK].id_$_permission AS id_$_permission FROM [secured].[PROJECT_TASK](@type, @identity_list, @ip_address, @cur_user_id, @perms_having_can_get) UNION ALL SELECT [secured].[WORKFLOW_TASK].assigned_to AS assigned_to, [secured].[WORKFLOW_TASK].classification AS classification, [secured].[WORKFLOW_TASK].config_id AS config_id, [secured].[WORKFLOW_TASK].container AS container, [secured].[WORKFLOW_TASK].container_type_id AS container_type_id, [secured].[WORKFLOW_TASK].created_by_id AS created_by_id, [secured].[WORKFLOW_TASK].created_on AS created_on, [secured].[WORKFLOW_TASK].css AS css, [secured].[WORKFLOW_TASK].current_state AS current_state, [secured].[WORKFLOW_TASK].due_date AS due_date, [secured].[WORKFLOW_TASK].generation AS generation, [secured].[WORKFLOW_TASK].icon AS icon, [secured].[WORKFLOW_TASK].id AS id, [secured].[WORKFLOW_TASK].instructions AS instructions, [secured].[WORKFLOW_TASK].is_current AS is_current, [secured].[WORKFLOW_TASK].is_released AS is_released, [secured].[WORKFLOW_TASK].item AS item, [secured].[WORKFLOW_TASK].item_type_id AS item_type_id, [secured].[WORKFLOW_TASK].keyed_name AS keyed_name, [secured].[WORKFLOW_TASK].language_code_filter AS language_code_filter, [secured].[WORKFLOW_TASK].locked_by_id AS locked_by_id, [secured].[WORKFLOW_TASK].major_rev AS major_rev, [secured].[WORKFLOW_TASK].managed_by_id AS managed_by_id, [secured].[WORKFLOW_TASK].minor_rev AS minor_rev, [secured].[WORKFLOW_TASK].modified_by_id AS modified_by_id, [secured].[WORKFLOW_TASK].modified_on AS modified_on, [secured].[WORKFLOW_TASK].my_assignment AS my_assignment, [secured].[WORKFLOW_TASK].name AS name, [secured].[WORKFLOW_TASK].new_version AS new_version, [secured].[WORKFLOW_TASK].not_lockable AS not_lockable, [secured].[WORKFLOW_TASK].owned_by_id AS owned_by_id, [secured].[WORKFLOW_TASK].permission_id AS permission_id, [secured].[WORKFLOW_TASK].related_eco AS related_eco, [secured].[WORKFLOW_TASK].start_date AS start_date, [secured].[WORKFLOW_TASK].state AS state, [secured].[WORKFLOW_TASK].status AS status, [secured].[WORKFLOW_TASK].team_id AS team_id, COALESCE ('321BD822949149C597FD596B1212B85C', NULL) AS ITEMTYPE,[secured].[WORKFLOW_TASK].id_$_permission AS id_$_permission FROM [secured].[WORKFLOW_TASK](@type, @identity_list, @ip_address, @cur_user_id, @perms_having_can_get) )

Simple search not working on dynamically setting search value for Activity2 Itemtype?

Former Member — Wed, 19 Jun 2019 11:30:59 GMT

Hi Team,

I have Item A and have "Activity2" relationship Item. I m setting search value for one of the field in Activity2. On clicking of search it not working.

Following is way I am setting field search value

//Setting filter value in search dialog box
var Filter = {};
Filter["proj_num"] = { filterValue: 1333|1393, isFilterFixed: false };
return Filter;

proj_num is one of the OTB field in form

But if I Manually search with same value(1333|1393) it give result.

I don't know what is going wrong. Any one please can help me out of this?

Thanks in advance

Can't view item from tree grid view

RickP — Thu, 28 Feb 2019 07:56:02 GMT

Hello

I'm new to Aras and I have a problem with a tree grid view that I have added to the generic items that were included in the variant manager sample application. I followed the tutorial "An Introduction to Query Builder and Tree Grid View" to make a tree grid view showing the structure of the generic items and what parts were connected to each generic item as usage cases.

My problem is that i can't open the parts/generic items from the tree grid view, I get the option in the context menu but it's greyed out and can't be selected. How can I enable this option? I'm logged in using the administrator account.

I'm using Aras 11.0 SP12 with an open license, and the 11.0.12.1 release of the variant manager sample application.

/Rick

Deleting Workflow Processes Best Practices

wfe002 — Fri, 08 Mar 2019 18:53:46 GMT

Hello,
We are trying to figure out how to delete workflow processes that were halted at mid stream for internal business reasons. When we tried deleting the workflow we get the message / Error "Workflow cannot be deleted. Its used in workflow related_id "xxxxx".

Question is: How does one delete the Relationships of any related item that is tied to the actual workflow? Looking for some specific examples on how we can accomplish this.

Any help would be appreciated. If possible an AML sample would also go a long way in trying to resolve this issue.

Thanks in advance for your support.

William E.

Connection of 2 different workflows

Florian12 — Fri, 26 Apr 2019 09:01:02 GMT

Dear Community,

I have a question regarding the connection of 2 different workflows. I built a workflow of 'Parts' and another one for 'Documents'. 'Parts' and 'Documents' are two different ItemTypes and are connectd through a relationship 'One Part can have many Documents'.

The Workflow of 'Parts' can be defined as follow:

The Workflow of Documents is represented as follow:

Now, what I was trying to achieve is that once the activity 'Revision' is carried out in the 'Parts' workflow the 'Document' workflow should be opened and tasks sent to my InBasket. This is because, I want my employees to check if my documents related to a part need to be reviewed and revised once the latter has been revised. I know that I could extend the Parts workflow, however, I want to avoid that.

I tried assigning the Document Workflow as a Subflow of the Parts 'Revision' activity and implementing the promotion with the Relationship Parts-Document as the ItemType. I added the Document Lifecycle and Workflow in the Relationship ItemType and in the Document ItemType. However, nothing seemed to work. (PS: the two workflows work fine independently)

How should I proceed?

I would be very thankful for any help.

Best regards,

Florian

How to search for 'Yesterday'?

Meismart — Thu, 02 May 2019 08:15:25 GMT

I want to find all part Items with a created_on date of Today - easy. Now I want to Save this search to the TOC so users can run it daily - not so easy.

I am trying to search for "Yesterday" in a date field, using AML.
this:
<Item type="Part" action="get" page="1" pagesize="200" maxRecords="" returnMode="itemsOnly">
<created_on condition="gt">yesterday</created_on>
<created_on condition="lt">tomorrow</created_on>
<generation condition="ge">1</generation>
</Item>

In my OnBeforeGet, I find the value "Yesterday" and substitute it for yesterday's date.
this:
<Item type="Part" action="get" page="1" pagesize="200" maxRecords="" returnMode="itemsOnly">
<created_on condition="gt">2019-05-02T00:00:00</created_on>
<created_on condition="lt">2019-05-02T23:59:59</created_on>
<generation condition="ge">1</generation>
</Item>

If I return this, then I get the error:
<SOAP-ENV:Envelope>
-<SOAP-ENV:Body>
-<SOAP-ENV:Fault>
<faultcode>SOAP-ENV:Server</faultcode>
<faultstring>String was not recognized as a valid DateTime.</faultstring>
-<detail>
<af:legacy_detail>String was not recognized as a valid DateTime.</af:legacy_detail>
<af:exception message =" String was not recognized as a valid DateTime. " type =" System.FormatException " />
</detail>
</SOAP-ENV:Fault>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

1) Can anyone explain how the system checks if the DateTime value is valid?
2) Is there an elegant, reusable way to perform this functionality?

I have created a new Item, using an OnGet method to return todays parts, but this is a lot of effort for a relatively simple requirement. It is not reusable and it does not address why the above approach does not work.

Many thanks,
Martin.

How to upload a photo?

eduardo.romero — Wed, 01 May 2019 17:48:35 GMT

Hello
I hope you can help me, I need this image to upload, which is the employee identification photo, to be loaded where the ItemType logo is,
How could I make this possible?

Enable Export to Excel

Tejaswini — Mon, 11 Mar 2019 05:47:02 GMT

Hi,

How to enable Export to Excel option in relationship grid of Project Itemtype and relationship name is Project Plan.

Question as to when relationships are created in the Add process

Mark Lawrence — Wed, 01 May 2019 14:02:35 GMT

Probably should throw this over to Aras Support, but I thought I would ask the knowledgeable people here first.

Does anyone know at what stage in the add process of a record when the relationships are create. Here is my scenario. I am adding a record that will be a child for example of a part process . During an onAfterAdd trigger on the item type of the child, I want to go and read the parent record to be able to populate some data from the parent onto the child. So I read the relationship item type using the id of the child to search the related id of the parent. That read fails and tells me there are no records available. However, after the whole saving process is complete, I go into NASH and query that exact data using the ID and related ID in the relationship and it retrieves the data with no issue. Which makes me think that at the time I am trying to read the parent in the trigger, the relationship has not been created.

Anyone have any ideas on this?

How do I write a server-side method in C# to capture server event onBeforeGet to deny a search or read request?

Former Member — Thu, 25 Apr 2019 22:12:20 GMT

I need to do some extra check on user information before grant the user read access to an item. Is this a right approach? If so, what should I return in the deny situation to not break the client application?

User notification from server methods

jukkatlehtinen — Tue, 09 Apr 2019 15:19:51 GMT

Hi,

I'm creating server method and populating a new Part structure (+ doing other thing in an method). And last thing from method I would like to send 'on screen ' summary/notification what happened to the user (like inn.newError("Hi, this is what happened")). But as an 'Info' not an _error_.

Is there a nice way to send information from server methods to users?

//Jukka

How can I add filter before get InBasket?

Former Member — Thu, 14 Mar 2019 06:52:53 GMT

How can I add filter before get InBasket?

Versioning on lifecycle step

Wian le Roux — Wed, 20 Feb 2019 12:07:22 GMT

Hi Guys

I have a scenario where a user would like to keep record of a specific document type, namely pre-meeting and post-meeting to compare.

We have manual versioning enabled on our documents itemtype, but the user would like this to happens automatically when the document is promoted to the next step in the document class lifecycle.

I have created the linear life cycle assigned with the class, with permissions and created the following script,that runs on the post method transition.

// Version
Innovator inn = this.getInnovator();
Item newItem = this.apply("version");

// Finish
return this;

This creates a new version of the document when i promote it to the lifecycle step, but it does not include the word file in the document view. Am i missing something in the script to pull the data from the previous version?

Thanks in advance

Wian

Assigning a participant for a task based on Role

Shekhar — Mon, 11 Mar 2019 07:35:29 GMT

Hello Experts,

Is it possible to assign a task to a participant based on the role in Aras.

For example I have a workflow process in which three participants A,B, and C are assigned as Change Control Board member. When the process goes to review task, all these three members get notification about the Sign off in their in basket. I want to restrict this behaviour and select only specific member for review so that the task is assigned to that particular member only.

This is scenario possible ?. If yes then any help is highly appreciated.

Thanks,

Shekhar

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

External Hyperlink

Configurable InBasket - Error on Save

Simple search not working on dynamically setting search value for Activity2 Itemtype?

Can't view item from tree grid view

Deleting Workflow Processes Best Practices

Connection of 2 different workflows

How to search for 'Yesterday'?

How to upload a photo?

Enable Export to Excel

Question as to when relationships are created in the Add process

How do I write a server-side method in C# to capture server event onBeforeGet to deny a search or read request?

User notification from server methods

How can I add filter before get InBasket?

Versioning on lifecycle step

Assigning a participant for a task based on Role

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