The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Filter Lookup
Posted: 20 Oct 06 3:09 PM
|
fiogf49gjkf0d Is it possible to set the sort order of a lookup? I am filtering a lookup
with the following code:
strState=pklState.text
lveJurisdiction.LookupRestrictField="AccountID"
lveJurisdiction.LookupRestrictOp="IN"
lveJurisdiction.LookupRestrictValue="(select distinct a.accountID from
account a, " & _
"address ad, c_opportunity co where a.accountID=ad.ENTITYID and
co.state=ad.state " & _
"and co.state='" & strState & "' and a.subtype='Agency' )"
Thanks
Steve K. |
|
|
|
Re: Filter Lookup
Posted: 23 Oct 06 7:48 AM
|
fiogf49gjkf0d Couldn't you add an ORDER BY to the lveJurisdiction.LookupRestrictValue assignment.
For example
veJurisdiction.LookupRestrictValue="(select distinct a.accountID from
account a, " & _
"address ad, c_opportunity co where a.accountID=ad.ENTITYID and
co.state=ad.state " & _
"and co.state='" & strState & "' and a.subtype='Agency' ORDER BY a.account)"
John G. |
|
|
|
Re: Filter Lookup
Posted: 23 Oct 06 8:15 AM
|
fiogf49gjkf0d Good try - I tried it but the lookup won't return any records. I think because this is just the restrict value.. Any other thoughts? Thanks |
|
|
|
Re: Filter Lookup
Posted: 23 Oct 06 8:18 AM
|
fiogf49gjkf0d Well the other thought is this... is there another property for the veJurisdiction object. Maybe LookupOrderValue ?
John G. |
|
|
|
Re: Filter Lookup
Posted: 23 Oct 06 9:34 AM
|
fiogf49gjkf0d Looks to me like the search field is the same as the order by field. If thats an option you can change this in the lookup manager. |
|
|
|