Do you know how to set up each standalone server(Solr, Datahub, App, Admin)?
Refer tothis post, which points you to right wiki link for detail steps
Ankitkumar Patel
Sr. SAP Hybris consultant, having 6+ years experience in Hybris, Java, J2EE.
Extensive hands-on experience in SAP Hybris development, third-party integrations with Hybris, project architecture and design... Read more
Scenario1: Basic JOIN and IN query syntax Get the most recent order for each customer using flexible search. select {o.code} as orderCode, {c.name} as name, {a.cellphone} as cellphone from {order as o join Customer as c on {c.pk} = {o.user} join Address as a on {o.deliveryaddress} = {a.pk} } where {o.code} in ({{select max({code}) from {order} group by {user}}}) Note: This query is not optimized one. This is just the reference to the temporary table join syntax select t1.orderCode, t1.name, t1.cellphone from ({{ select {o.code} as orderCode, {c.name} as name,{a.cellphone} as cellphone from {order as o join Customer as c on {c.pk} = {o.user} join Address as a on {o.deliveryaddress} = {a.pk}} }}) as t1 Join ({{ select max({code}) as orderCode, {user} as user from {order} group by {user} }}) as t2 on t1.orderCode = t2.orderCode Scenario2: Temporary table and join between them Fetch all regist
Scenario 1: I want to remove all the data from the Hybris ItemType. Solution: If you want to remove all records for particular itemType. Then you can do it using HAC Impex import. Open HAC (/hac) Go to console > ImpEx Import Run the below Impex (Change MyItemType with the ItemType for which you want to remove the data) $targetType=MyItemType REMOVE $targetType[batchmode=true];itemtype(code)[unique=true] ;$targetType Scenario 2: Sometimes, you want to remove selected data based on some condition or probably want to run complex SQL query. Then we wish if we could do it by writing SQL query, as many of developers are aware of syntax and its resources are easily available. Solution: Yes, you can do it in Hybris HAC also. Only thing is you should know the appropriate table and attribute/fields names in DB. If you don't, you can always run the select flexible search query and can see generated SQL query. Open HAC (/hac) Go to console > FlexibleSearch Se
Scenario: I want to hide Time Created and other fields from Title item type create wizard. Solution: Since, Title type doesn't have create-wizard component declared, So generic Item type create-wizard will be picked. To declare it in running system Open backoffice with admin user. Open Application Orchestrator by pressing F4 key. Click on Hybris symbol Y (Top right corner) and select show cockpit-config.xml Scroll down to last line in XML(ctr+end) Past the below XML code just before tag Click on store and save the file Press F4 again to close the Application Orchestrator Test your changes XML <context type="Title" component="create-wizard" module="platformbackoffice"> <wz:flow xmlns:wz="http://www.hybris.com/cockpitng/config/wizard-config" xmlns:advanced-search="http://www.hybris.com/cockpitng/config/advancedsearch" xmlns:df="http://www.hybris.com/cockpitng/component/dynamicForms"
Comments
Post a comment