fromEmail can not be retrieved from flexi search !

[Former Member]

hi experts, can you please tell me why the fromEmail ATTRIBUTE can not be retrieved by the ** Select from {EmailPage} but Select {fromEmail} from {EmailPage} this works..

can you suggest why?

[Former Member · Accepted solution]

Hi Bikramjit,

After checking the SQL Query for both of these I noticed some differences in table names.

 SELECT * FROM {EmailPage} =>
 SELECT * FROM cmspage item_t0 WHERE (item_t0.TypePkString=? )
     
 SELECT {fromEmail} FROM {EmailPage} => 
 SELECT  lp_t0.p_fromemail  FROM cmspagelp lp_t0 WHERE ((lp_t0.LANGPK =? )) AND (lp_t0.ITEMTYPEPK=? )

As you can see the tables in those queries are different (cmspage <> cmspagelp). If you display the second table (SQL: SELECT * FROM cmspagelp) and search for rows with @ you can see that the values are there. Unfortunately I don't know what's the cause of such behavior.

Hope this helps, and Best Regards,

[VinayKumarS]

I dont think fromEmail and toEmail is not saved in database. It will be given in properties file and configured retrieved from the code. It will not be saved in the database by default.

[Former Member]

From EmailPage xml representation it look like these attributes are stored in database but for some reason they are stored in different table.

  <itemtype code="EmailPage" extends="DocumentPage" jaloclass="de.hybris.platform.acceleratorservices.jalo.cms2.pages.EmailPage" generate="true" singleton="false" jaloonly="false" metatype="CMSPageType" autocreate="true">
         <attributes>
             <attribute generate="true" autocreate="true" qualifier="fromEmail" type="localized:java.lang.String">
                 <persistence type="property" qualifier=""/>
                 <modifiers read="true" write="true" search="true" encrypted="false" optional="true" removable="true" initial="false" unique="false" private="false" partof="false"/>
             </attribute>
             <attribute generate="true" autocreate="true" qualifier="fromName" type="localized:java.lang.String">
                 <persistence type="property" qualifier=""/>
                 <modifiers read="true" write="true" search="true" encrypted="false" optional="true" removable="true" initial="false" unique="false" private="false" partof="false"/>
             </attribute>
         </attributes>
     </itemtype>

[VinayKumarS]

yes i am able to see fromemail using Select {fromEmail} from {EmailPage} query. But in my application this value is maintained in properties file.