Mar 25
Jolle Carlestam [OT] Getting the most suited address to invoice
Mar 25, 2015; 18:20
Jolle Carlestam
[OT] Getting the most suited address to invoice
Here=92s something that my 6 PM brain fails to master.
Say I have an address table in Mysql.
Fields like
fk_orgid
address_row1
address_row2
zip
city
type
etc
The type field can hold one of the values work postal address, home postal address, invoice, work physical address, home physical address, other.
Companies can have one or several addresses in the table.
The task I=92m wrestling with is that I need to, with a combination of Mysql and Lasso, get one address deemed most suitable for a specific company based on the fk_orgid value.
The invoice address if there is one. If not one of the work postal (yes, there can be several=85). If there is none then a home postal. And if there is none of that get any of the other addresses.
End result, one address should be returned as the suggested invoice address.. Preferably the best pick.
Any ideas on how to do that?
HDB
Jolle
#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>
Mar 25
deco rior Re: [OT] Getting the most suited address to invoice
Mar 25, 2015; 11:34
deco rior
Re: [OT] Getting the most suited address to invoice
Mar 25
Jolle Carlestam Re: [OT] Getting the most suited address to invoice
Mar 25, 2015; 18:44
Jolle Carlestam
Re: [OT] Getting the most suited address to invoice
Mar 25
Tami Williams Re: [OT] Getting the most suited address to invoice
Mar 25, 2015; 14:05
Tami Williams
Re: [OT] Getting the most suited address to invoice
Mar 25
Peter D Bethke Re: [OT] Getting the most suited address to invoice
Mar 25, 2015; 17:42
Peter D Bethke
Re: [OT] Getting the most suited address to invoice
Mar 25
Fletcher Sandbeck Re: [OT] Getting the most suited address to invoice
Mar 25, 2015; 15:24
Fletcher Sandbeck
Re: [OT] Getting the most suited address to invoice
Mar 25
Tim Taplin Re: [OT] Getting the most suited address to invoice
Mar 25, 2015; 17:59
Tim Taplin
Re: [OT] Getting the most suited address to invoice
Mar 26
Jolle Carlestam Re: [OT] Getting the most suited address to invoice
Mar 26, 2015; 04:21
Jolle Carlestam
Re: [OT] Getting the most suited address to invoice