Query Help

[Jasel17212]

Two questions:

Is there a shorthand way to write the following query?

ledger reg ^exp and expr "has_meta('tag1')" or ^exp and expr "has_meta('tag2')"

Is there a way to group the results of this query by tag?

ledger reg ^exp and expr "has_meta('tag1')" or ^exp and expr "has_meta('tag2')" --group-by ????

Thanks

JL

[federico lopez]

On Tue, Feb 7, 2023 at 5:18 PM Jasel17212 <ja...@thelittonfamily.com> wrote:

Two questions:

Is there a shorthand way to write the following query?

ledger reg ^exp and expr "has_meta('tag1')" or ^exp and expr "has_meta('tag2')"

Hi JL, 

Maybe just a little shorter:

reg ^exp and expr "(has_meta('tag1') or has_meta('tag2'))"

[John Wiegley]

>>>>> "J" == Jasel17212 <ja...@thelittonfamily.com> writes:

J> Is there a shorthand way to write the following query?

J> ledger reg ^exp and expr "has_meta('tag1')" or ^exp and expr
J> "has_meta('tag2')"

You may need to escape it from your shell, but this should do it:

ledger reg ^exp & (%tag1 | %tag2)

J> ledger reg ^exp and expr "has_meta('tag1')" or ^exp and expr
J> "has_meta('tag2')" --group-by ????

--group-by tag('tag1')

John

[Jasel17212]

John,

I'm using zsh so entered:

ledger reg ^exp and "(%tag1 | %tag2)" 

The results were for tag2 only. 

I used the group-by tag as follows:

ledger reg ^exp and expr "(has_meta('tag1') or has_meta('tag2'))" --group-by tag('tag1')

The results was:

zsh: missing delimiter for 'u' glob qualifier

Thoughts on either result?

[Randy Josleyn]

On 2/8/23 06:18, Jasel17212 wrote:
> Two questions:
>
> Is there a shorthand way to write the following query?
>
> ledger reg ^exp and expr "has_meta('tag1')" or ^exp and expr
> "has_meta('tag2')"

This seems to work for me:

ledger reg ^exp and expr "has_meta('tag1') | has_meta('tag2')"

Sorry I don't have an answer to the second question. —Randy

[John Wiegley]

>>>>> "J" == Jasel17212 <ja...@thelittonfamily.com> writes:

J> I'm using zsh so entered:

J> ledger reg ^exp and "(%tag1 | %tag2)" 

Sadly, it has to be more separated than this:


ledger reg ^exp and '(%tag1' '|' '%tag2)'

It's a bug to me that the query parser interprets "(%tag1 | %tag2)"  as if you
had written "(%tag1 |" "%tag2)".

John

[Jasel17212]

Thanks John!