Jump to content

Advanced Searches


Recommended Posts

Hi folks!  

During today's Livestream, Pete suggested that we set up a dedicated thread here in the forum for people to post their syntax etc. for Advanced Searches that they do.  I've pinned the thread so it should be easy to find.  

I confess, I have not done much with Advanced Search b/c I don't know the syntax.  But if I knew the syntax, then I feel confident that I can readily do things with it.  I would not be surprised if there are other CB users in the same or similar boat.  Does anybody have a link to a simple, straightforward document listing out the basics for Advanced Search syntax etc?  

Link to post
Share on other sites
  • 2 weeks later...

So, I use Custom Date 1 for "date entered", (which OBTW it has always seemed to me that it's peculiar that this is not a standard field). So after you get done scanning barcodes you go search for:
I.[CustomDate1] is null and I.[QtyInStock] > 0 

Then you do Edit, Select all,  Quick Change, Custom Date 1, (it will default to today), Make Changes.

Link to post
Share on other sites
  • 3 months later...

Find All My Owned With Cover Date For A Year (2017) & Sorted By Value
Items Where...
I.[CoverDate] >= "2017-01-01" and I.[CoverDate] <= "2017-12-31" and I.[QtyInStock] > 0
Order By
I.[Price] desc

Owned Platinum Age Comics & Sorted By Value
Items Where...
I.[CoverDate] > "1897-01-01" and I.[CoverDate] < "1938-03-31" and I.[QtyInStock] > 0
Order By
I.[Price] desc

Owned Golden Age Comics & Sorted By Value
Items Where...
I.[CoverDate] > "1938-04-01" and I.[CoverDate] < "1956-08-31" and I.[QtyInStock] > 0
Order By
I.[Price] desc

Owned Silver Age Comics & Sorted By Value
Items Where...
I.[CoverDate] > "1956-09-01" and I.[CoverDate] < "1969-12-31" and I.[QtyInStock] > 0
Order By
I.[Price] desc

Owned Bronze Age Comics & Sorted By Value
Items Where...
I.[CoverDate] > "1970-01-01" and I.[CoverDate] < "1984-12-31" and I.[QtyInStock] > 0
Order By
I.[Price] desc

Owned Modern Age Comics & Sorted By Value
Items Where...
I.[CoverDate] > "1985-01-01" and I.[CoverDate] < "2050-01-01" and I.[QtyInStock] > 0
Order By
I.[Price] desc

Owned Comics Of Low Value/Reading Value & Sorted By Value
Items Where...
I.[Price] < 2.00 and I.[QtyInStock] > 0
Order By
I.[Price] desc

Find Every Singled Annual Published By Marvel Comics & Sorted By Value
Items Where...
ComicTitles.Publisher = 'Marvel' AND [ItemNumber] LIKE 'Anl %'
Order By
I.[Price] desc

Find Every Singled None-Variant Comic Published in 2020 Who's Value At Least $50 Greater Than Original Cover Price & Sorted By 2020 Value
Items Where...
I.[CoverDate] >= "2020-01-01" and I.[CoverDate] <= "2020-12-31" and I.PRICE -I.[CoverPrice] > 50.00 and  I.[QtyInStock]>=0 and I.[ItemNumber] not like '%/%'
Order By
I.[ValueYear4] desc

Owned Comics That Have SUPERMAN...Starting Title & Sorted By Value
Items Where...
I.[Title] LIKE 'SUPERMAN%' and I.[QtyInStock] > 0
Order By
I.[Price] desc

Owned Comics SINCE 2000 That Have Had At Least A $20 Value Increase Over Previous Year & Sorted By Value
Items Where...
I.[CoverDate] >= "2000-01-01" and I.PRICE - I.[ValueYear3] > 20.00 and I.[QtyInStock] > 0
Order By
I.[Price] desc

  • Like 1
Link to post
Share on other sites
  • 4 weeks later...

I added a bunch of issues with the app, adding the current date, "1/7/21" in the Notes field.  After imported into ComicBase, searched for the issues in ComicBase order:

 

Comics with "1/7/21" in the Notes field, sorted in ComicBase order
Items Where...
I.[Notes] LIKE "%1/7/21%"
Order By
ComicTitles.AlphabetizedTitle, I.[ItemType], I.[IssueNum], I.[Variation], I.[Printing]

Link to post
Share on other sites
  • 7 months later...
On 8/19/2020 at 5:45 PM, Gregory Hecht said:

Does anybody have a link to a simple, straightforward document listing out the basics for Advanced Search syntax etc?  

While I see a lot of examples of saved searches, which does help, I'd like to restate Greg's original request for a resource that explains the basic syntax for the Advanced Search. Some of the fields are more intuitive as to how to search on them than others. I don't have a specific search that I'm trying to accomplish at the moment, but would like to have a sort of instruction manual for how to use the tool handy when the need arises.

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...