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 config...
Read more

WebSphere Commerce

Image
1. Explain WCS Archetecture WebSphere Commerce functional architecture Descriptions: Controller layer The conductor of operations for a request. It controls the transaction scope and manages the session related information for the request. The controller first dispatches to a command and then calls the appropriate view processing logic to render the response. Presentation layer The presentation layer displays the result of command execution. The presentation layer can use JSP pages, or other rendering technologies. Business Context Service (BCS) A service that manages contextual information used by business components. The contexts include such information as globalization and entitlement. Business logic facade This generic interface is implemented as a stateless session bean which the controller calls to invoke controller commands. Controller commands A controller command business process logic such as...
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