Searching in binders

[swallowtail]

Is there a list of keywords that the database can be queried on?

There used to be but got lost due to the old wiki being spammed and me missing the entry when I moved contents here. I will compile it again, just keep nagging me if it takes too long. $x.expansion.code will fix you query.

Thanks Piotr. When I try this:

SUBQUERY ( binderentries, $x, $x.binder.name = 'My Precious' and $x.count < 4 and $x.expansion.code = 'rtr' ).@count > 0

iMTG crashes. Have I got wrong syntax in that somewhere?

This question has been missed, can you please advise where this is incorrect?

[Piotr]

Is there a list of keywords that the database can be queried on?

There used to be but got lost due to the old wiki being spammed and me missing the entry when I moved contents here. I will compile it again, just keep nagging me if it takes too long. $x.expansion.code will fix you query.

Thanks Piotr. When I try this:

SUBQUERY ( binderentries, $x, $x.binder.name = 'My Precious' and $x.count < 4 and $x.expansion.code = 'rtr' ).@count > 0

iMTG crashes. Have I got wrong syntax in that somewhere?

This question has been missed, can you please advise where this is incorrect?

Binder entries link to expansion via card print, so you should have $x.cardprint.expansion.code = 'rtr'

I have compiled some basic info about Predicate and the tables structure:

http://imtgapp.com/forum/index.php?topic=21080.0

It would be great is you guys expand the Wiki entry with some examples, please

[Raven316]

Is there a list of keywords that the database can be queried on?

There used to be but got lost due to the old wiki being spammed and me missing the entry when I moved contents here. I will compile it again, just keep nagging me if it takes too long. $x.expansion.code will fix you query.

Thanks Piotr. When I try this:

SUBQUERY ( binderentries, $x, $x.binder.name = 'My Precious' and $x.count < 4 and $x.expansion.code = 'rtr' ).@count > 0

iMTG crashes. Have I got wrong syntax in that somewhere?

This question has been missed, can you please advise where this is incorrect?

Binder entries link to expansion via card print, so you should have $x.cardprint.expansion.code = 'rtr'

I have compiled some basic info about Predicate and the tables structure:

http://imtgapp.com/forum/index.php?topic=21080.0

It would be great is you guys expand the Wiki entry with some examples, please

Is it possible to make the Predicate more of a clicking feature instead of a typing one? Just wondering

[Piotr]

Yes but resources are scarce

[Raven316]

Ok thanks

[swallowtail]

Is there a list of keywords that the database can be queried on?

There used to be but got lost due to the old wiki being spammed and me missing the entry when I moved contents here. I will compile it again, just keep nagging me if it takes too long. $x.expansion.code will fix you query.

Thanks Piotr. When I try this:

SUBQUERY ( binderentries, $x, $x.binder.name = 'My Precious' and $x.count < 4 and $x.expansion.code = 'rtr' ).@count > 0

iMTG crashes. Have I got wrong syntax in that somewhere?

This question has been missed, can you please advise where this is incorrect?

Binder entries link to expansion via card print, so you should have $x.cardprint.expansion.code = 'rtr'

I have compiled some basic info about Predicate and the tables structure:

http://imtgapp.com/forum/index.php?topic=21080.0

It would be great is you guys expand the Wiki entry with some examples, please

Thanks Piotr, I'll do some experimenting...

[reezel]

Is there a way to ignore the other half of a split card when determining counts of cards?

[Piotr]

Have only one part in your binder.

[reezel]

Here's the query I am running. I have my bookmark set to only the expansions I am collecting in. The problem is I am seeing all the 2nd part of the double sided cards or split cards in the list. I tried going into them and setting their totals to the same as the totals I have of the main part, but the totals in the binders appears to be already set. Is there a way I can modify this query to simple exclude the second part cards?

SUBQUERY ( binderentries, $x, $x.binder.type = 0 and $x.count < 4 ).@count > 0 OR SUBQUERY( binderentries, $x, $x.binder.type = 0 ).@count = 0

[Piotr]

( ... ) and cardprint.card.part <> 'b'

[reezel]

( ... ) and cardprint.card.part <> 'b'

That crashes me to the home screen. I tried just using the query "cardprint.card.part <> 'b'" and that crashes it as well.

[Flashley_ska]

Hi there. trying to figure out how to do a "reprints only" filter.
I guessed piping the card.aename back into a subquery of card and getting the results where count is more than one would be the way to go?
For that i tried:
SUBQUERY( card, $x, $x.aename = card.aename ).@count > 1
The good news is that this doesn't crash the app, and the bad is it returns no results... please could you help?

[Piotr]

Hi there. trying to figure out how to do a "reprints only" filter.
I guessed piping the card.aename back into a subquery of card and getting the results where count is more than one would be the way to go?
For that i tried:
SUBQUERY( card, $x, $x.aename = card.aename ).@count > 1
The good news is that this doesn't crash the app, and the bad is it returns no results... please could you help?

Try name instead of aename?

[Flashley_ska]

Thanks for quick reply!

Unfortunately thats not doing it either. do i need to pass it in as a parameter or variable somehow? im a bit clueless to the syntax.

Thanks again for any advice!

[Flashley_ska]

Still bashing away at this but nothing seems to work. Most other efforts fail and crash the app.
All subqueries on card print error this way.
Any ideas anyone?