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!
