[Vtigercrm-developers] Access to "Create time" & "Modify time"

Asha asha at vtiger.com
Mon May 11 02:55:32 PDT 2009


Hi Stephen,

Things look fine the way you are trying to consume modified time. Let me
also clarify that, the created time and modified time are stored in
vtiger_crmentity table.

On 4/29/09, Stephen Mack <stephen at efronteras.com> wrote:
>
> Just to close the loop, here is everything
>
> 1) Call the built-in function in data\CRMEntity.php
>
>
> retrieve_entity_info($_REQUEST['record'],"Quotes")
>
>
> 2) The information is now stored in the variable $column_fields
>
> $focus->column_fields["modifiedtime"]
>
> 3) Format the output.  You need to convert the string to an integer
> and format it as you like.
>
> date("d M Y", strtotime($focus->column_fields["modifiedtime"]))
>
> If I'm wrong someone can correct me please.
>
>
> -- Stephen Mack
> Gerente de Ventas y Marketing
> Escuela Fronteras
> www.eFronteras.com
> skype: eFronteras.Stephen
>
>
>
>
> On Wed, Apr 29, 2009 at 11:52 AM, Stephen Mack <stephen at efronteras.com>
> wrote:
> > Hi everyone and Sebastian,
> >
> > Ok I also found out that the function...
> > retrieve_entity_info($_REQUEST['record'],"Quotes");
> >
> > ...also retrieves the information.  It's accessible in the
> > column_fields variable.
> >
> > $modified_date = $focus->column_fields["modifiedtime"];
> >
> > -- Stephen Mack
> > Gerente de Ventas y Marketing
> > Escuela Fronteras
> > www.eFronteras.com
> > skype: eFronteras.Stephen
> >
> >
> >
> > On Wed, Apr 29, 2009 at 11:33 AM, Stephen Mack <stephen at efronteras.com>
> wrote:
> >> Hummm... can someone confirm that this is the information is correct.
> >> I think it is...
> >>
> >> SELECT *
> >> FROM  `vtiger_quotes`
> >> LEFT JOIN  `vtiger_crmentity` ON  `quoteid` =  `crmid`
> >> WHERE 1
> >>
> >> -- Stephen Mack
> >> Gerente de Ventas y Marketing
> >> Escuela Fronteras
> >> www.eFronteras.com
> >> skype: eFronteras.Stephen
> >>
> >>
> >>
> >> On Wed, Apr 29, 2009 at 11:15 AM, Stephen Mack <stephen at efronteras.com>
> wrote:
> >>> It seems like I should have figured this out already... :(
> >>>
> >>> I would like to use the "Modify Time" from a quote on the PDF.  I
> >>> can't find where the "Create time" & "Modify time" are stored for a
> >>> quote.
> >>>
> >>> -- Stephen Mack
> >>> Gerente de Ventas y Marketing
> >>> Escuela Fronteras
> >>> www.eFronteras.com
> >>> skype: eFronteras.Stephen
> >>>
> >>
> >
>
> _______________________________________________
> Reach hundreds of potential candidates - http://jobs.vtiger.com
>



-- 
Regards,
Asha
vtiger Team
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20090511/2b3dbf52/attachment-0003.html 


More information about the vtigercrm-developers mailing list