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
Workflow Activity Completion - Save Changes
Wrt Workflow Activities in Aras, users complete their activity by picking from the ‘Vote’ dropdown before clicking ‘Complete’. There is a ‘Save Changes’ option (see below) which allows users to save their comments without completing the activity. This option is presently unnecessary and is causing confusion internally - Can you please advise if/how we can disable or hide the ‘Save Changes’ button?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.
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! Florian
