Working with Lists

in previous releases, lists were referred to as grids the term grid has now been deprecated in favor of the term list about lists docid 5sknnbwacog7kx6hee5tsviewing lists docid 5sknnbwacog7kx6hee5tsabout reordering columns in a list docid 5sknnbwacog7kx6hee5tscreating a list docid 5sknnbwacog7kx6hee5tsduplicating a list docid 5sknnbwacog7kx6hee5tsmodifying a list docid 5sknnbwacog7kx6hee5tslocalizing list values docid 5sknnbwacog7kx6hee5tshiding preview settings in a list docid 5sknnbwacog7kx6hee5tsopening a list in a new tab docid 5sknnbwacog7kx6hee5tsadding a progress bar in a list docid 5sknnbwacog7kx6hee5tsusing the image renderer docid 5sknnbwacog7kx6hee5tsusing the size renderer docid 5sknnbwacog7kx6hee5tscreating a hyperlink in a list docid 5sknnbwacog7kx6hee5tsopening a list to a specific business object docid 5sknnbwacog7kx6hee5tsdisplaying a field name in a list docid 5sknnbwacog7kx6hee5tssetting a blank column header in a list docid 5sknnbwacog7kx6hee5tsdeleting a list docid 5sknnbwacog7kx6hee5tsdefining default list settings docid\ h1zwjgzuggi4lihio52vuexample highlighting certain incidents in a list docid\ s s7ujcygnnegt7ebyt3sexample replacing text with images in a list docid\ bpyachcdgjctnqnmdm7li about lists a list shows multiple records in a table view columns represent the fields for each record lists are defined within each business object, and are then viewed in a layout you can customize the colors of a list by using highlighter styles see using highlighter styles docid\ ealzqhhx4c 6sp xmvrf viewing lists from the configuration console, click build > business objects to open the business objects workspace open a business object click the lists tab the application displays a set of lists created for the business object list of lists for a business object about reordering columns in a list each business object has its own list configuration; that is, which column headers appear and in what order they appear depends on the business object that you are viewing to rearrange columns in any list, click a column header and drag it where you want it in the example below, click the source header and drag it to the left of the status header the check icon means that the header is in position reordering columns in a list remembers how you arranged the columns in each list the next time you log in, displays the column heads in the order that you arranged them to restore the default column order, click the restore icon at the bottom of the list creating a list from the configuration console, click build > business objects to open the business objects workspace open a business object click the lists tab the application displays a set of lists created for the business object click add new list the application displays the list editor and the list properties dialog box opens enter information into the fields field description list name a unique name style the style see working with styles docid 47 iwxwhri1aww5t59or workspace paging the number of records to appear by default when the list is used in a workspace (layout) dashboard paging the number of records to appear by default when the list is used in a dashboard part dialog paging the number of records to appear by default when the list is used in a dialog box search paging the number of records to appear by default when the list is used as search results description a brief description sort column the column to be used as the default sort column sort order the sort, either ascending or descending group by the column to be used as the default group column open in a new tab select yes or no the list opens in a new tab if you select yes go to where the list goes click submit the application creates an empty list you can access these fields again by clicking list properties now you can add columns to the list from the toolbox panel, expand the fields or relationship lists, then drag and drop each field onto the list pane each field appears as a column in your list when your cursor is in the right place to drop the field, the application displays a green check mark you can drop the fields in any order and reorder them later by dragging them around see about reordering columns in a list docid 5sknnbwacog7kx6hee5ts adding columns to a list as you add each field, the application displays a column header define the properties of each list column as needed column properties appear in the far right pane property description header title adds a customized column name double click the field and enter the custom text width the pixel width of this column the default is 100 data field the exact name of the field you added in the list pane even if you customized the name in the title field, the field entry remains the same sortable enables sorting features for this list column the column name is added to the sort column drop down list groupable enables grouping features for this column the column name is added to the group by drop down list word wrap enables word wrap for column text by default, all column text is displayed as one line, allowing longer entries to be obscured in the list initially visible specifies if the application initially displays this column name in the initial list view with a check (if the user clicks columns for a list, the application displays the initial list view with the names of all columns but only shows information for the columns that are checked ) initial list view to have this field name show up on the initial list view with a check, select yes to have this field name show up on the initial list view without a check, select no note regardless of how you set this field, users can check or uncheck the columns from the list hidden expression specifies if the application displays this column name in the initial list view to display this column name in the initial list view, select always from the drop down list, then click the expression button to display the expression editor enter an expression such as $(getglobal("featurea")) and click save the application displays this column name if the expression evaluates to true to never display this column name in the initial list view, select never from the drop down list allow tips specifies if the application displays tool tips yes tool tips appear when users hover over the field name the tool tip shows the header text of the column no tool tips do not appear style style default no changes to the style of this column expression open the expression editor and enter an expression for this style (see about using expressions in styles docid\ ellmerq8evcxvioqlgh32 ) these ad hoc styles can not be accessed by other elements to link a field for example, \[link\ orgunitlink]name to combine a business object type and internal relationship name in relationship instances using a link recid field for example \[organizationalunit# ]name to create a unique style for example, the expression $(if status == "closed" then "redstyle" else "limestyle")) returns the row as red if the record status is closed and returns the row as lime green if it is not closed style names style names are created in highlighter styles see using highlighter styles docid\ ealzqhhx4c 6sp xmvrf renderer a rendering option for example, you can render the column as an option to be checked, or as a yes/no option these options are different for each field type see field renderer options docid 5sknnbwacog7kx6hee5ts image specifies an image to display to display an image, click the expression button to display the expression editor enter an expression such as $(if isvip == true then "crown2 orange png" else "") and click save the application displays this image if the expression evaluates to true link hyperlink shows the field value as a hyperlink yes the field value is a hyperlink no the field value appears as the default go to choose this object or a link field field renderer options the following render options are available for each field type you cannot sort or group a column that has an unlimited length or is in binary form field type renderer option available asymmetricallyencryptedstring no options binary left aligned right aligned currency left aligned right aligned date/time default shows date and time date only link text html link to object number left aligned right aligned password no options symmetricallyencryptedstring no options text text html strips out html tags and shows only the text use if the tags are not formatted properly or if the data is large html v2 keeps html tags and shows the formatted html text multiline text choose to enable word wrap and preserve line breaks for column text by default, all column text is displayed as one line, allowing longer entries to be obscured in the list progress bar for information about the progress bar see adding a progress bar in a list docid 5sknnbwacog7kx6hee5ts yes/no also known as boolean checkbox yes/no y/n duplicating a list from the configuration console, click build > business objects to open the business objects workspace open a business object click the lists tab the application displays a set of lists created for the business object click the copy list icon in the lower right corner of a list copying a list enter a unique list name in the field click save the application appends a copy of the list with the new name to the existing lists modifying a list from the configuration console, click build > business objects to open the business objects workspace open a business object click the lists tab the application displays a set of lists created for the business object open a list the application displays the list editor change the information as needed see creating a list docid 5sknnbwacog7kx6hee5ts localizing list values when you work with lists in a language other than english, you might observe a word or phrase that is not properly translated to add or correct a translated word or phrase, do the following from the configuration console, click build > business objects to open the business objects workspace open a business object click the lists tab the application displays a set of lists created for the business object open a list click translation tool and choose the locale language from the drop down menu the application displays the translation tool dialog box optional to view words and phrases from all lists, choose all in the lists drop down menu click search to view the words and phrases from the current list the application displays the search results the first column shows the property, that is, the specific place, where a word or phrase is used in the current list the third column shows the word or phrase as it appears right now in the third column, click a string to open it for editing from the drop down list, choose a new string, if any are suggested, or enter new text press enter to record (but not save) the change the application displays a red triangle next to the unsaved text string change additional strings as necessary click save the translation string changes are now implemented hiding preview settings in a list to prevent the preview area from displaying in a list, follow these steps from the configuration console, click build > business objects to open the business objects workspace open a business object click the layouts tab open a layout in the views in this layout section, click gridview clicking gridview in the preview form field, select not set from the drop down list click save return to the application and refresh the browser open the business object to verify that the preview area does not show and that the list displays on the page opening a list in a new tab from the configuration console, click build > business objects to open the business objects workspace open a business object click the lists tab the application displays a set of lists created for the business object open a list click list properties to display the list properties dialog box in the open in new tab field, select yes click submit click save return to the application and refresh the browser click a business object to verify that it opens in a new tab adding a progress bar in a list see from the "list configuration" tab docid\ namwim ahfhmj7qila1ee from the configuration console, click build > business objects to open the business objects workspace open a business object click the lists tab the application displays a set of lists created for the business object open a list highlight a column in the renderer field on the right hand side, select progress bar click save return to the application and refresh the browser open a business object and verify that the progress bar displays in the correct column progress bar in a list using the image renderer you can add an image to any column in a business object you can show different images for different sets of records for example, you may want to include a particular image for customers that have special privileges due to their status or importance the available images are stored in the image manager follow these steps to add an image from the configuration console, click build > business objects to open the business objects workspace open a business object click the lists tab the application displays a set of lists created for the business object open a list select a column in the image field on the right hand side, click inside the field at the bottom right of the expression editor, click image manager highlight an image and click select click save click save again return to the application and refresh the browser open a business object and verify that the image displays in the correct column using the size renderer if a column contains numerical data in bytes, the size renderer converts the bytes into kilobytes follow these steps to use the size renderer from the configuration console, click build > business objects to open the business objects workspace open a business object click the lists tab the application displays a set of lists created for the business object open a list select a column that contains numerical data in the renderer field on the right hand side, select size size is not listed as a choice in the drop down list unless the column you selected contains numerical data click save return to the application and refresh the browser open a business object and verify that the numerical data displays in kilobytes creating a hyperlink in a list from the configuration console, click build > business objects to open the business objects workspace open a business object click the lists tab the application displays a set of lists created for the business object open a list select any column set the hyperlink field to yes in the go to field, select a link field object from the drop down list setting the hyperlink field to yes click save return to the application and refresh the browser verify that the information in the selected column contains a hyperlink to your selection opening a list to a specific business object from the configuration console, click build > business objects to open the business objects workspace open a business object click the lists tab the application displays a set of lists created for the business object open a list click list properties in the go to field, select where the list should go when opened for example, select either this object or another business object in the list list properties click submit click save return to the application and refresh the browser open the workspace that you selected and click on any record to verify that it opens to the selection that you made in step 6 displaying a field name in a list when you click the header of a selected column, the header title displays in the field and title fields in the right hand side from the configuration console, click build > business objects to open the business objects workspace open a business object click the lists tab the application displays a set of lists created for the business object open a list click a column header the application displays the column name in the field and title fields on the right hand side setting a blank column header in a list from the configuration console, click build > business objects to open the business objects workspace open a business object click the lists tab the application displays a set of lists created for the business object open a list select any column on the right side, remove the text in the title field removing the text in the title field click save return to the application and refresh the browser verify that the column header in the column you selected contains no header (is blank) deleting a list from the configuration console, click build > business objects to open the business objects workspace open a business object click the lists tab the application displays a set of lists created for the business object in the box with the list information, click the delete icon deleting a list the delete confirmation dialog box appears click yes to confirm the deletion the application checks whether the list is used in another object if so, a validation message informs you that the list cannot be deleted and where the list is used if this list is not used in another object, the application deletes the list