Filter records in the Data List widget

Create a condition script to filter records in the Portal Data List widget.

Vorbereitungen

The UI Components for Customer Portals plugin must have been activated. For more information, see Activate the UI Components for Customer Portals plugin

Role required: sp_admin

Prozedur

1. Navigate to All > System Extensions Points > Scripted Extensions Points.
2. On the Extension Points page, in the API Name column search field, enter *datalist.
3. Select the sn_ciwf_ui_cmpnt.DatalistCategoryConditionScript in the API Name column.
   If a message appears about the application scope, select here to be able to edit the record.
4. On the DatalistCategoryConditionScript page, in the Related links, select Create implementation.
5. In the Script field, paste the following CSS code:

   
   getQuery: function(category_id, params) {
       return “query”; // filter query
   }
   

   Tabelle : 1. Function parameters

   Parameters	Description
   category_id	Portal Data List category id.
   params	JSON containing url_params and related_table. For example, { "url_params": { "table": "customer_contact", "sys_id": "60beb5e7d7600200e5982cf65e6103ad", "view": "sp" }, "related_table": "sn_customerservice_case" }

6. Copy the name of a condition script from the Name field.
7. Select Update.
8. Navigate to your portal home page.
9. On the Data List widget, press Control+right-click.
10. Select Instance Options.
11. In the Behavior section, paste the name that you copied into the Data List condition script field.
12. Select the condition script from the list.
13. Select Save.