Community mailing list archives

community@mail.odoo.com

Re: Filter invoices by city and/or tags

by
Antony Lesuisse (al)
- 02/03/2015 20:09:42
Two solutions:

- add a related store field on the object.
- edit the analysis view (the postgresql view) to add the join

On 02/02/2015 06:28 PM, Felipe Scarel wrote:
> Saw your reply on the mailing list archives Dave, I'm now wondering about it.
>
> The "Group by" suggestion you offered seems like a good one, but as predicted
> it's not readily available. The only parameters available for filtering via
> the "Advanced Search" option are the ones exposed through the invoice model.
> So my question now is: is there any addon/application that tackles this kind You
> of problem, or would a coding solution be required to solve it? I'm not big on
> Python coding by any means, so if it comes to coding an addon to include that
> kind of fuctionality I'd probably be better off querying the SQL database
> directly to produce the desired output, I reckon.
>
> Thanks, and regards.
>
> On Sat, Jan 31, 2015 at 11:48 PM, Felipe Scarel <info@fbscarel.com
> <mailto:info@fbscarel.com>> wrote:
>
>     Hello all,
>
>     I'm currently deploying Odoo with a client, and a doubt arose and I
>     couldn't readily find how to solve this problem. This client sells on a
>     variety of cities, and he asked if it'd be possible to print a report or
>     sort/filter invoices categorized by customer city (or, alternatively, tags
>     assigned to customers).
>
>     For example, if clients A, B and C are all from city X, he'd want to show
>     all invoices for clients on city X.
>
>     As far as I've researched, it's possible to filter invoices by a variety
>     of parameters, but the only one pertaining to the client is its name. The
>     city/address and tag parameters seem to be available for filtering only on
>     the "Clients" context, which I'm assuming is due to the fact that they
>     belong to the client table or something similar. Therefore, I'd imagine
>     some sort of SQL JOIN would solve that problem, but it doesn't seem to be
>     available through the Odoo interface.
>
>     Is this sort of operation supported natively by Odoo, or perhaps by any
>     addons/applications? Or, rather, should I query the SQL database directly
>     to produce that sort of report?
>
>     Thanks in advance for your help!
>
>     --
>     *Felipe Scarel*
>     Information Security and Infrastructure Consultant
>     URL: www.fbscarel.com 
>     Phone: (+55)(61)91297200
>
>
>
>
> --
> *Felipe Scarel*
> Information Security and Infrastructure Consultant
> URL: www.fbscarel.com 
> Phone: (+55)(61)91297200
>
> _______________________________________________
> Mailing-List: https://www.odoo.com/groups/community-59
> Post to: mailto:community@mail.odoo.com
> Unsubscribe: https://www.odoo.com/groups?unsubscribe
>