Flexi Query Date format for SAP Hybris for Microsoft SQL database


 MSSQL: 

FORMAT({date} ,'date Pattern' )

e.g. FORMAT({ct.creationtime} ,'MM/dd/yyyy' )

Query:

select {ct.code} as CartID, FORMAT({ct.creationtime} ,'MM/dd/yyyy' ) as CreationDate , {cr.isocode} as currency from {cart as ct  JOIN Currency as cr ON {ct.currency}={cr.pk}} where {ct.totalprice} > 0.001 

Comments

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