Ask Aleš (February 2024)

Question

It's time for a new session of "Ask Aleš - What Do You Want To Know About WikiTree Plus?"

See you on Wednesday, February 14, 2024, 9:00am EST aka 14:00 UTC. 

What questions do you have? You can ask by posting an answer below and your question will be answered on February 14. (It's OK if you don't watch live. The February video will remain on YouTube, like the January video.)

If you want to just watch, use this YouTube link.

Greg Clarke will be my co-host.

Answer 1

Thanks for last month's answer to my query about identifying profiles where there are two words in the location name.  It works well for deaths and births but I get no joy when I try to adapt it for a search for marriages:

marriagelocation="West Sussex" sql="[Default].[Marriage Location].AsString like '*West Sussex*'

Is there a way of getting at these profiles?

Thanks

Comments

Use [Marriage] instead of [Default]. There is also missing ending double quote in your query.

marriagelocation="West Sussex" sql="([Marriage].[Marriage Location].AsString like '*West Sussex*')"

---

Thanks Ales - that's terrific

Answer 2

Hey Aleš! Like Steven, I have questions about querying WT+. Here's a couple in that vein.
 

1. How could I search for all profiles managed by me and inside a category... and every sub-category (recursively all the way down)? For example, any profile I manage in Category: United States Armed Forces and all of its children.
    
2. Is there support in the sql="" syntax for the vanilla SQL "NOT LIKE"? E.g., sql="[Default].[AllCategories].[Default] NOT LIKE '*Quaker*' " I managed to get it to work by pulling the "NOT" to just after where the implied "AND" operator would be, but it's not super elegant.
    
3. Is there support for parentheses or another way to specify the evaluation order for items in OR criteria? E.g., (A OR B) AND C versus A OR (B AND C).

Answer 3

Is there a way to query my contributions list for all the profiles  that I edited this month or last month with a "Needs Profiles Created" category still showing now?

I am not the manager on most of these and they are not in my watchlist.