Hybris/ SAP commerce Cloud Flexi search query

 Hybris flexi Search Query Sample:

1. Find Duplicate Product:

select  {code},count({code}) from {product} group by {code} having count({code}) > 1 


2. B2BUnit/Group belongs to User


select distinct {unit.uid},{unit.name},{ct.uid} from { PrincipalGroupRelation as pgrel

join b2bunit as unit on {unit.pk}={pgrel.target}

Join B2Bcustomer as ct ON {ct.pk}={pgrel.source} }

where {pgrel.source} in ({{ select {pk} from {b2bcustomer} where {uid}='example@gmail.com' }})


3.User Belongs to B2Bunit


select distinct {bcustomer.uid} from {

B2BCustomer as bcustomer} where {bcustomer.pk} IN ({{

select distinct {ppgrprel.source} from {b2bunit as unit

JOIN PrincipalGroupRelation as ppgrprel ON {unit:PK}= {ppgrprel:target} }

where {unit.uid}='123456859_PARENT' }})



4.User Belongs to Group


select distinct top 10 {bcustomer.uid} from {

B2BCustomer as bcustomer} where {bcustomer.pk} IN ({{

select distinct {ppgrprel.source} from {Usergroup as grp JOIN PrincipalGroupRelation as ppgrprel ON {grp:PK}= {ppgrprel:target} } where {grp.uid}='b2basagentgroup' }})

5. All Child B2Bunit for Parent unit

select distinct {childUnit.uid} from {
b2bunit as childUnit} where {childUnit.pk} IN ({{
select distinct {ppgrprel.source} from {b2bunit as unit JOIN PrincipalGroupRelation as ppgrprel ON {unit:PK}= {ppgrprel:target} } where {unit.uid}='AMAZON_1001_UD_PARENT' }})


Comments

  1. trutemal_chiApril 24, 2022 at 4:09 AM

    trutemal_chi Gary High https://wakelet.com/wake/vKjA_6lC0fqBpKoi1c4xf
    carsingwhisfi

    ReplyDelete
  2. Nvizion SolutionsMay 30, 2022 at 4:59 AM

    This blog provided brief knowledge about the Hybris/ SAP commerce Cloud Flexi search query. It will help us in developing new search queries!

    ReplyDelete
  3. opconroaNovember 30, 2022 at 6:02 PM

    adinal_bu Erica Cain Link
    There
    scoutareshos

    ReplyDelete

Post a Comment

Popular posts from this blog

Hybris / SAP Commerce Cloud Groovy Scripting Job to Generate CSV/Excel Reports and copy to Commerce cloud Blob Storage

Below are the steps to create scripting Cronjob from Back office: 1. Create Script of type Groovy 2. Create Scripting Job. 3. Create Cronjob. refer some already exist or OOB scripting job e.g.  evalCustomRefundAmount, evalOrigRefundAmount to get more details  Example Groovy Script: import de.hybris.platform.servicelayer.search.FlexibleSearchQuery; import java.text.SimpleDateFormat; flexibleSearchService = spring.getBean 'flexibleSearchService'; //put here the spring  bean specific to your project/implementation which reference to blob storage dataContainer =  spring.getBean 'dataContainer'; def fileContent = new StringBuilder(); //File header def FILE_HEADER = 'InvoiceNum,ActNum,Status'; def NEW_LINE_SEPARATOR = '\n'; def COMMA_DELIMITER = ','; fileContent.append(FILE_HEADER); fileContent.append(NEW_LINE_SEPARATOR); //File Name format and location in Azure Blob Storage def date = new Date(); def sdf = new SimpleDateFormat('MM_dd_yyyy_HH:mm...
Read more

Emma's dream - a kids story - By Kavya

Emma's Dream Emma was in her marshmallow themed bed, she had hoped to get a great dream tonight. “Good night Emma” said her mom. “Good night mom!” she said as she was about to fall asleep. In her dream she found herself surrounded by candy, cotton candy clouds, lollipop trees, a chocolate river and gumdrop rocks! She already knew this was going to be the best dream ever!  Then she heard something, it was a sound coming from the bushes. “Who is there? "she said. Then Emma saw a gentle fairy come out from the bushes. She had sprinkles on her hair, she had a nice frilly pink sprinkled dress, and had pink shoes to match her outfit “Sorry for interrupting,” the fairy said. “That is okay,” said Emma. ”Well I was wondering if you could help me get to the candy wizard, because you seem very brave,” said the fairy. “The candy wizard?” said Emma, confused. “Yes the candy wizard!” The fairy said, ”let me explain who he is first. ”He is the wizard that created us the citizens of ca...
Read more

Hybris/ SAP commerce Cloud: Retry failed/not sent emails due to SMTP connection issue.

  1. Add Configuration in Local.properties file. email.retry.attempts = 5 #in milliseconds 300000 ms = 5 minutes email.retry.interval = 300000 2. Add  " retryAttempts" attribute in EmailMessage item < itemtype code ="EmailMessage" generate ="false" autocreate ="false" > < attributes > < attribute type ="java.lang.Integer" qualifier ="retryAttempts" > < persistence type ="property" /> < modifiers unique ="false" optional ="false" read ="true" write ="true" search ="true" /> < defaultvalue > 0 </ defaultvalue > </ attribute > </ attributes > </ itemtype > 3. Extends OOB  DefaultEmailService and override send( EmailMessageModel message) method @Service ( "testDefaultEmailService" ) public class TestDefaultEmailService extends DefaultEmailService { @Reso...
Read more