wrote:
> Hello Dears ,
>
> I have created three view entity ,I want to use *union* between this
> entities .
> how I can do this ?
>
> Thank u
> Regards
>
>
>
>
>
Hello Dears ,
I have created three view entity ,I want to use *union* between this entities .
how I can do this ?
Thank u
Regards
>>
>> -Original Message-
>> From: Deepak Dixit [mailto:deepak.di...@hotwaxmedia.com]
>> Sent: Friday, November 15, 2013 9:58 PM
>> To: user@ofbiz.apache.org
>> Subject: Re: View Entity Question
>>
>>
>> Hi Skip,
>>
>> Please t
; > Skip
> >
> > -Original Message-
> > From: Deepak Dixit [mailto:deepak.di...@hotwaxmedia.com]
> > Sent: Friday, November 15, 2013 9:58 PM
> > To: user@ofbiz.apache.org
> > Subject: Re: View Entity Question
> >
> >
> > Hi Skip,
>
n.
>
> Skip
>
> -Original Message-
> From: Deepak Dixit [mailto:deepak.di...@hotwaxmedia.com]
> Sent: Friday, November 15, 2013 9:58 PM
> To: user@ofbiz.apache.org
> Subject: Re: View Entity Question
>
>
> Hi Skip,
>
> Please try with rel-optional="
: user@ofbiz.apache.org
Subject: Re: View Entity Question
Hi Skip,
Please try with rel-optional="true";
Thanks & Regards
--
Deepak Dixit
On Nov 16, 2013, at 12:27 AM, Skip wrote:
> I have this view that gives the quantity on hand for requested products:
>
>
Hi Skip,
Please try with rel-optional="true";
Thanks & Regards
--
Deepak Dixit
On Nov 16, 2013, at 12:27 AM, Skip wrote:
> I have this view that gives the quantity on hand for requested products:
>
>package-name="org.ofbiz.product.product"
&g
I have this view that gives the quantity on hand for requested products:
However,
It seems like WHERE clauses should be able to be associated with an
entity/view-entity other than in find methods such as findByAnd or
findListIteratorByCondition. This would allow the where clause to be
applied to the query without the query being executed. Once the where
clauses are applied
#x27;m getting
up to speed, it shouldn't take me more than a few years...
On 13-10-30 08:56 AM, Christian Carlow wrote:
Does anyone know a way to apply a condition to a view-entity and then
left join it to another view-entity?
I need to be able to apply a condition to the OrderShipment e
for SDK products. At the rate I'm getting
up to speed, it shouldn't take me more than a few years...
On 13-10-30 08:56 AM, Christian Carlow wrote:
> Does anyone know a way to apply a condition to a view-entity and then
> left join it to another view-entity?
>
>
Does anyone know a way to apply a condition to a view-entity and then
left join it to another view-entity?
I need to be able to apply a condition to the OrderShipment entity where
shipmentId = parameters.shipmentId and then left join this conditioned
view-entity to another view-entity.
I
arlow wrote:
Does anyone know if it is possible to constrain joined view-entity
subqueries with their own WHERE clauses?
For example:
select * from tbl1 left join (select * from tbl2 where tbl2.col1 =
'someVal') tbl3 on tbl1.col1 = tbl3.col1
problem. I tried to
add an entity-condition within the view-entity but it was output as a
WHERE clause.
Was the issue mentioned here ever resolved?
http://ofbiz.135035.n4.nabble.com/View-Link-Entity-Conditions-td4219210.html
On 09/16/2013 03:16 PM, Christian Carlow wrote:
For a little
Conditional joins would also be solution to my problem. I tried to add
an entity-condition within the view-entity but it was output as a WHERE
clause.
Was the issue mentioned here ever resolved?
http://ofbiz.135035.n4.nabble.com/View-Link-Entity-Conditions-td4219210.html
On 09/16/2013 03:16
For a little perspective,
Essentially what I'm trying to accomplish is a simplified shipping
schedule list based on order item ship group due quantities.
I created a view-entity that joins together orderHeader, orderItem,
orderItemShipGroup, and orderItemshipGroupAssoc.
Additiona
list by commenting out the following lines
in the makeConditionWhereString method:
String viewClause =
SqlJdbcUtil.makeViewWhereClause(modelEntity, datasourceInfo.joinStyle);
if (viewClause.length() > 0) {
conditions.add(EntityCondition.makeConditionWhere(viewClause));
}
Does anyone
Does anyone know if it is possible to constrain joined view-entity
subqueries with their own WHERE clauses?
For example:
select * from tbl1 left join (select * from tbl2 where tbl2.col1 =
'someVal') tbl3 on tbl1.col1 = tbl3.col1
Hi
Always try to not use alias-all in in views entity only select the
field so you will get the selected data only
and the query time will be less so that we can get data quickly form any
view entity..
On Sat, Jun 8, 2013 at 6:14 PM, Martin Kaiser wrote:
> Hi all,
>
> I've
Hi all,
I've constructed an view entity in entitymodel.xml. It should give me an
address related to a party, and also the person and group name.
Unfortunately it gives me also the addresses which have are expired by
setting the thrudate. I still want the Party/Person/Group information to
Hi ,
There are many examples of view enitiy are present in ofbiz. u can follows
this link.
http://ofbiz.apache.org/docs/entity.html
Thanks
Dhiraj gupta
-
dhirajgupta
--
View this message in context:
http://ofbiz.135035.n4.nabble.com/View-Entity-GiftCard-and-FinAccount-Join
Doesn't look like there is a way to join the gift card table and the fin
account table as the card number column and fin account code column are
encrypted. Does anyone know a way I can create a view entity with these two
tables?
Thanks,
Matt Bertolini
I found that the usage are quite limited. If i need to populate the result
on a ftl form, will i be able to utilized the existing code structure, i.e.
list sales as sale, sale.id to get the value of the id selected?
Or is there anyway to provide a view-link that joins 2 different tables as
i menti
You have then to use directly JDBC. Look for prepareStatement in java code for
examples.
SQLProcessor.executeQuery(String sql) is certainly the best match
Jacques
From: "Foo Shyn Chung"
On second thought, is there anything similar to the JdbcTemplate in Spring
framework that let you run custo
On second thought, is there anything similar to the JdbcTemplate in Spring
framework that let you run customized SQL directly on OFBiz?
Thanx
FooShyn
On Wed, Apr 11, 2012 at 10:56 PM, Foo Shyn Chung wrote:
> Hi all,
>
> I have a view created via the DynamicViewEntity in a groovy script. This
>
Hi all,
I have a view created via the DynamicViewEntity in a groovy script. This
view of mine consist of few tables and another view which is declared in a
entitymodel.xml in another module.
In one of the join, the link need to consist of relationship from 3 tables,
i.e.
select * from ((tableA a
d a line at the bottom of the page as i don't know how the
structure of the wiki is. The title is : Note on using entity or
view-entity from other components
Please help inspect whether i wrote anything wrong.
Thanx
FooShyn
On Mon, Apr 9, 2012 at 6:40 PM, Jacques Le Roux <
jacques.le.r
Hi Jacques,
I'd added a line at the bottom of the page as i don't know how the
structure of the wiki is. The title is : Note on using entity or
view-entity from other components
Please help inspect whether i wrote anything wrong.
Thanx
FooShyn
On Mon, Apr 9, 2012 at 6:40 PM, Jacqu
the sequence of the component to be loaded as well.
For example, in my case, the view-entity ViewOfficerPaymentInfo is being
declared in the Payment entitymodel.xml while the ViewOfficerSalesReport
was declared in the Customer module.
Since i didn't explicitly stated the sequence to load
I'd managed to solve the problem. It seems that the entitymodel.xml loads
according to the sequence of the component to be loaded as well.
For example, in my case, the view-entity ViewOfficerPaymentInfo is being
declared in the Payment entitymodel.xml while the ViewOfficerSalesRepor
The problem is my SQL need to have left join on two tables, which are
essentially a header and detail tables and they need to have a inner join
to make it meaningful.
I found that there are a few existing view-entity in Example and in product
that are doing what i'm looking to do, but st
I did not into any details at all, but I'd suggest you to rather create another view-entity which would combine what you need from
the 2 others. (ie using directly real entities you used in both others)
Jacques
From: "Foo Shyn Chung"
Further on the issue, i tried moving the
Further on the issue, i tried moving the selection from using the
entity-condition in xml to a groovy script and using delegator.findList.
However the problem seems like persisting.
Is this a bug in OFBiz? or simple the way i declare my view-entity is wrong?
Thanx
FooShyn
On Thu, Apr 5, 2012 at
Hi all,
I'm having issue trying to select a view entity field from within another
view entity.
I have to view entity currently, first one looks like this:
The secon
Thanks for you reply.
But I don't know how to implement it.
--
View this message in context:
http://ofbiz.135035.n4.nabble.com/view-entity-definition-tp4470865p4473628.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
See if complex-alias will do what you want.
Cheers,
Anne.
On 14 March 2012 13:17, zhiyongcui wrote:
> How to implement concat function in view-entity ?
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/view-entity-definition-tp4470865p4470865.html
> S
You might be able to use complex-alias, though I haven't tried it myself.
Have a look at the documentation included in the entitymodel schema.
Cheers,
Anne.
On 12 March 2012 21:57, kiunx wrote:
> Hi there,
> i want to ask something about View Entity,
> can i get the month or yea
-9893287847
http://www.hotwaxmedia.com
On Mon, Mar 12, 2012 at 4:27 PM, kiunx wrote:
> Hi there,
> i want to ask something about View Entity,
> can i get the month or year value from 1 column that contai date?
> for example
> theDate is the column contain date data.
> TheMo
Hi there,
i want to ask something about View Entity,
can i get the month or year value from 1 column that contai date?
for example
theDate is the column contain date data.
TheMonthIs is the month value from theDate and TheYearIs is the year value
from theDate
out for you.
If you are not able create, let me know the structure of table , i will
give the view need to be created.
--
View this message in context:
http://ofbiz.135035.n4.nabble.com/view-entity-tp4169000p4194206.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
View entity in ofbiz does not represent database view; It is an entity
created at runtime based on the configuration in
; Consider these as join queries if you
will; Look for the view-entity configurations in entitymodel_view.xml
in the relevant application
- Sakthi
On 12/7/11
Hi
I am a fresher to Ofbiz, I want to create view entity for the following SQL
Query,
create view newView as (SELECT pr_id FROM span_purchase_request where pr_id
not in(SELECT distinct pr_id FROM span_request_for_quotation))\
I have tried it in Ofbiz, but not able to get the propper output
ecently while creating entity condition
>>> expressions
>>> in mini-language. Try using fromField="nullField" instead.
>>>
>>> -Adrian
>>>
>>> On 9/5/2011 4:20 AM, Anne wrote:
>>>>
>>>> Hi
>>>>
>&g
from Hans confirms my uncertainty.
I want a view-entity that uses a condition-expr to check a field for
null. The current code does not support this.
Setting 'value="null"' currently generates "fieldname='null'" in the
where condition. Leaving the value attr
n mini-language. Try using fromField="nullField" instead.
>
> -Adrian
>
> On 9/5/2011 4:20 AM, Anne wrote:
>>
>> Hi
>>
>> I created Jira OFBIZ-4393 and included a patch. I'm not sure it's the
>> best solution, and a comment from Hans c
a comment from Hans confirms my uncertainty.
I want a view-entity that uses a condition-expr to check a field for
null. The current code does not support this.
Setting 'value="null"' currently generates "fieldname='null'" in the
where condition. Leaving the
Hi
I created Jira OFBIZ-4393 and included a patch. I'm not sure it's the
best solution, and a comment from Hans confirms my uncertainty.
I want a view-entity that uses a condition-expr to check a field for
null. The current code does not support this.
Setting 'value="null&q
While defining the view entity, you may use group-by on the field aka alias
of the view entity.
Then you can add condition in the bottom using entity-condition in the
bottom of view entity definition.
See the view-entity ExampleStatusItem in the
/framework/example/entitydef/entitymodel_view.xml
Sorry, but it's not clear what you want exactly. Could you elaborate a bit more?
Jacques
From: "zhiyongcui"
I want to implement having function in view-entity defination, but I can't.Is
there somebody who can help me?many thanks!
--
View this message in context:
ht
I want to implement having function in view-entity defination, but I can't.Is
there somebody who can help me?many thanks!
--
View this message in context:
http://ofbiz.135035.n4.nabble.com/How-to-implement-Having-function-in-view-entity-defination-tp3613550p3613550.html
Sent from the
hi,
Following view-entity will help you because there some aggregate function is
used in side of this entity also there is the use of group by clause.
--
Brajesh
On 24-May-2011
How to implement sql as below with view-entity definition.
select PRODUCT_ID,FACILITY_ID,LOCATION_SEQ_ID, SUM(case when
LOCATION_SEQ_ID='A' then QUANTITY_OH_HAND_TOTAL else 0 end) AS QTY1,
SUM(case when LOCATION_SEQ_ID='b' then QUANTITY_OH_HAND_TOTAL else 0 end) AS
QTY2 from
There hasn't been a lot of interest in that feature, so it isn't totally
implemented.
Basically don't use the entity-alias attribute on the condition-expr element,
and make sure the field-name matches an alias on the view-entity (ie to do a
condition on a field it must be
Ok I found a ref in a bug report on ofbiz from 2009
Using entity-condition in the view entity def, but I'm still unclear
as to how I can get a list of attrName & attrValue fields to appear as
field & values respectively in a view entity
Can anyone help me out or po
I'm creating a new view entity that has to contain several different
attribute records from the same table.
Attributes are distinguished by a combination on an id and the
attrName. I've used a combination of fields for a view link, in
another case, befo
You can use in see ExampleStatusItem
Jacques
From: "Info Olagos"
Hello,
I created a view , partially.
I used these commands for creating a view definition in entitymodel.xml for
a new specific component:
- view-entity
- alias
- complex-alias
- view-link
My view needs to have a
Hello,
I created a view , partially.
I used these commands for creating a view definition in entitymodel.xml for
a new specific component:
- view-entity
- alias
- complex-alias
- view-link
My view needs to have a condition in it with fields equal to a value.
How can i add these conditions in the
;
> Jacques
>
> From: "arini.rusda"
>
> Hi,
>> I want to see the generated sql when i'm trying to retrieve data from view
>> entities, because my view entity didn't show the result i expected when i
>> want to do some grouping. Someone could tell me how
http://markmail.org/message/s57f7znzczb6us6h
Jacques
From: "arini.rusda"
Hi,
I want to see the generated sql when i'm trying to retrieve data from view
entities, because my view entity didn't show the result i expected when i
want to do some grouping. Someone could tel
Hi,
I want to see the generated sql when i'm trying to retrieve data from view
entities, because my view entity didn't show the result i expected when i
want to do some grouping. Someone could tell me how to view the generated
sql? Because i couldn't find it in the ofbiz.log
Th
pler way to achieve my aim, but the application
logic is irrelevant to this forum. I would like some advice on the
simplest way to modify a view, by joining an entity that has 2 primary
keys.
I'd like to get the attrValue field, into my
CustRequestAndPartyRelationshipAndRole view entity, but the
Ok my last email to the mailing list was rather glib, no suprise
no-one replied. (Sorry)
I need to define a view entity that can encapsulates the person-party
(of type customer) related to party-group (of type account team) & the
person-party (of type employee).
So that I can trace
On Sun, Aug 15, 2010 at 3:57 AM, varun bhansaly wrote:
> Hi Jacques,
> I forgot to mention, I am using
> https://svn.apache.org/repos/asf/ofbiz/branches/release09.04 at rev
> 934744.
> In this ModelViewEntity does not consider "entity-condition", so while this
>
Varun,
In R9.04 it's not a a valid view entity definition: it does not exist in
entitymodel.xsd.
But you are right, actually this is an issue in OFBiz because we don't handle
XSD files correctly (ie by version).
To avoid this, if you use Eclipse, you may follow this
Hi Jacques,
I forgot to mention, I am using
https://svn.apache.org/repos/asf/ofbiz/branches/release09.04 at rev 934744.
In this ModelViewEntity does not consider "entity-condition", so while this
is still a valid view entity definition, the engine
ignores "entity-condition".
W
es
From: "varun bhansaly"
Hi Jacques,
The requirement is to define a view entity, write some additional filtering
conditions in the definition itself, when this view entity is being queried
in the code, these filteringconditions need not be explicitly specified.
So taking the view defi
Hi Jacques,
The requirement is to define a view entity, write some additional filtering
conditions in the definition itself, when this view entity is being queried
in the code, these filteringconditions need not be explicitly specified.
So taking the view definition in the start of this trail
Aug 15, 2010 at 1:32 PM, Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:
You say "it seems", don't the view give you the results you want?
Jacques
From: "varun bhansaly"
Hi,
I have written a view entity, as shown below, the intention is to perform
inn
uot;it seems", don't the view give you the results you want?
>
> Jacques
>
> From: "varun bhansaly"
>
> Hi,
>> I have written a view entity, as shown below, the intention is to perform
>> inner join b/w two entities & a further condition.
>>
You say "it seems", don't the view give you the results you want?
Jacques
From: "varun bhansaly"
Hi,
I have written a view entity, as shown below, the intention is to perform
inner join b/w two entities & a further condition.
But after looking at the raw SQL, it
inline
>
>
> On Sun, Aug 15, 2010 at 11:53 AM, varun bhansaly >wrote:
>
> > Hi,
> > I have written a view entity, as shown below, the intention is to perform
> > inner join b/w two entities & a further condition.
> > But after looking at the raw SQL,
Hi,
Comments inline
On Sun, Aug 15, 2010 at 11:53 AM, varun bhansaly wrote:
> Hi,
> I have written a view entity, as shown below, the intention is to perform
> inner join b/w two entities & a further condition.
> But after looking at the raw SQL, it seems entity engine seems to
Hi,
I have written a view entity, as shown below, the intention is to perform
inner join b/w two entities & a further condition.
But after looking at the raw SQL, it seems entity engine seems to ignore
entity condition
e Software Development
HotWax Media Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxmedia.com
On Tue, May 18, 2010 at 5:24 AM, Prashant Punekar <
prashant_pune...@mindtree.com> wrote:
> Hi,
>
> Even after adding the condition to the view entity, it seems that the
> condition is not be
Hi,
Even after adding the condition to the view entity, it seems that the condition
is not being taken into consideration.
When we query the view, we get all the records irrespective of the condition
added in the view definition.
Here is the view definition
It should be possible to construct the same view with a static view entity
definition as it is with a DynamicViewEntity, the only difference between the
two is the dynamic nature of the latter i.e. you can construct the view at
runtime to only query the data you actually need.
Regards
Scott
Please do not post in both mailing lists. I have answered your question
in the user mailing list.
On Tue, 2010-03-09 at 09:43 +0700, Chatree Srichart wrote:
> Is it possible if I need to define view-entity with SQL statement because I
> need to use NESTED SELECT statement?
--
Antwebsyste
ards,
Hans
--
Antwebsystems.com: Quality OFBiz services for competitive rates
On Tue, 2010-03-09 at 09:43 +0700, Chatree Srichart wrote:
> Is it possible if I need to define view-entity with SQL statement because I
> need to use NESTED SELECT statement?
Is it possible if I need to define view-entity with SQL statement because I
need to use NESTED SELECT statement?
The beginners tutorial
http://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Beginners+Development+Guide+Using+Practice+Application+%28Hello+World...%29
Gnanashankar Shanmugam sent the following on 12/23/2009 11:59 PM:
> hi friends,
> I am new for ofbiz, I created component in hot-deploy.. in
hi rishi,
thanku for your reply, i can not understand that groovy file, and my
scenario follows below,
persondetails
1. first name-- text field
2. surname-- test field
3. create- submit button.
i want display below,
Firstname surname
---
Refer
/applications/product/webapp/facility/WEB-INF/actions/facility/CountFacilityInventoryByProduct.groovy
Here you got the code reference for creating a dynamic view getting data
from it and then getting list which can be displayed on ftl/form-widget.
HTH!
Rishi Solanki
Enterprise Software Deve
hi rishi,
thanks for your reply, can you send example of simple java code for dynamic
view creating to text field and one submit botton..
On Thu, Dec 24, 2009 at 2:35 PM, Rishi Solanki wrote:
> Hi Gnanashankar,
> After making the dynamic view in groovy/java file you can get the eli by
> applying
Hi Gnanashankar,
After making the dynamic view in groovy/java file you can get the eli by
applying findListIteratorByCondition method of delegator object.
then on eli you have methods eli.getPartialList and eli.getCompleteList will
gives you the list which then put into context or service result or
hi friends,
I am new for ofbiz, I created component in hot-deploy.. in that component
i created testscreen, in that screen i am having *two text fields*,
one submit(*create*) *button*, i want to store value of two fields in *
database* through *java code*, after clicking submit button, the value
o understand if there's another way
to do
joins, besides using view-entity.
I'm finding view-entity to be tricky, even though I know what I want
in
terms of a simple join.
--
James McGill
Phoenix AZ
smime.p7s
Description: S/MIME cryptographic signature
Thanks (framework/base/config/debug.properties).
One more question: I'm trying to understand if there's another way to do
joins, besides using view-entity.
I'm finding view-entity to be tricky, even though I know what I want in
terms of a simple join.
--
James McGill
Phoenix AZ
You could temporarily change your debugging level to verbose and the
SQLProcessor will log the statements.
Regards
Scott
HotWax Media
http://www.hotwaxmedia.com
On 8/10/2009, at 5:36 PM, James McGill wrote:
How do you inspect the SQL for a View Entity?
--
James McGill
Phoenix AZ
How do you inspect the SQL for a View Entity?
--
James McGill
Phoenix AZ
ng)]
([GenericDelegator.findByPrimaryKey] Passed primary key is not a valid
primary key:
[GenericEntity:OrderAndTaxByCounty][OTCMOrderNo,ORD143486(java.lang.String)])
-
OTCMOrderNo is one my primary key (there are total 5 prima
derscore.
>
> I won't be able to look into this today, but maybe later in the
> week... so if anyone beats me to the fun I won't be offended. ;)
>
> -David
>
>
> On Sep 28, 2009, at 12:04 PM, su2 wrote:
>
>>
>> Hello Friends,
>>
>
ffended. ;)
-David
On Sep 28, 2009, at 12:04 PM, su2 wrote:
Hello Friends,
I am trying to create a view entity with complex alias using two
view-entities.
I have view entity A, View entity B and trying to create a new view
entity C
from View Entity A & View Entity B.
When I add complex
Hello Friends,
I am trying to create a view entity with complex alias using two
view-entities.
I have view entity A, View entity B and trying to create a new view entity C
from View Entity A & View Entity B.
When I add complex-alias with '+' operator I get the error message.
methods in there where the query is constructed. You could
modify the code to add a print statement or do a debug using tools
like eclipse, Hope this helps
- YOKEPOWER
On 9/23/09, su2 wrote:
Hello All,
Is it possible to see underlying queries for view-entity? I tried checking
checkbox for
wrote:
Hello All,
Is it possible to see underlying queries for view-entity? I tried
checking
checkbox for verbose in Adjust Debugging Level. And tried to see in
runtime/log but was not able to see any SQL query there.
Am I looking at the right file? Is there any other way?
I really
statement or do a debug using tools
like eclipse, Hope this helps
- YOKEPOWER
On 9/23/09, su2 wrote:
>
> Hello All,
>
> Is it possible to see underlying queries for view-entity? I tried checking
> checkbox for verbose in Adjust Debugging Level. And tried to see in
> runtime/lo
Hello All,
Is it possible to see underlying queries for view-entity? I tried checking
checkbox for verbose in Adjust Debugging Level. And tried to see in
runtime/log but was not able to see any SQL query there.
Am I looking at the right file? Is there any other way?
I really appreciate all
In the OFBiz trunk there is an option for view-entity definitions to
include an entity-condition element that is similar to the ones in
simple-method and various widgets, and that will allow you to add a
where condition to the view-entity def.
-David
On Sep 22, 2009, at 1:52 PM, su2
hi Su,
Answers inline
On Tue, Sep 22, 2009 at 5:07 PM, su2 wrote:
>
> Hello Friends,
>
> I am trying to create view-entity which works fine with 2 entities but does
> not work with 3 entity-member.
>
> I have couple of questions.
>
> 1. Is there any restriction on e
Hi Su,
Just to give a back ground, Entity and View Entity work in the same fashion
at runtime/query execution; the only difference being, entity is used for
single entity and view-entity is used for combining multiple entities; that
being said, entity OR view-entity query has two parts namely
1
1 - 100 of 154 matches
Mail list logo
