Jump to content

Brian J. Stewart

Members
  • Posts

    27
  • Joined

  • Last visited

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

Brian J. Stewart's Achievements

Apprentice

Apprentice (3/14)

  • Conversation Starter
  • First Post
  • Collaborator Rare

Recent Badges

0

Reputation

  1. Thanks Steve, updated yours to the following to find non-USA books I owned without any hassles. ((ComicTitles.CountryCode IS NOT 'US') AND (I.QtyInStock > 0))
  2. I took a few stabs but never got anything to work in advanced, especially since I couldn't get a basic portion to work int he standard find. FIND SERIES where COUNTRY CODE is or not "WHATEVER". The title edit field for a series shows publisher country as "United States [image of flag]" but I can't make it work in search. Tried US, USA, United State, MERICA, etc. The below generic using "is not" and "list only my issues in stock" returns all my titles, if I say *is* for exact match I get nothing. Looking for some working examples to make this work, so that I can then use advanced query to do similar fancier things.
  3. Yeah... build 2073 finally remembers my window position, including how i have it semi-centered (not fullscreen) on my 2nd vertical monitor layout. Forever it has been just re-opening however it felt like after i close out CB, most of the time starting up in a weird position spanning my 2nd and 3rd monitors.
  4. I saw a bagged issue at my store last week but did not pick it up. It looked exactly like this one https://www.ebay.com/itm/204153054927
  5. I should have been more specific. Since around 11/9 (Wed) my messages to support@comicbase.com are going out initially, but then I get that undeliverable alert from gmail the next day, it is not instant, at least 12+ hours after the send. I'll just keep firing out my usual feed of messages, but not sure anyone is getting anything especially since I have not had any replies since around the 9th either.
  6. I've been getting bounce backs for the last 2 days trying to send to support@comicbase.com -- anyone else? This is what my gmail web client message says: There was a temporary problem delivering your message to support@comicbase.com. Gmail will retry for 21 more hours. You'll be notified if the delivery fails permanently.
  7. Hmm, i just tried (DATE(I.DateModified) >= '2022-10-21' AND (I.QtyInStock > 0)) And this did show me issues that I own, that had been modified since Oct 21 unfortunately this field appears to be shared with the weekly content updates. I was hoping for a I.UserDateModified, so that I could specifically find issues I had altered myself.
  8. Is there a data column something like "last edited by user", something to indiciate that I have personally modified an issue's row of data? Use cases: 1. Build a list of titles/issues added into inventory for 2022. 2. When you notice your inventory count is off, because you have been adding new series and books into the system that were missing but forgot to set QTY 0 before you were done, and now can't figure out where those books are hiding in your collection. query possibly similar to: (I.LAST_USER_EDIT BETWEEN '2022-01-01' AND '2022-12-31')
  9. Is there a published changelog showing what was fixed/added during the interium build releases for CB23? I've reported bugs, etc and I usually review those on other products to see if something has been fixed, or a new function has been added.
  10. CB23 is much faster for me, however I do notice that my comiccon laptop which pointed to a network drive for all the cover picture/thumbnails is noticeably slower than my desktop rig. I blame that on network latency, but my laptop is still much faster on the new 64-bit than older versions. This tweak is based on your choice for personal security, but I did go into my antivirus (Windows Security/Defender) advanced settings and mark my PICTURES and THUMBNAILS folders as 100% excluded from anti-virus. I noticed a speed-up on my laptop a bit after this.
  11. Worked great Steven, I just added a ORDER BY I.Title ASC. Came back with less than 1000 books which kind of surprised me, but I think is accurate. I can then tweak this further later on to eliminate items marked for-sale already, or my items set with reserve quanity protection. ---BRIAN
  12. Thanks Steve. MinimumQty did work to find the "Reserve Quantity" field. I am using that to help find my dupes, that have not yet been broken out for-sale. #using this advanced query (I.[ForSale] IS False) AND (I.QtyInStock > 1) AND (I.[Marked] IS True) AND (I.MinimumQty < 1) I.QtyInStock DESC,I.Title ASC This gives me a rough-and-dirty list of duplicate issues I have not flagged for sale. I then duplicate the found item showing QTY 2+ Now I mark the new item with the exact QTY I want for sale, so that it is kept in a separate row in my database. then the original row gets updated to lower quantity (my keeper copies) and I also set the "Reserve Quantity" to the same value. My extra safe-guard to not sell these, when i run some safety queries later. I do realize I could just flag the whole issue as for-sale, and then use the reserve quantity for sale --- but I tend to err on the side of caution to ensure I don't sell books by mistake. And this query does not help when I have (6) copies of a single book in varying grades, a good place for me to start. I'll have to scour the forums for some adv.find examples to help me find those where ISSUE has QTY > 1 spanning multiple grades later. ---BRIAN
  13. I did some casual searching but could not find a list of all the fields used in the database. Has data dictionary been published somewhere listing all the item/title field names and date types? I got here trying to find the "Reserve Quantity" field. I made educated guess for I.ReserveQuantity and I.ReserveQty but the adv.find did like them.
  14. You can blame ASOMBRO on me, as I put in the request to fix the title name. I figured (errr assumed) the weekly updater would have some magic flag for renamed titles and auto-magically resolve. I guess not. Dear CB techies, can this be done? If a title gets renamed, or anything that impacts the folder path a flag be set so the updater can do that work and solve all these file dir naming issues?
  15. If this was implemented the interface would have to allow you to define your home language/country (English or just United States), that way the definition of foreign could be applied properly. Or maybe a checklist of languages you only want, or not want; whitelist vs. blacklist mentality.
×
×
  • Create New...