* Running queries from code or another query

[SpencerDudeUK]

I've utilised a very useful piece of code to establish whether someone has a census entry:

Exclude if %INDI.CENS[year=1841]% is null.

I've created something like this for each census, and the result looks like the picture attached.

Picture1.jpg (8.11 KiB) Viewed 3030 times

However, what I would really like to do is run them all together, as opposed to having to open each one and set flag on row records - is this possible - either by combining the queries into one big query, or developing code to run each query in turn?

[Jane]

Why don't you simply use the Expression in the Diagram rather than setting a flag first?

On the Box tab add an Expression and put

%INDI.CENS[year=1841]%

in and then set your icon preferences.

[SpencerDudeUK]

Brilliant! Thanks - that will solve all the questions
Thanks very much for the help - prompt reply. I'm always amazed how quickly this forum helps you with questions

[tatewise]

Checkout how_to:using_flags_and_icons_and_expressions|> Using Flags and Icons and Expressions that explains the principles and provides worked examples including your Census case.

[Gowermick]

As Miketate says, this has been brought up before, and someone has even done the hard work for you, as there are some sets of icons available in fhugdownloads:diagramicons|> Downloads and Links ~ Diagram Icons for you to download.