Versions Compared

Old Version 14

changes.mady.by.user Anastasia Suboch

Saved on

compared with

New Version 15

changes.mady.by.user Anastasia Suboch

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Heapselect is commonly used for the list and form layout configuration.

Another case of using the heapselect tool is editing synthetically related lists on a record form. The heapselect allows you to change the set of records displayed in the list.

Tip
titleThe best practice:
  1. Configure the heapselect URL.
  2. Create a URL Action using the heapselect URL or simply share the URL with other users.

When the user follows the link, the records displayed are always checked by the ACLs.

Heapselect URL configuration 
Anchor
heapselect configuration
heapselect configuration


Info
titleHow the heapselect works

The heapselect URL performs the following actions to the essence table:

  1. The server returns lists of records by their sys_id in two boxes using GET-parameters:
    1. In the left box – records filtered by the condition are available for the manual selection by user.

    2. In the right box – the custom script include (select_ids_script_id) returns specific table records by their sys_id. 

      Section


  2. (Optional) The title and the column value (display_value) displayed may be configured.
  3. When clicking Save, the script_id script include applies to all the record selected.

To configure the heapselect URL, use the GET-parameters and the view below:

Code Block
languagexml
<your_instance_URL>/<page_name>/<table_name>?condition=<conditional_expression>
	&selected_ids_script_id=<script_returning_sys_ids>
	&script_id=<script_applied>
	&display_value=<column_name>
	&title=<some_text>
	&field_name=<field_value>
	&form_view=<form_view_name>
GET-parameters description
GET parameterDescription
essenceThe system name of the source table.
condition

String conditions for table records filtering using the system condition operators and encoded URL characters.

Info

You can also apply the desired filter or the condition builder settings to the table in a list form, then copy the condition body from the browser URL and use it as the heapselect condition. Learn more about how the filter works.


select_ids_script_idThe custom Script Include that returns the list of the essence table records IDs (sys_ids) as operation results. When applying this script, the heapselect adds table records with the returned sys_ids in the Selected box of the form.
script_idThe Script Include that is applied to the essence table records contained in the Selected box of the form.
display_value

The name of a column to be displayed as record names in the heapselect form.

title

The string title of the heapselect form. By default, the Select Items title displayed.

parent_id

The ID of the record that will be affected by the action applied.

parent_table

The ID of the table that will be affected by the action applied.

field_nameA value to a specific field.
form_viewThe view of the form or a list. All users will switch to the defined view regardless of their preferred view.

Heapselect usage
Anchor
using the heapselect
using the heapselect


After the heapselect URL configured, use the heapselect options by following the steps below:

  1. Use the URL to enter the form and select the desired records. The Available box contains all the table fields, excluding selected ones. The records of the Selected box are selected for further script applying. Move elements by dragging them or using the  and buttons.

    Info
    • To remove or add all the fields, click the  or  buttons button.
    • To move several elements in a row, select them with the Shift key pressed and drag them from the Available box to the Selected one.
    • To move several scattered elements at once, select them with the Ctrl key pressed and drag them from the Available box to the Selected one.


  2. Click Save to apply the heapselect script to the records of the Selected box. 




Table of Contents
classfixedPosition