This tutorial provides ]po[ Developers with instructions on how to
In following set up we want to add an additional criteria 'Operational Project Priority' to our ]po[ Department Planner. AJAX support allows the re-sorting of the table based on this new criteria.
This allows the user to compare different scenarios for resource consumption across a portfolio of projects.
Go to http://[YOUR_SERVER]//intranet-dynfield/object-type?object_type=im_project and create a new field 'project_priority_op_id'
Go to http://[YOUR_SERVER]/intranet/admin/categories/index?select_category_type=Intranet+DynView+Type and add a new sub-category 'Ajax'
You can create this view using the Admin interface at http://[YOUR_SERVER]/intranet/admin/views/ or use the following script:
insert into im_views (view_id, view_name, visible_for, view_type_id) values ([NEXT_AVAILABLE_VIEW_ID], 'portfolio_department_planner_list_ajax', 'view_users', [SUB_CATEGORY_AJAX]);Note: Replace [NEXT_AVAILABLE_VIEW_ID] and [SUB_CATEGORY_AJAX] with their respective values.
dropdown project_priority_op_id { [im_category_get_key_value_list "Intranet Department Planner Project Priority"] } 1 1Parameter for AJAX columns are defined as follows:
1. Parameter: Type ('dropdown' || 'link' || 'hidden')Following a sample script:
2. Parameter: Source -> column name
3. Parameter: In case of a dropdown list a key/value list of options
4. Parameter: Sortable (1/0)
4. Parameter: Resizeable (1/0)
insert into im_view_columns (column_id, view_id, group_id, column_name, column_render_tcl, extra_select, extra_where, sort_order, visible_for, ajax_configuration) values ([COLUMN_ID],[VIEW_ID],NULL,'Priority', '[im_category_from_id $project_priority_op_id]','','',5,'', 'dropdown project_priority_op_id { [im_category_get_key_value_list "Intranet Department Planner Project Priority"] } 1 1'); Note: Replace [COLUMN_ID] and [VIEW_ID] with their respective values.
http://[YOUR_SERVER]/intranet-portfolio-management/department-planner/index?view_name=portfolio_department_planner_list_ajax
Calle Aprestadora 19, 12o-2a
08902 Hospitalet de Llobregat (Barcelona)
Spain
Tel Europe: +34 609 953 751
Tel US: +1 415 200 2465
Mail: info@project-open.com