Hi,

We've defined a "LastEdit" attribute for some of our logs so that we can indicate that an entry has been revised, and when that was done. 

From our config:

Attributes =  Last Edit, etc etc
.
.
.
Preset Last Edit =$date
Locked Attributes = Last Edit
Subst on edit Last Edit = $date

This works fine, but when we sort the LastEdit column, the dates are sorted alphabetically. Is there a way to tell Elog to treat this particular attribute 
as a date when sorting?

> Hi,
> 
> We've defined a "LastEdit" attribute for some of our logs so that we can indicate that an entry has been revised, and when that was done. 
> 
> From our config:
> 
> Attributes =  Last Edit, etc etc
> .
> .
> .
> Preset Last Edit =$date
> Locked Attributes = Last Edit
> Subst on edit Last Edit = $date
> 
> This works fine, but when we sort the LastEdit column, the dates are sorted alphabetically. 
> Is there a way to tell Elog to treat this particular attribute as a date when sorting?

You are missing:

Type Last Edit = datetime

which will tread the "Last Edit" attribute as a date/time combination. Actually it's stored 
internally in seconds since Jan 1st 1970, so sorting will work right. The only caveat is that
when you edit an entry, the "Last Edit" is displayed really in seconds since 1970, but I will
fix this in the next release.

> The only caveat is that
> when you edit an entry, the "Last Edit" is displayed really in seconds since 1970, but I will
> fix this in the next release.

I just fixed this in SVN revision #2010. If you would have filled out which operating system you use
with elog, I could tell you how to upgrade.

> > The only caveat is that
> > when you edit an entry, the "Last Edit" is displayed really in seconds since 1970, but I will
> > fix this in the next release.
> 
> I just fixed this in SVN revision #2010. If you would have filled out which operating system you use
> with elog, I could tell you how to upgrade.

Thanks for the help and the bug fix. I have a colleague who keeps our installation up to date, so I'll ask him to install it.

> > The only caveat is that
> > when you edit an entry, the "Last Edit" is displayed really in seconds since 1970, but I will
> > fix this in the next release.
> 
> I just fixed this in SVN revision #2010. If you would have filled out which operating system you use
> with elog, I could tell you how to upgrade.

Thank you for pointing out the method to identify Last Edit as a datetime type so that it will sort properly. I now have created Last Edit in several 
preexisting logbooks. 

I want to use 
Start page = ?rsort=Last Edit
to set the default sorting of each logbook to be by Last Edit. 

However, all of the entries made before I added Last Edit have no value for that field, so they are all grouped together at the end of the sort. So I 
decided to go through the older entries and set Last Edit equal to the original entry date, as a starting value.

I tried to use the command
Subst on edit Last Edit = $entry time
but it gives a "-" for the Last Edit value when I edit an entry. 

I think this is because $entry time is not a variable supported by Subst. Can you add that support, or else tell me if you know a better way to go about 
doing what I'm attempting? Is there perhaps a way to globally process a group of entries in a logbook and set one attribute's value to be equal to 
another's?

Thanks

> I tried to use the command
> Subst on edit Last Edit = $entry time
> but it gives a "-" for the Last Edit value when I edit an entry. 
> 
> I think this is because $entry time is not a variable supported by Subst. Can you add that support, or else tell me if you know a better way to go about 
> doing what I'm attempting? Is there perhaps a way to globally process a group of entries in a logbook and set one attribute's value to be equal to 
> another's?

I tried to reproduce what you said and it worked fine for me. I used:

[demo]
Attributes = Author, Type, Last Edit, Subject
Subst on edit Last Edit = $entry time

And got correctly the entry time copied to the "last edit" field when I changed old entries. I used version V.7.3-2104.

Hello,

one idea for improvement. When using the option 'Icon comment' this comment is shown when creating a new entry and moving with he mouse over the icon but it is not displayed in full or summary view. In full or summary view the filename is shown. Not really important, but perhaps an improvement.

Thanks!

Uwe

I implemented this request in SVN revision #1974.