{"type":"doc","content":[{"type":"layoutSection","content":[{"type":"layoutColumn","attrs":{"width":66.66},"content":[{"type":"paragraph","content":[{"text":"We learned in section ","type":"text"},{"text":"Creating your first mappings","type":"text","marks":[{"type":"link","attrs":{"href":"https://perfion.atlassian.net/wiki/spaces/PIM/pages/244331086/Ecommerce+API#Creating-your-first-mappings"}}]},{"text":" that one of its tasks is to tell EC what base-feature that holds the configuration for some entity. Figure 1 shows the most basic mapping:","type":"text"}]},{"type":"paragraph"},{"type":"mediaSingle","attrs":{"layout":"center","width":50.0},"content":[{"type":"media","attrs":{"width":473,"id":"163b9d58-d450-41f8-bad0-38ad18a5c61e","collection":"contentId-244331993","type":"file","height":35}},{"type":"caption","content":[{"text":"Figure 1: The context mapping for the ‘Product’-entity on channel “My Channel”","type":"text"}]}]},{"type":"paragraph","content":[{"text":"This basically tells, that if someone fires a GetProducts-request on channel ‘My Channel’ we will find these products in a feature named ","type":"text"},{"text":"Product","type":"text","marks":[{"type":"em"}]},{"text":". This feature","type":"text"},{"text":" ","type":"text","marks":[{"type":"em"}]},{"text":"must be a selectable feature and will 99% of the time hold a configuration in Perfion.","type":"text"}]},{"type":"paragraph","content":[{"text":"Separated by / (front slash) you can give EC more information about this Context. Consider the mapping in Figure 2:","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":66.0},"content":[{"type":"media","attrs":{"width":552,"id":"74e9530b-24aa-4293-8413-d32ec4eaeeef","collection":"contentId-244331993","type":"file","height":35}},{"type":"caption","content":[{"text":"Figure 2: Now the “from”-value consists of three parts: The feature name, a view and finally a search","type":"text"}]}]},{"type":"paragraph","content":[{"text":"The two new parts are containing a ","type":"text"},{"text":"name of a system view","type":"text","marks":[{"type":"strong"}]},{"text":" (See Perfion API for more information on what a system view is). In versions before version 4.5 2019 R1, this view is not really used by EC. In 4.5 2019 R1 and later, the view is used by the *-mapping to be able to map all features in a standard view by creating a single mapping. See more on ","type":"text"},{"text":"*-mapping","type":"text","marks":[{"type":"link","attrs":{"href":"https://perfion.atlassian.net/wiki/spaces/PIM/pages/244331086/Ecommerce+API#Field---Using-a-*--or-**-mapping-(also-called-wild-card-mappings)"}}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":"In Perfion v. 4.5.36 is the capability to write a “-“ (a minus or dash) as the view name telling the EC API that it should omit selecting any data from any system view. In some installations, that is can give a performance improvement. I.e. writing for example “Product/-/MyProductSearch“ or simply “Product/-“ as from-value for the Context-mapping will make EC API stop selecting from any System view. Doing that will effectively disable the *-mapping.","type":"text"}]},{"type":"paragraph","content":[{"text":"The 3","type":"text"},{"text":"rd","type":"text","marks":[{"type":"subsup","attrs":{"type":"sup"}}]},{"text":" part of the base-value of the context node is the ","type":"text"},{"text":"name of a search","type":"text","marks":[{"type":"strong"}]},{"text":" that somehow limits what products are to be fetched by EC. If you, for example, have some products in “Draft”-state and some in “Production” you might be interested only to have “Production”-products fetched by UC. This is done by specifying the name of the Search-feature that make sure only products marked “Production” is fetched. In Figure 2 this search-feature is named ","type":"text"},{"text":"MyProductSearch","type":"text","marks":[{"type":"em"}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":"One way to create such a search is as follows:","type":"text"}]},{"type":"paragraph","content":[{"text":"First let us create a feature holding the value for each product that determines whether they are “Draft” or “Production”. That is done by creating a string feature named ","type":"text"},{"text":"ProductState","type":"text","marks":[{"type":"em"}]},{"text":" as can be seen in Figure 3.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":557,"id":"b03a50ed-9587-4216-81e1-1c4b26419f34","collection":"contentId-244331993","type":"file","height":736}},{"type":"caption","content":[{"text":"Figure 3: Feature for holding the state on each product","type":"text"}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Make sure to assign this feature to the configuration of Product and in Feature Data allow it to hold either of the two values “Draft” and “Production” (not shown).","type":"text"}]},{"type":"paragraph","content":[{"text":"Now assign a value for “ProductState” to all your products as shown for three products in Figure 4.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":50.0},"content":[{"type":"media","attrs":{"width":314,"id":"b642373b-5e71-4ae5-8954-97e3c3bfd07a","collection":"contentId-244331993","type":"file","height":139}},{"type":"caption","content":[{"text":"Figure 4: Three products of which two are marked for the production while one is still in draft","type":"text"}]}]},{"type":"paragraph","content":[{"text":"An easy way to create a query fetching only products in production is to right click on any cell having the value “Production” and click “Filter by value”. This filters everything else away. The exact filter query can be obtained by clicking the filter-icon shown in below.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":660,"id":"a157f630-31d0-48ec-abac-e6e66c3a917e","collection":"contentId-244331993","type":"file","height":183}},{"type":"caption","content":[{"text":"Figure 5: Clicking the Filter-icon opens the Filter-Editor","type":"text"}]}]},{"type":"paragraph","content":[{"text":"In the Filter Editor, switch to “Advanced Mode” and copy the Perfion Query onto the clipboard.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":646,"id":"899ff2e5-4a0f-499a-84ec-2da2ed768f59","collection":"contentId-244331993","type":"file","height":260}},{"type":"caption","content":[{"text":"Figure 6: This Perfion Query indeed filters everything not having a ProductState of “Production” away","type":"text"}]}]},{"type":"paragraph","content":[{"text":"With this query on the clipboard, go to “Feature Data” and create a value for the feature ","type":"text"},{"text":"ECommerceSearches. ","type":"text","marks":[{"type":"em"}]},{"text":"This is actually a feature created as part of auto creating features for EC (described in chapter ","type":"text"},{"text":"Auto creating Features","type":"text","marks":[{"type":"link","attrs":{"href":"https://perfion.atlassian.net/wiki/spaces/PIM/pages/244331086/Ecommerce+API#Auto-creating-Features"}}]},{"text":"). This value must be named the same as the 3","type":"text"},{"text":"rd","type":"text","marks":[{"type":"subsup","attrs":{"type":"sup"}}]},{"text":" part of the context-node, in this case it ","type":"text"},{"text":"MyProductSearch","type":"text","marks":[{"type":"em"}]},{"text":" (See Figure 2).","type":"text"}]},{"type":"paragraph","content":[{"text":"Now right-click on this newly created value and pick “Edit Query…” from the menu as shown in Figure 7.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":1130,"id":"8b88cbf0-08ab-4a58-b320-5534ac93c433","collection":"contentId-244331993","type":"file","height":970}},{"type":"caption","content":[{"text":"Figure 7: To fill in a query for a value of a Search-feature you would pick the “Edit Query…”-menu","type":"text"}]}]},{"type":"paragraph","content":[{"text":"In the Query-window that appears, paste in the copied query. This has been done in Figure 8:","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":728,"id":"4c2110e5-848c-4cb4-8b36-ddc03bb41529","collection":"contentId-244331993","type":"file","height":424}},{"type":"caption","content":[{"text":"Figure 8: The query from before has been pasted in","type":"text"}]}]},{"type":"paragraph","content":[{"text":"From here you only need to click “OK”.","type":"text"}]},{"type":"paragraph","content":[{"text":"To test that filter is working, go to the “API Query Tool”-window and ask for, say, the 3 products we tagged up in Figure 18: The ones numbered DFGR1181, DFGR1280 and DFGR1686, respective. If everything works as expected, only the first two products should be returned, since the final one, DFGR1686, is in Draft-mode.","type":"text"}]},{"type":"paragraph","content":[{"text":"This request does indeed that:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n \n \n \n DFGR1181\n DFGR1280\n DFGR1686\n \n","type":"text"}]},{"type":"paragraph","content":[{"text":"And the result is:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n \n \n 2\n \n \n \n \n \n \n","type":"text"}]},{"type":"paragraph","content":[{"text":"Notice that, as expected, EC only returns two products.","type":"text"}]},{"type":"paragraph","content":[{"text":"If you get an error message from EC, typically saying that some Perfion Query went wrong, check the naming and casing of the feature names. It is, unfortunately, quite easy to get these wrong.","type":"text"}]}]},{"type":"layoutColumn","attrs":{"width":33.33},"content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"477c5318-dac4-4857-8f3f-9a101ce3702e"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"9c721ba0-c3aa-4df0-ad0c-63af5ba5362a"}}]}]}],"version":1}

Browser not supported