Re: Summary view: View only most recent entry for all values of a given attribute?, posted by Stefan Ritt on Thu May 17 14:02:39 2007 
|
| Dennis Seitz wrote: | | I would like to filter the summary view so it only shows me the most recent entry for every value in the serial number attribute. This would be very useful for quickly viewing the present status and location of every assembly, for example. |
I don't know if that is what you want, but have you tried clicking on the column headings in the summary view to sort the table according to that attribute:
 |
|
Re: Summary view: View only most recent entry for all values of a given attribute?, posted by Dennis Seitz on Fri May 18 02:15:41 2007
|
| Stefan Ritt wrote: |
| Dennis Seitz wrote: | | I would like to filter the summary view so it only shows me the most recent entry for every value in the serial number attribute. This would be very useful for quickly viewing the present status and location of every assembly, for example. |
I don't know if that is what you want, but have you tried clicking on the column headings in the summary view to sort the table according to that attribute:
|
Rather than simply sorting, I would like to actually reduce the number of entries listed to show only the most recent entry for each serial number. In this way, I can see at a glance what the present status of each serial number is. This is similar to Quick Filters but would be a "Most Recent" filter that could be applied conditionally, for example: "Most Recent" -> "By Serial".
Here is the display now:
Here is what I'd like to have the option to view (I used a graphic editor to fake it):
It would also be nice to have the option to then sort the resultant view, for example, to group together all serial numbers that have the same status.
Is this a little clearer? It's just a suggestion - this is not terribly important, but if it were possible I think it would be useful.
Thanks! |
|
Re: Summary view: View only most recent entry for all values of a given attribute?, posted by Stefan Ritt on Fri May 18 08:04:38 2007
|
Ok, now I understand. Well, your request is very special for your case. Usually I implement things only if several independent people ask for it. What you can try is to save your logbook in CSV format, import it into Excel or another spreadsheet program, and achieve the filtering there.
Best regards,
Stefan |
|
Re: Summary view: View only most recent entry for all values of a given attribute?, posted by Dennis Seitz on Fri May 18 16:07:31 2007
|
| Stefan Ritt wrote: | Ok, now I understand. Well, your request is very special for your case. Usually I implement things only if several independent people ask for it. What you can try is to save your logbook in CSV format, import it into Excel or another spreadsheet program, and achieve the filtering there.
Best regards,
Stefan |
OK, I've done that before and it works fine. I'd rather be able to do it in Elog but I understand if it's not worth the effort. It never hurts to ask!
Cheers,
Dennis |
, posted by on Sat Oct 6 14:05:01 2007
|
I ended with 125384 entries like the one above.
Everything works fine but ......... [U]tteerrrriibbllee[/U] [B]slow[/B]. CPU usage is constant at 99%.
I tried to split the one file produced by the import into 2 chunks but that did not improve the situation.
My question is : Is there a rule of thumb for the size of the "database" in which elog keeps it's performance, or better : is there a solution for this for elog.
|
how to use the find calendar, posted by Arno Teunisse on Sat Oct 6 16:47:44 2007
|
Hello
In the find page you use a calendar popup from which the user can click on a date and the date boxes are filled in with the correct date. Can I use that calendar also? If so, can you show me an example of it's usage. |
|
Re: how to use the find calendar, posted by Arno Teunisse on Sat Oct 6 17:15:59 2007
|
| Arno Teunisse wrote: | Hello
In the find page you use a calendar popup from which the user can click on a date and the date boxes are filled in with the correct date. Can I use that calendar also? If so, can you show me an example of it's usage.
I found it , Sorry for the question, ( RTFM ) Read The Fucking Manual )
|
|
Audit Trail?, posted by Javier A. Ortiz on Fri Jan 18 13:57:31 2008
|
First thanks for the great software! My only question would be how to implement audit trail feature. I know you can control who edits and that's great but in regulated environments like mine there's a requirement that the original record, the one edited, is not deleted or overwritten. If not possible right now the only thing I could think of is a mechanism, maybe possible thru configuration, that when the record is edited it is copied to an audit trail logbook (i.e. if logbook name is 'test' it's audit logbook will be named 'test-audit' which is read only) and have a link to the audit trail of the record (show only changes of the current record).
I'm more than aware that it's possible thru configuration but I'm short on that dept. Any help/idea?
Thanks in advance! |