Differences

This shows you the differences between two versions of the page.

adminhelp:productadministration:pattributes:attributeautocomplete [2018/12/03 02:56]
bdjordje
adminhelp:productadministration:pattributes:attributeautocomplete [2019/08/07 08:00] (current)
bdjordje
Line 1: Line 1:
 ====== Autocomplete attribute ====== ====== Autocomplete attribute ======
  
-This type of attribute is a good choice for attributes with a lot of textual values. You can search for the desired attribute value by typing letters that are contained in the attribute value, no matter if letters are located at the begining or in the middle of the attribute value. +This type of attribute is a good choice for attributes with a lot of textual values. You can search for the desired attribute value by typing letters that are contained in the attribute value, no matter if letters are located at the beginning or in the middle of the attribute value. 
  
-As you start typing, SAP CPQ searches through a custom table that contains values for the particular attribute. That narrows a list of results against what you typed. In the following sections, you will see some examples how to set up an attribute of this type and its use in the configurator.+As you start typing, SAP CPQ searches through a custom table that contains the particular attribute values. That narrows a list of results against what you typed. In the following sections, you will see some examples of how to set up an attribute of this type and how to use it in the configurator.
  
 ====== Introduction ====== ====== Introduction ======
 \\ \\
-This attribute type requires a custom table as source for attribute values. As soon as you define a custom table you can proceed with creation of a new autocomplete attribute.+This attribute type requires a [[adminhelp:productadministration:customtables|custom table]] as the source of attribute values. As soon as you define a custom table you can proceed with the creation of a new autocomplete attribute.
 \\  \\ 
-You are free to select either one or more columns from the custom table as searchable columns. Additionally, you can define the display label of the column. Select a column and enter the label in the **Display Label** field. The label will automatically be appended to the original column name in the **Selected Searchable Columns** list. This feature enables administrators to create user-friendly display labels for users while keeping the original column name in **Setup**. The labels will display in the configurator in autocomplete attributes and on quotes in quote custom fields and quote item custom fields that use attributes sourced from custom tables.\\ +You are free to select one or more columns from custom table as searchable columns. Additionally, you can define the display label of the column. Select a column and enter the label in the **Display Label** field. The label will automatically be appended to the original column name in the **Selected Searchable Columns** list. This feature enables administrators to create user-friendly display labels for users while keeping the original column name in **Setup**. The labels will display in the configurator in autocomplete attributes and on quotes in quote custom fields and quote item custom fields that use attributes sourced from custom tables.\\ 
-If administrators select the **Show Only Distinct Values** checkbox, the system does not retrieve duplicate values from a column and only different values are displayed to users. This is applicable only when the same column is selected as the display and the value code column.+ 
 +If you select the **Show Only Distinct Values** checkbox, the system does not retrieve duplicate values from a column and only different values are displayed to users. This is applicable only when the same column is selected as the display and the value code column.
  
 Also, you have the ability to select one or more columns whose values will be displayed in search box.  Also, you have the ability to select one or more columns whose values will be displayed in search box. 
Line 16: Line 17:
 For more details on how to craft your autocomplete attribute, follow steps in next two examples. For more details on how to craft your autocomplete attribute, follow steps in next two examples.
 \\ \\
-First example assumes that you define only one searchable columnand display column. In the second example, we will define a new autocomplete attribute whith two searchable and display columns .+The first example assumes that you define only one searchable column and display column. In the second example, we will define a new autocomplete attribute with two searchable and display columns.
  
 ===== Example 1 – Define autocomplete attribute with single searchable and display column ===== ===== Example 1 – Define autocomplete attribute with single searchable and display column =====
Line 63: Line 64:
 ===== Example 2 – Define autocomplete attribute with two searchable and display columns ===== ===== Example 2 – Define autocomplete attribute with two searchable and display columns =====
  
-In this example will create brand new custom table, and brand new autocomplete attribute to show that you can select more columns to search and display values during autocomplete search on the attribute. +In this example will create brand new custom table, and brand new autocomplete attribute to show that you can select more columns to search and display values during autocomplete search on the attribute. 
-You can check previous example for steps for creation custom table and new attribute. Assuming that you are familiar with the creation process, here what you should define.+You can check the previous example for steps for creating a custom table and new attribute. Assuming that you are familiar with the creation process, here is what you should define.
 \\ \\
  
Line 73: Line 74:
 \\ \\
   * Define new attribute of type //autocomplete//. Name it as you like. We named it //autocomplete attribute//.   * Define new attribute of type //autocomplete//. Name it as you like. We named it //autocomplete attribute//.
-  * Now click on edit icon to edit attribute. Attribute administration page is displayed. Similar as in example 1, select columns in the left box and copy them to the right box titled //„Selected Searchable Columns“//. Note that you are able to select multiple columns. Repeat steps for the rest two boxes titled as //„Selected Display Columns“// and //„Selected Column Value Code“ (See Figure H).//+  * Now click on edit icon to edit attribute. The attribute administration page is displayed. Similar as in example 1, select columns in the left box and copy them to the right box titled //„Selected Searchable Columns“//. Note that you are able to select multiple columns. Repeat steps for the rest two boxes titled as //„Selected Display Columns“// and //„Selected Column Value Code“ (See Figure H).//
  
 \\ \\
Line 81: Line 82:
   * Click **Save** button   * Click **Save** button
  
-Now, once you in the configurator you are able to enter one value (first name, last name or city), or any combination of three, separated with space and comma. SAP CPQ will search through your custom table and will display the result(s) that match(es) in drop box. Notice on the Figure I how SAP CPQ displays only First Name and Last Name as search result. This is because we selected those two fields while defining autocomplete attribute. +Now, once you in the configurator you are able to enter one value (first name, last name or city), or any combination of three, separated with space and comma. SAP CPQ will search through your custom table and will display the result(s) that match(es) in the drop box. Notice on Figure I how SAP CPQ displays only First Name and Last Name as search result. This is because we selected those two fields while defining the autocomplete attribute. 
  
-Once you select some value, SAP CPQ will display the selected value in configurator. In this case SAP CPQ displays name of the citybecause we selected field city whose selected value code we wanted to be displayed.+Once you select some value, SAP CPQ will display the selected value in the configurator. In this caseSAP CPQ displays the name of the city because we selected field city whose selected value code we wanted to be displayed.
  
 \\ \\
Line 93: Line 94:
 \\ \\
  
-Prefilter feature allows you to reduce the number of served attribute values based on the condition you have defined previously. Since autocomplete attribute is sourced from the custom table there might be a situation when you have a large amount of attribute values stored in the custom table that you would want to prefilter before they are displayed to the user.+Prefilter feature allows you to reduce the number of served attribute values based on the condition you have defined previously. Since autocomplete attribute is sourced from the custom table there might be a situation when you have a large number of attribute values stored in the custom table that you would want to prefilter before they are displayed to the user.
 \\ \\
  
-You can use simple conditions that will be evaulated before your search input. This way you narrow down the number of attribute values before your search input is treated, which improves Configurator performance. The syntax for condition is the same as SQL syntax (e.g. //yourColumn = ‘34’ and yourAnotherColumn < 3000//).+You can use simple conditions that will be evaluated before your search input. This way you narrow down the number of attribute values before your search input is treated, which improves Configurator performance. The syntax for condition is the same as SQL syntax (e.g. //yourColumn = ‘34’ and yourAnotherColumn < 3000//).
 \\ \\
  
-You can make this precondition as complex as you can imagine and model using our standard SAP CPQ formula builder. Take a look at next two examples.+You can make this precondition as complex as you can imagine and model using our standard SAP CPQ formula builder. Take a look at the following two examples.
 \\ \\
  
Line 105: Line 106:
 \\ \\
  
-Assuming that we have the autocomplete attribute “//interior color//” defined and attached to the product, we can define simple condition that will narrow down the list of available values for the attribute. Our attribute interior color is sourced from the custom table that holds a list of next 5 available colors:+Assuming that we have the autocomplete attribute “//interior color//” defined and attached to the product, we can define simple condition that will narrow down the list of available values for the attribute. Our attribute interior color is sourced from the custom table that holds a list of next 5 available colors:
  
   * beige   * beige
Line 113: Line 114:
   * brown   * brown
  
-and from some reason, you want to display only colors that starts with the “//b//” letter. You can write condition on attribute definition page as displayed in Figure 1. +and from some reason, you want to display only colors that start with the “//b//” letter. You can write condition on the attribute definition page as displayed in Figure 1. 
 \\ \\
  
Line 120: Line 121:
 \\ \\
  
-Notice that we used the SQL syntax that matches string that begins with the “//b//” letter.+Notice that we used the SQL syntax that matches the string that begins with the “//b//” letter.
  
 ===== Example 4 (more complex condition) ====== ===== Example 4 (more complex condition) ======
Line 153: Line 154:
 \\ \\
  
-If user choose loan term of //5 years//, only loans that belong to the category 1 will be available to the user. If user chose loan term of //15 years// then loans from category 1 through category 3 will be available and so forth. So we defined the preselection filter as depicted in the Figure 2.+If user chooses a loan term of //5 years//, only loans that belong to the category 1 will be available to the user. If the user chose loan term of //15 years// then loans from category 1 through category 3 will be available and so forth. So we defined the preselection filter as depicted in Figure 2.
 \\ \\
  
Line 160: Line 161:
 \\ \\
  
-Now, when you are in configurator, based on what option you’ve selected for the loan term, the list of available options on Loan attribute gets filtered. //(See Figure 3)// +Now, when you are in the configurator, based on what option you’ve selected for the loan term, the list of available options on Loan attribute gets filtered. //(See Figure 3)// 
  
 {{:adminhelp:productadministration:pattributes:autocomplete-prefilter-3.png|}} {{:adminhelp:productadministration:pattributes:autocomplete-prefilter-3.png|}}
You are here: SAP Sales Cloud CPQ Online HelpAdmin Page HelpProduct AdministrationAttributesAutocomplete attribute