Work Item - Onclick - Inbasket
Hi all... I have small doubt regarding work item or Workflow Task (At Inbasket). Using WF ,Lifecycle and ItemType.................. One Document is submitted for a review. Now, the document state is "Submitted" Until the Workflow task clicked on Inbasket by assignee it remains "Submitted". If assignee opens the WF Activity completion sheet, the document state is changed into "In Review". After that he may "reject" or "approve". Is it possible?
Hyperlink to My InBasket
I would like to make a hyperlink to My InBasket, something like this: <a href="'ArasServerUrl/.../default.aspx InBasket</a> What is the URL for My InBasket? Is there any documentation I can read on how to create hyperlinks to different locations inside Aras? I want the URL to work even if the user does not have My InBasket as starting page.
Configurable InBasket - Error on Save
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) )
Promotions in Life cycles through workflow maps
Dear community, I am having problems with the promotions of my item type "Documents". Document is an item type which aims at regrouping various documents of our company. A Lifecycle has been created to describe the different states of these documents: As you can see on the picture above, a workflow has been assigned to this lifecycle. Under the "promotions" tab of the workflow I added the transition states relative to the lifecycle: However, once I go to "my InBasket" and complete the task as "Reviewed", the Lifecycle state remains in the "In work" state. How can I manage to get the "Review" state once I reviewed the task? Thanks in advance for your help! FlorianAdd Inbasket Column
One of our Aras environments displays an inbasket workflow task with an additional column that shows the name of the item: What is best way to duplicate this effect to another environment - I find several suggestions in the forums such as modification of client JS, configurable inbasket, etc.. we have v11 sp5.
ECN columns into My InBasket
Hi, I have added ECN's Title and Priority coilumns in all Poly Source item types under MyInBasket item type. Also have added the column into SQL query type. While trying to create same properties in InBasket Task, getting following message: <SOAP-ENV:Envelope xmlns:SOAP-ENV="">schemas.xmlsoap.org/.../"><SOAP-ENV:Body><SOAP-ENV:Fault xmlns:af="">www.aras.com/.../faultcode><faultstring><![CDATA[Invalid column name 'priority'. Invalid column name 'title'. Invalid column name 'priority'. in SQL: CREATE VIEW [INBASKET_TASK] AS SELECT COALESCE('321BD822949149C597FD596B1212B85C', NULL) as ITEMTYPE, [WORKFLOW_TASK].assigned_to as assigned_to, [WORKFLOW_TASK].classification as classification, [WORKFLOW_TASK].config_id as config_id, [WORKFLOW_TASK].container as container, [WORKFLOW_TASK].container_type_id as container_type_id, [WORKFLOW_TASK].created_by_id as created_by_id, [WORKFLOW_TASK].created_on as created_on, [WORKFLOW_TASK].css as css, [WORKFLOW_TASK].current_state as current_state, [WORKFLOW_TASK].due_date as due_date, [WORKFLOW_TASK].generation as generation, [WORKFLOW_TASK].icon as icon, [WORKFLOW_TASK].id as id, [WORKFLOW_TASK].instructions as instructions, [WORKFLOW_TASK].is_current as is_current, [WORKFLOW_TASK].is_released as is_released, [WORKFLOW_TASK].item as item, [WORKFLOW_TASK].item_type_id as item_type_id, [WORKFLOW_TASK].keyed_name as keyed_name, [WORKFLOW_TASK].language_code_filter as language_code_filter, [WORKFLOW_TASK].locked_by_id as locked_by_id, [WORKFLOW_TASK].major_rev as major_rev, [WORKFLOW_TASK].managed_by_id as managed_by_id, [WORKFLOW_TASK].minor_rev as minor_rev, [WORKFLOW_TASK].modified_by_id as modified_by_id, [WORKFLOW_TASK].modified_on as modified_on, [WORKFLOW_TASK].my_assignment as my_assignment, [WORKFLOW_TASK].name as name, [WORKFLOW_TASK].new_version as new_version, [WORKFLOW_TASK].not_lockable as not_lockable, [WORKFLOW_TASK].owned_by_id as owned_by_id, [WORKFLOW_TASK].permission_id as permission_id, [WORKFLOW_TASK].priority as priority, [WORKFLOW_TASK].start_date as start_date, [WORKFLOW_TASK].state as state, [WORKFLOW_TASK].status as status, [WORKFLOW_TASK].team_id as team_id, [WORKFLOW_TASK].title as title FROM [WORKFLOW_TASK] UNION ALL SELECT COALESCE('9DC36DF7F0234A3E8CFFE2A20AB78CCE', NULL) as ITEMTYPE, [PROJECT_TASK].assigned_to as assigned_to, [PROJECT_TASK].classification as classification, [PROJECT_TASK].config_id as config_id, [PROJECT_TASK].container as container, [PROJECT_TASK].container_type_id as container_type_id, [PROJECT_TASK].created_by_id as created_by_id, [PROJECT_TASK].created_on as created_on, [PROJECT_TASK].css as css, [PROJECT_TASK].current_state as current_state, [PROJECT_TASK].due_date as due_date, [PROJECT_TASK].generation as generation, [PROJECT_TASK].icon as icon, [PROJECT_TASK].id as id, [PROJECT_TASK].instructions as instructions, [PROJECT_TASK].is_current as is_current, [PROJECT_TASK].is_released as is_released, [PROJECT_TASK].item as item, [PROJECT_TASK].item_type_id as item_type_id, [PROJECT_TASK].keyed_name as keyed_name, [PROJECT_TASK].language_code_filter as language_code_filter, [PROJECT_TASK].locked_by_id as locked_by_id, [PROJECT_TASK].major_rev as major_rev, [PROJECT_TASK].managed_by_id as managed_by_id, [PROJECT_TASK].minor_rev as minor_rev, [PROJECT_TASK].modified_by_id as modified_by_id, [PROJECT_TASK].modified_on as modified_on, [PROJECT_TASK].my_assignment as my_assignment, [PROJECT_TASK].name as name, [PROJECT_TASK].new_version as new_version, [PROJECT_TASK].not_lockable as not_lockable, [PROJECT_TASK].owned_by_id as owned_by_id, [PROJECT_TASK].permission_id as permission_id, [PROJECT_TASK].priority as priority, [PROJECT_TASK].start_date as start_date, [PROJECT_TASK].state as state, [PROJECT_TASK].status as status, [PROJECT_TASK].team_id as team_id, [PROJECT_TASK].title as title FROM [PROJECT_TASK]]]></faultstring><detail><af:legacy_detail><![CDATA[Invalid column name 'priority'. Invalid column name 'title'. Invalid column name 'priority'. in SQL: CREATE VIEW [INBASKET_TASK] AS SELECT COALESCE('321BD822949149C597FD596B1212B85C', NULL) as ITEMTYPE, [WORKFLOW_TASK].assigned_to as assigned_to, [WORKFLOW_TASK].classification as classification, [WORKFLOW_TASK].config_id as config_id, [WORKFLOW_TASK].container as container, [WORKFLOW_TASK].container_type_id as container_type_id, [WORKFLOW_TASK].created_by_id as created_by_id, [WORKFLOW_TASK].created_on as created_on, [WORKFLOW_TASK].css as css, [WORKFLOW_TASK].current_state as current_state, [WORKFLOW_TASK].due_date as due_date, [WORKFLOW_TASK].generation as generation, [WORKFLOW_TASK].icon as icon, [WORKFLOW_TASK].id as id, [WORKFLOW_TASK].instructions as instructions, [WORKFLOW_TASK].is_current as is_current, [WORKFLOW_TASK].is_released as is_released, [WORKFLOW_TASK].item as item, [WORKFLOW_TASK].item_type_id as item_type_id, [WORKFLOW_TASK].keyed_name as keyed_name, [WORKFLOW_TASK].language_code_filter as language_code_filter, [WORKFLOW_TASK].locked_by_id as locked_by_id, [WORKFLOW_TASK].major_rev as major_rev, [WORKFLOW_TASK].managed_by_id as managed_by_id, [WORKFLOW_TASK].minor_rev as minor_rev, [WORKFLOW_TASK].modified_by_id as modified_by_id, [WORKFLOW_TASK].modified_on as modified_on, [WORKFLOW_TASK].my_assignment as my_assignment, [WORKFLOW_TASK].name as name, [WORKFLOW_TASK].new_version as new_version, [WORKFLOW_TASK].not_lockable as not_lockable, [WORKFLOW_TASK].owned_by_id as owned_by_id, [WORKFLOW_TASK].permission_id as permission_id, [WORKFLOW_TASK].priority as priority, [WORKFLOW_TASK].start_date as start_date, [WORKFLOW_TASK].state as state, [WORKFLOW_TASK].status as status, [WORKFLOW_TASK].team_id as team_id, [WORKFLOW_TASK].title as title FROM [WORKFLOW_TASK] UNION ALL SELECT COALESCE('9DC36DF7F0234A3E8CFFE2A20AB78CCE', NULL) as ITEMTYPE, [PROJECT_TASK].assigned_to as assigned_to, [PROJECT_TASK].classification as classification, [PROJECT_TASK].config_id as config_id, [PROJECT_TASK].container as container, [PROJECT_TASK].container_type_id as container_type_id, [PROJECT_TASK].created_by_id as created_by_id, [PROJECT_TASK].created_on as created_on, [PROJECT_TASK].css as css, [PROJECT_TASK].current_state as current_state, [PROJECT_TASK].due_date as due_date, [PROJECT_TASK].generation as generation, [PROJECT_TASK].icon as icon, [PROJECT_TASK].id as id, [PROJECT_TASK].instructions as instructions, [PROJECT_TASK].is_current as is_current, [PROJECT_TASK].is_released as is_released, [PROJECT_TASK].item as item, [PROJECT_TASK].item_type_id as item_type_id, [PROJECT_TASK].keyed_name as keyed_name, [PROJECT_TASK].language_code_filter as language_code_filter, [PROJECT_TASK].locked_by_id as locked_by_id, [PROJECT_TASK].major_rev as major_rev, [PROJECT_TASK].managed_by_id as managed_by_id, [PROJECT_TASK].minor_rev as minor_rev, [PROJECT_TASK].modified_by_id as modified_by_id, [PROJECT_TASK].modified_on as modified_on, [PROJECT_TASK].my_assignment as my_assignment, [PROJECT_TASK].name as name, [PROJECT_TASK].new_version as new_version, [PROJECT_TASK].not_lockable as not_lockable, [PROJECT_TASK].owned_by_id as owned_by_id, [PROJECT_TASK].permission_id as permission_id, [PROJECT_TASK].priority as priority, [PROJECT_TASK].start_date as start_date, [PROJECT_TASK].state as state, [PROJECT_TASK].status as status, [PROJECT_TASK].team_id as team_id, [PROJECT_TASK].title as title FROM [PROJECT_TASK]]]></af:legacy_detail><af:exception message="Invalid column name 'priority'. Invalid column name 'title'. Invalid column name 'priority'. in SQL: CREATE VIEW [INBASKET_TASK] AS SELECT COALESCE('321BD822949149C597FD596B1212B85C', NULL) as ITEMTYPE, [WORKFLOW_TASK].assigned_to as assigned_to, [WORKFLOW_TASK].classification as classification, [WORKFLOW_TASK].config_id as config_id, [WORKFLOW_TASK].container as container, [WORKFLOW_TASK].container_type_id as container_type_id, [WORKFLOW_TASK].created_by_id as created_by_id, [WORKFLOW_TASK].created_on as created_on, [WORKFLOW_TASK].css as css, [WORKFLOW_TASK].current_state as current_state, [WORKFLOW_TASK].due_date as due_date, [WORKFLOW_TASK].generation as generation, [WORKFLOW_TASK].icon as icon, [WORKFLOW_TASK].id as id, [WORKFLOW_TASK].instructions as instructions, [WORKFLOW_TASK].is_current as is_current, [WORKFLOW_TASK].is_released as is_released, [WORKFLOW_TASK].item as item, [WORKFLOW_TASK].item_type_id as item_type_id, [WORKFLOW_TASK].keyed_name as keyed_name, [WORKFLOW_TASK].language_code_filter as language_code_filter, [WORKFLOW_TASK].locked_by_id as locked_by_id, [WORKFLOW_TASK].major_rev as major_rev, [WORKFLOW_TASK].managed_by_id as managed_by_id, [WORKFLOW_TASK].minor_rev as minor_rev, [WORKFLOW_TASK].modified_by_id as modified_by_id, [WORKFLOW_TASK].modified_on as modified_on, [WORKFLOW_TASK].my_assignment as my_assignment, [WORKFLOW_TASK].name as name, [WORKFLOW_TASK].new_version as new_version, [WORKFLOW_TASK].not_lockable as not_lockable, [WORKFLOW_TASK].owned_by_id as owned_by_id, [WORKFLOW_TASK].permission_id as permission_id, [WORKFLOW_TASK].priority as priority, [WORKFLOW_TASK].start_date as start_date, [WORKFLOW_TASK].state as state, [WORKFLOW_TASK].status as status, [WORKFLOW_TASK].team_id as team_id, [WORKFLOW_TASK].title as title FROM [WORKFLOW_TASK] UNION ALL SELECT COALESCE('9DC36DF7F0234A3E8CFFE2A20AB78CCE', NULL) as ITEMTYPE, [PROJECT_TASK].assigned_to as assigned_to, [PROJECT_TASK].classification as classification, [PROJECT_TASK].config_id as config_id, [PROJECT_TASK].container as container, [PROJECT_TASK].container_type_id as container_type_id, [PROJECT_TASK].created_by_id as created_by_id, [PROJECT_TASK].created_on as created_on, [PROJECT_TASK].css as css, [PROJECT_TASK].current_state as current_state, [PROJECT_TASK].due_date as due_date, [PROJECT_TASK].generation as generation, [PROJECT_TASK].icon as icon, [PROJECT_TASK].id as id, [PROJECT_TASK].instructions as instructions, [PROJECT_TASK].is_current as is_current, [PROJECT_TASK].is_released as is_released, [PROJECT_TASK].item as item, [PROJECT_TASK].item_type_id as item_type_id, [PROJECT_TASK].keyed_name as keyed_name, [PROJECT_TASK].language_code_filter as language_code_filter, [PROJECT_TASK].locked_by_id as locked_by_id, [PROJECT_TASK].major_rev as major_rev, [PROJECT_TASK].managed_by_id as managed_by_id, [PROJECT_TASK].minor_rev as minor_rev, [PROJECT_TASK].modified_by_id as modified_by_id, [PROJECT_TASK].modified_on as modified_on, [PROJECT_TASK].my_assignment as my_assignment, [PROJECT_TASK].name as name, [PROJECT_TASK].new_version as new_version, [PROJECT_TASK].not_lockable as not_lockable, [PROJECT_TASK].owned_by_id as owned_by_id, [PROJECT_TASK].permission_id as permission_id, [PROJECT_TASK].priority as priority, [PROJECT_TASK].start_date as start_date, [PROJECT_TASK].state as state, [PROJECT_TASK].status as status, [PROJECT_TASK].team_id as team_id, [PROJECT_TASK].title as title FROM [PROJECT_TASK]" type="Aras.Server.Core.InnovatorDatabaseException"><af:innerException message="Invalid column name 'priority'. Invalid column name 'title'. Invalid column name 'priority'." type="System.Data.SqlClient.SqlException"/></af:exception></detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope> Please let me know what is missing and need to be done to create and get each ECN’s TITLE and PRIORITY values for each ECN in MyInBasket. Your help will be highly appreciated!
See when and who claimed an activity
Hi We try to use as much as the out of box functionality as possible. We have just released a part request process in Aras and in this process we use the Claim functionality in "My InBasket". It works as supposed, but now users are asking if we can make it possible to see on the itemttype who has claimed the activity and when it was claimed by that person? Is that possible and if so how? Perhaps add to the infobox in the top left corner where Created By, Locked By, and etc is shown. Best Regards Henrik Olesen Kamstrup A/SDenmark
