Can Wiki+ find my watchlist profiles that need a cemetery category added? [closed]

Question

Is there a way to find the profiles on my watchlist that have a FG link, but no cemetery category in the profile?  Have tried a few word combos and the closest I have come is using my ID along with FindAGrave, which looks to be listing all the profiles that have a FG memorial link and I can go down the right side column looking for ones that lack a cemetery category, but the list is 710 long, so wondering if there is a word combo that can get me a list of just the profiles with no cemetery category.  

If not I can continue with searching down the right column, but have become spoiled, with all the handy stuff WT has created for making work easier and quicker.

Answer 1

I think your textsearch string should look something like this, but it's not working for me:

Manager=Roche-395 sql="[Category / Template] not like '*Cemetery*'"

Alternatively, you could pull everything that HAS a cemetery category (413 profiles, great work!):

Manager=Roche-395 CategoryWord="Cemetery"

and compare that to your full watchlist and work the rest

Comments

Thanks.  I tried tweaking your text recommendation and  could not come up with any results either.  But thank you for finding that I only have a cemetery category on 413 profiles so now know that I have 297 to fix.  Will keep me busy for awhile as the most common reason, I did not include the category was because there was not one yet. Will be getting lots of  practice creating categories -

---

Maybe this works:

Manager="Roche-395" Template="FindAGrave" not subcat9=Cemeteries

---

Hooray! Yes it works - thank you so much Joke.  This will be much easier than visually searching for the missing category.

Thank you, Jonathan and Joke for making this task a bit easier.

---

There is no [Category / Template] field to use with SQL query. I would advise against using SQL unless it is really needed.

In case a URL is used instead of template, query should be:

Manager="Roche-395" domain="FindAGrave.com" not subcat9=Cemeteries

You can also combine them to 

Manager="Roche-395" Template="FindAGrave" not subcat9=Cemeteries or Manager="Roche-395" domain="FindAGrave.com" not subcat9=Cemeteries