On 27/01/2012 14:45, Mark Stanton wrote:
Mark,
google for "parametered" query's in Openoffice they open with a input dialog
LO -OO likes to uses unddercase for Tablenames and uppercase for
Fieldnames (avoid to use "" and or '')
Greetz
Fernand
Hi Dan,
Ok, here's the query.
SELECT CONCAT(people.Title, ' ', LTRIM(people.Firstname), ' ',
LTRIM(people.Surname)) AS PersonName,
people.PersonId, issues.iId AS iiID, issues.Issue,
people.LastIssue,
subscription.iId AS subiId, subscription.Type,
subscription.AdType,
subscription.Delivery, subscription.Issues,
subscription.StartingAt,
address.Company, Address1, Address2, Address3, City,
Area, Country, PostalCode,
sent.iId AS SendId, sent.NumberSent,
textvalues.Text
FROM people
JOIN subscription ON people.iId = subscription.iPeopleId
JOIN sent ON sent.iSubId = subscription.iId
JOIN issues ON sent.iIssueId = issues.iId
JOIN address ON people.iId = address.iaParentId
JOIN textvalues ON textvalues.Id = subscription.Type
WHERE issues.Issue = '70' AND textvalues.Field = 'CBOSUBTYPE'
ORDER BY FirstName, Surname
It's producing an address list of subscribers to the next (here
hard-coded as '70', until I find out how to pass a parameter to a
query from a report, or at least in conjunction with a report) to
print address sheets. It's originally from my own (Visual FoxPro)
application that runs our magazine subscriptions. It's now "in
transition" to LO :-)
Regards
Mark Stanton
One small step for mankind...
--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
