Usergroup: Customer
Joined: Apr 03, 2007
Total Topics: 39
Total Posts: 157
Posted 10/20/07 - 10:17 PM:
#1
Does anyone have a suggestion on how I can possibly create a printable report of all links in all categories, or even all links added since xx/xx/xxxx?
Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 56
Total Posts: 5853
Posted 10/21/07 - 09:55 PM:
#2
Make a toplist in a custom template. Call the page with usewrapper=no to suppress the wrapper.
Added since a date would tricky, but added in the last X days would just be the toplist condition time > UNIX_TIMESTAMP() - (86400 * X)
_____________________
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat
Usergroup: Customer
Joined: Apr 03, 2007
Total Topics: 39
Total Posts: 157
Posted 10/22/07 - 08:23 PM:
#3
Great thanks! I was able to create this page as you said, but I can't get the toplist to work the way I need it to.
This is what the generator gave me <CONFIG>links,catid;title,50000,ascending;ascendin g,time > (UNIX_TIMESTAMP() - 86400*365),,6,0,0,0,,0,1,</CONFIG>
My first problem is that I tried adding type='regular' to the expression so that only regular categories are included, but it would not load when I did that. Instead I got a sql error. Let me know if you need to know what kind of error and I will recreate it.
My second problem is that in the toplist generator I told it that I wanted to sort by catid first and then title. Is there anyway, instead to sort by catname? It's not one of the choices listed in the toplist generator.
Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 56
Total Posts: 5853
Posted 10/23/07 - 10:48 AM:
#4
To make it regular links, the condition would be time > (UNIX_TIMESTAMP() - 86400*365) AND type='regular'
There's no way to sort by category name.
_____________________
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat
Usergroup: Customer
Joined: Apr 03, 2007
Total Topics: 39
Total Posts: 157
Posted 10/23/07 - 11:52 AM:
#5
Thanks, I was missing the "AND". It works now.
Shame I can't sort by catname, in which case is there some other field I could possibly use or create so that the links will sort by the categories alphabetically first? I know that the bulk edit page gives me an "order" field, if I number the categories using whatever that field is would I be able to sort by that? And will that then affect the way the rest of the site is laid out?
Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 56
Total Posts: 5853
Posted 10/24/07 - 06:49 AM:
#6
The priority (sort order) field isn't available to links either, only categories. There are no link fields that have anything about the category except the id number.
_____________________
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat
Print
Printable reports