Attribute Dictionary

Attributes and Products relation will be there in CATENTRYATTR table.

Other required tables are,

ATTR,
ATTRDESC,
ATTRVAL,
ATTRVALDESC.

Using the Services provided by OOB we can get this data by passing the catentryId and langId.

WCS Service:

<wcf:getData type="com.ibm.commerce.catalog.facade.datatypes.CatalogEntryType" var="catentryAttr" expressionBuilder="getStoreCatalogEntryAttributesByID">
      <wcf:contextData name="storeId" data="${param.storeId}"/>
      <wcf:param name="catEntryId" value="${product.entitledItems[0].itemID}"/>
      <wcf:param name="dataLanguageIds" value="${WCParam.langId}"/>
 </wcf:getData>

WCS Service will be called by using “wcf:getData” tag library. We need to specify expressionBuilder which is already there in get-data-config.xml (This file will be under the following folder /Stores/WebContent/WEB-INF/config/com.ibm.commerce.catalog/)

This is catalog related data, Member related xml file will be under com.ibm.commerce.member/order related xml will be under *.order.

This service will call the OOB BOD command CatalogEntryType and using this service we can get the list of attributes associate to the itemID.

Example:

<c:forEach var="attribute" items="${catentryAttr.catalogEntryAttributes.attributes}" varStatus="aStatus">
     <%-- Set the static attribute values --%>
            <c:if test="${attribute.usage == 'Descriptive' && attribute.name == RONA_ECO}">
                         <c:set var="isEco" value="${attribute.value.value}" scope="request"></c:set>
                  </c:if>

</c:forEach>

Comments

Unknown said…
Nice post.How do you fetch the attribute value in the controller command without using SQLs?Can you do it using the CatalogFacadeClient?
March 11, 2016 at 3:42 PM
Post a Comment

Popular posts from this blog

Dataload Utility In WCS

Data can be loaded into WCS tables using data load utility.   WCS Data Load utility performs the following functions in a single operation: 1.              Reads the data from the input source file. 2.              Transforms the source data to WebSphere Commerce business objects. 3.              Allocates and resolves WebSphere Commerce business objects to physical data. 4.              Loads the physical data into the database. There are three configurations files and a input source file required to complete the data loader setup. WCS supports only CSV File Reader for other input source you have to write your own Reader Class. This means that if you are using OOB CSVReader then your input file must be a CSV file. The three configuration files are listed below. 1.              wc-dataload-env.xml 2.              wc-dataload-loader.xml 3.              wc-dataload.xml wc-dataload-env.xml holds the environment settings such as database name,encrypted password,data
Read more

10 Steps to Configure Email – Websphere Commerce Server

10 Steps to Configure Email – Websphere Commerce Server Websphere Commerce Server – Configure Email Follow 10 steps for configuring email in Websphere Commerce Server Step 1: Create a JSP ( eg:- AbcEmailNotify.jsp) Create a JSP, lets name it AbcEmailNotify.jsp AbcEmailNotify.jsp will be used for displaying contents of email to recipient. Note: Currently keep AbcEmailNotify.jsp as blank (without any code) Step 2: Create View ( eg- AbcEmailNotifyView) Make an Entry in Struts-Config.xml file for AbcEmailNotify.jsp as below < action path=’/AbcEmailNotifyView’ type=’com.ibm.commerce.struts.BaseAction’> < set-property property =’authenticate’ value =’10101:1′/> < set-property property =’https’ value =’10101:1′/> < /action> < forward name=”AbcEmailNotifyView /10101/-3″ path=”/< location of JSP file >/AbcEmailNotify.jsp” className=”com.ibm.commerce.struts.ECActionForward”> < set-property property=”implClassName” value=”com.i
Read more

Multiple Wish List

Image
Multiple Wish List How to enable?  Go to Commerce Management Center → Store Management → Select Store →  Select Wish list, Widgets and Feeds Tab and check “Multiple wish lists” check box. Characteristic's of Multiple wish list 1.          Wish Lists are stored in gift registry tables. 2.          New Gift List SOA Service a) GiftList noun A subset of these elements is used to represent wish lists. The Boolean element Registry indicates whether the noun represents a gift registry or wish list. Wish List Display Code 1. User will be always having a default wish list. The code snippet to get default wish list for a user is 2.          Get details of the selected wish list of a user. Here “selectWishListExternalId”  is the identifier of the wish list selected by the user. This object snippet calls findGiftListByUniqueIDs expression build to get the specified SOA wish list 3.          Get all the wish lists for a user       < wc
Read more