Welcome, Guest
Try to get help from other ComicRack users

TOPIC: Smartlist to only have last issue of series that i have

Smartlist to only have last issue of series that i have 2 years 8 months ago #41998

  • Hagi
  • Hagi's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 5
  • Karma: 0
I apologize in advanced if this has been answered as I could not find the answer while i was searching.

I'm trying to create a smartlist which only contains the last issue I have of a series. For example, if I want to do this with "Batman and Robin" which only contains 40 issues to date, I want the smartlist to only contain the 40th issue until the 41st is released and I add that to the library.

Any assistance would be greatly appreciated.

Thanks
The administrator has disabled public write access.

Smartlist to only have last issue of series that i have 2 years 8 months ago #42006

  • jkthemac
  • jkthemac's Avatar
  • Offline
  • Platinum Boarder
  • Posts: 767
  • Thank you received: 253
  • Karma: 55
Name "Last Batman and Robin"
Match All
{
    [Number] equals "{StatsLastNumber}",
    [Series] equals "Batman and Robin",
    [Volume] equals "2011"
}

As usual, copy the text of the above query, right click the Temporary Lists folder in your library and paste it there.

BTW the best way to find the less obvious elememts of a query is to use the Query button within the smart list editor. If you then right click on the query you can select matches or values from a long list.
Last Edit: 2 years 8 months ago by jkthemac.
The administrator has disabled public write access.
The following user(s) said Thank You: boshuda, Hagi

Smartlist to only have last issue of series that i have 2 years 8 months ago #42007

  • jkthemac
  • jkthemac's Avatar
  • Offline
  • Platinum Boarder
  • Posts: 767
  • Thank you received: 253
  • Karma: 55
To pre-empt the next logical but slightly trickier question "How do I list the last 5 issues?":

Name "Last 5 Batman and Robin"
Match All
{
    [Expression] is true "int({Number})>=int({StatsLastNumber})-4",
    [Series] equals "Batman and Robin",
    [Volume] equals "2011"
}
Last Edit: 2 years 8 months ago by jkthemac.
The administrator has disabled public write access.
The following user(s) said Thank You: Hagi

Smartlist to only have last issue of series that i have 2 years 8 months ago #42013

  • Hagi
  • Hagi's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 5
  • Karma: 0
Thank you, exactly what I'm looking for. This actually answers my next question of how do i find the list of variables I can use.

Not sure how I never noticed the query button before, I kept using designer mode and trying to use * as wildcards (which never worked).

Thanks again
The administrator has disabled public write access.

Smartlist to only have last issue of series that i have 2 years 8 months ago #42016

  • jkthemac
  • jkthemac's Avatar
  • Offline
  • Platinum Boarder
  • Posts: 767
  • Thank you received: 253
  • Karma: 55
If you are trying out wildcards you might want to look at my Comicrack Regex Tutorial.
The administrator has disabled public write access.
The following user(s) said Thank You: Hagi

Smartlist to only have last issue of series that i have 2 years 8 months ago #42022

  • boshuda
  • boshuda's Avatar
  • Offline
  • Gold Boarder
  • Posts: 296
  • Thank you received: 65
  • Karma: 8
jkthemac wrote:
Name "Last Batman and Robin"
Match All
{
    [Number] equals "{StatsLastNumber}",
    [Series] equals "Batman and Robin",
    [Volume] equals "2011"
}

As usual, copy the text of the above query, right click the Temporary Lists folder in your library and paste it there.

BTW the best way to find the less obvious elememts of a query is to use the Query button within the smart list editor. If you then right click on the query you can select matches or values from a long list.
Holy! I never knew about the right-click in the query window thing. You should really add some stuff to the wiki concerning smart lists.
The administrator has disabled public write access.

Smartlist to only have last issue of series that i have 2 years 8 months ago #42029

  • jkthemac
  • jkthemac's Avatar
  • Offline
  • Platinum Boarder
  • Posts: 767
  • Thank you received: 253
  • Karma: 55
This topic made me think again about using the release date info in smartlists and I have finally cracked it. I put a post in the Scripts forum detailing how to use it to get the last 6 months of a volume and other tips.
Last Edit: 2 years 8 months ago by jkthemac.
The administrator has disabled public write access.
Time to create page: 0.183 seconds

Who's Online

We have 274 guests and one member online