Only List Active Aquaria when Adding to My Cats

A historical forum for issues reported in the suggestions and bugs forum that have been subsequently fixed or resolved.
Post Reply
User avatar
Martin S
Posts: 2100
Joined: 26 Mar 2003, 11:14
I've donated: $20.00!
My images: 9
My cats species list: 90 (i:19, k:0)
My aquaria list: 11 (i:3)
Spotted: 17
Location 1: Guildford, Surrey
Location 2: UK
Interests: Aquatics

Only List Active Aquaria when Adding to My Cats

Post by Martin S »

When you add (a nd subsequently edit) a new addition to My Cats, it gives you the option to assign the fish to an aquarium - could this list only show those that are active?
I'm assuming it's something along the lines of 'AND [MY_Aquaria].[Stop_Date] IS NULL' type addition to the query that brings back this list?
Martin
User avatar
MatsP
Posts: 21038
Joined: 06 Oct 2004, 13:58
My articles: 4
My images: 28
My cats species list: 117 (i:33, k:0)
My aquaria list: 12 (i:10)
My BLogs: 4 (i:0, p:164)
Spotted: 187
Location 1: North of Cambridge
Location 2: England.

Re: Only List Active Aquaria when Adding to My Cats

Post by MatsP »

I'm moving this to "Bugs", as it's clearly wrong. And I agree, it's conceptually the fix you describe. It's slightly more complicated because the code for "take things from a database and make it into a drop-down" is generic (it's used to select species, genus, etc, etc), but I think there is a way to add an extra statement.

--
Mats
User avatar
MatsP
Posts: 21038
Joined: 06 Oct 2004, 13:58
My articles: 4
My images: 28
My cats species list: 117 (i:33, k:0)
My aquaria list: 12 (i:10)
My BLogs: 4 (i:0, p:164)
Spotted: 187
Location 1: North of Cambridge
Location 2: England.

Re: Only List Active Aquaria when Adding to My Cats

Post by MatsP »

Fixed in R548.

--
Mats
User avatar
Jools
Expert
Posts: 16274
Joined: 30 Dec 2002, 15:25
My articles: 198
My images: 941
My catfish: 237
My cats species list: 87 (i:13, k:1)
My aquaria list: 21 (i:13)
My BLogs: 7 (i:10, p:167)
My Wishlist: 23
Spotted: 450
Location 1: Middle Earth,
Location 2: Scotland
Interests: All things aquatic, Sci-Fi, photography and travel. Oh, and beer.
Contact:

Re: Only List Active Aquaria when Adding to My Cats

Post by Jools »

MatsP wrote:Fixed in R548.

--
Mats
Uploaded. Fixed?

Jools
User avatar
Martin S
Posts: 2100
Joined: 26 Mar 2003, 11:14
I've donated: $20.00!
My images: 9
My cats species list: 90 (i:19, k:0)
My aquaria list: 11 (i:3)
Spotted: 17
Location 1: Guildford, Surrey
Location 2: UK
Interests: Aquatics

Re: Only List Active Aquaria when Adding to My Cats

Post by Martin S »

Looks good to me - thanks :-BD
Sorry, can't test it via tapatalk and don't turn on the PC much when not at work ;)
Thanks again
Martin
Post Reply

Return to “All Resolved Issues”