Transaction Filter: Empty Reports
Posted: Sun Sep 11, 2022 10:39 pm
Please note that in what follows…
..that CF stands for Custom Field.
..(has content) means that there is >=1 transaction somewhere that is populated.
SCENARIOS (v.1.5.20)++++++++++++++++++++++++++++++++++++++++++++++++++++++++++RESULTS
————————————-++++++++++++++++++++++++++++++++++++++++++++++++++++++++++—————
1: Transactions for specified PAYEE++++++++++++++++++++++++++++++++++++++++++++++Correctly populated report
2: Transactions for SAME specified PAYEE + CF (has Content)+++++++++++++++++++++++++EMPTY report
3: Blind search just for CF (has Content)++++++++++++++++++++++++++++++++++++++++++EMPTY report
*************************************************************************************************************************************************************
The next set of searches may have been related to the earlier Transaction/Number Field bug and is included as information only.
Whilst not resulting in a crash, pre v.1.5.20, they result as in “3” above.
*************************************************************************************************************************************************************
SCENARIOS (v.1.5.20)++++++++++++++++++++++++++++++++++++++++++++++++++++++++++RESULTS
————————————-+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++————-
4: Transaction for specified ACCOUNT/PAYEE + CF (has content DECIMAL) =<999.99+++++EMPTY report
5: Blind search for CF (has content DECIMAL)++++++++++++++++++++++++++++++++++++++EMPTY report
===========================================================================================================
The upshot of this is that for example, I cannot print out a list of say loyalty points where a CF is used to store these data.
Thanks to @whall3y who provided the following help, which was given as a partial answer, hence this submission…
“With 'String' type you can specify a regular expression, but with the other you need to specify an exact value.”
I hope this is useful.
Also…
Usability Query
=============
Example
————-
To be able to list, say, CF (Warrantee expiry dates) against a Notes search should be possible. (Notes could be a place to record an item Name/Model.)
Problem
————
How is it possible to perform a Blind search in Transaction Filter on a CF Date field against, say a given Payee?
It seems that there always appears to be a date in these fields that limits this.
Or have I missed something?
===============================================================================================================
Hope you can make sense of all this!
..that CF stands for Custom Field.
..(has content) means that there is >=1 transaction somewhere that is populated.
SCENARIOS (v.1.5.20)++++++++++++++++++++++++++++++++++++++++++++++++++++++++++RESULTS
————————————-++++++++++++++++++++++++++++++++++++++++++++++++++++++++++—————
1: Transactions for specified PAYEE++++++++++++++++++++++++++++++++++++++++++++++Correctly populated report
2: Transactions for SAME specified PAYEE + CF (has Content)+++++++++++++++++++++++++EMPTY report
3: Blind search just for CF (has Content)++++++++++++++++++++++++++++++++++++++++++EMPTY report
*************************************************************************************************************************************************************
The next set of searches may have been related to the earlier Transaction/Number Field bug and is included as information only.
Whilst not resulting in a crash, pre v.1.5.20, they result as in “3” above.
*************************************************************************************************************************************************************
SCENARIOS (v.1.5.20)++++++++++++++++++++++++++++++++++++++++++++++++++++++++++RESULTS
————————————-+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++————-
4: Transaction for specified ACCOUNT/PAYEE + CF (has content DECIMAL) =<999.99+++++EMPTY report
5: Blind search for CF (has content DECIMAL)++++++++++++++++++++++++++++++++++++++EMPTY report
===========================================================================================================
The upshot of this is that for example, I cannot print out a list of say loyalty points where a CF is used to store these data.
Thanks to @whall3y who provided the following help, which was given as a partial answer, hence this submission…
“With 'String' type you can specify a regular expression, but with the other you need to specify an exact value.”
I hope this is useful.
Also…
Usability Query
=============
Example
————-
To be able to list, say, CF (Warrantee expiry dates) against a Notes search should be possible. (Notes could be a place to record an item Name/Model.)
Problem
————
How is it possible to perform a Blind search in Transaction Filter on a CF Date field against, say a given Payee?
It seems that there always appears to be a date in these fields that limits this.
Or have I missed something?
===============================================================================================================
Hope you can make sense of all this!