Re: [GNC] Any way to filter Scheduled Transactions by the Name Field?

Here is some SQL that *might* be of some use, it uses last occurrence 
which is in a table.

===

select

substr(name,1,instr(name,"]")) as k,

name,

last_occur

from

schedxactions

order by

k, last_occur


==


Wm


On 2026-08-22 11:18, Wm Tarr wrote:
> On 2026-08-22 00:39, Tom Route36 wrote:
>> Hi all,
>>
>> I use the Name field of my scheduled transactions to help identify 
>> the payer account for each of those transactions.  And it would be 
>> helpful quite often to just view the upcoming transactions for a 
>> *single* payer account (e.g., checking) so I could see when 
>> withdrawals are scheduled to happen from that one account.  As an 
>> example, I might name the scheduled transaction for my power company 
>> as "[chk] ConEd", where the funds that are scheduled to be paid to 
>> "ConEd" would be coming from my checking account "[chk]".
>>
>> What I was hoping to do was to be able to *filter* my rather long 
>> list of scheduled transactions by the Name field; so that I could 
>> easily see the upcoming transactions for just that one account (e.g., 
>> "[chk]").  So, my question is: Is there any way to filter the 
>> Scheduled Transactions list in that manner -- i.e., by a text string 
>> within the Name field?
>>
>> Just as an FYI, I know that I can *sort* the list by the Name field; 
>> but that doesn't really help with this.  The problem with sorting 
>> like that is that the list won't be ordered by the Next Occur date, 
>> which is the more important thing.
>>
>> Any ideas?
>
>
> There is no way to do what you want without scripting that I can think 
> of and the Next Occurrence date has to be calculated, i.e. it isn't 
> stored in a table.
>
> My approach (which you may have considered before) is to create 
> scheduled transactions 60 days in advance and update the exact amount 
> & date as they happen.
>
> Wm
>
>
> _______________________________________________
> gnucash-user mailing list
> [email protected]
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.