Community mailing list archives

community@mail.odoo.com

Re: Filter invoices by city and/or tags

by
Felipe Scarel
- 02/02/2015 12:26:12
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 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> 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
Phone: (+55)(61)91297200



--
Felipe Scarel
Information Security and Infrastructure Consultant
Phone: (+55)(61)91297200