How to add columns to My InBasket records
I am looking at this pdf and wondering if this is the only way to add columns in the InBasket search grid for the end user. Aras Innovator 27 - Configurable InBasket.pdf the data is on Aras's cloud, we are not on-prem. As per these instructions I have to drop, recreated and rename views and tables. As per these instructions you are suppose to check if the views were dropped. I cannot confirm that because we don't have access to our data. These instructions are super finicky. The queries provided in this document sometime run from Aras portal and sometimes not. I have been running the queries directly in SSMS and still facing errors. Is there literally no other way of adding columns to InBasket. I just want the "Title" in there
Open Favorite search for My Inbasket page from email body
Hello, How to open My Inbasket Item type favorite search from email body. How to generate link for favorite search? https://your-aras-domain/Innovator/Client/Default.aspx?StartItem=MyFavoriteSearch it is not working for Inbasket. Is there any alternate solution for this? Regards, Suhas
How normal users is able to see tasks in InMyBasket?
Hi experts, We are using innovator 11 SP9. Currently, only administrator is able to see all tasks of other users in 'InBasket'. I need to change the configuration (authorization?) for normal users to see other users' tasks too in their 'InBasket'. But, I couldn't find a solution. Would you please help on this? Thank you so much for your help. Joseph
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!
Add 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.
Updating stale Dynamic Workflow Variables
Is it possible to update the variable list when the user opens the vote dialog from the inBasket, to ensure the latest possible variable list is available? The Scenario: On the ItemType 'Project', I have a workflow which looks at the Activity2 Items and builds a list of variables relating to their current states. This allows users to process the InBasket task and promote the Activity2 Items based on the variable selection, without going through the project screens (through an approval process). The workflow activity for the Project loads the variables with the current values onActivate of the current workflow step. The concern is that if someone updates one of the Activity2 Items after the InBasket Item has been created, the variable does not reflect the new state of the Project. Is it possible to update the variable list when the user opens the vote dialog from the inBasket, to ensure the latest possible variable list is available? In theory it would be possible to update the variables from a trigger on the Activity2, but I would prefer to drive the update from the InBasket to reduce overheads at the time of (bulk) Activity2 Promotion. Many thanks, Martin.
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) )
