I mo iarrachtaí ar siúl ag soláthar colún lookup níos úsáidí ag baint úsáide as BDC, I hit a wall with the BDC picker. If you haven’t see it, the BDC picker is similar to a people picker except that it works with columns of type "business data".
Tá tú rochtain a fháil ar an roghnóir trí chliceáil ar an deilbhín leabhar a oscailt an colún shonraí gnó mar a thaispeántar:
The above image shows a business data column called "Master Document Id". That column is connected, via BDC, to a web service. The web service returns two columns of information: Document ID and Title. The business purpose here is to provide a "this document is based on" fheidhm. Users select a "master" doiciméad agus nuair a shábháil siad, ócáid glacadóir cóipeanna réimsí sonraí meta ón mháistir tagairt.
De réir réamhshocraithe, the BDC picker looks like this when I search for a document whose ID = "38":
Sin cabhrach, but not good enough. People don’t think in terms of IDs, they think in terms of titles and/or other meta data. The picker allows you to search on other columns (e.g. Teideal) ach ní bheidh a thaispeáint ar an liosta iarbhír na teidil go raibh sé, ach a n-DocId atá mar a thaispeántar anseo:
(Níl an lámhaigh scáileán chomh mór toisc nach raibh mé ag piocadh cuardach go bhfilleann aon torthaí bailí, ach is féidir leat a fheiceáil más rud é go raibh fuair sé roinnt torthaí, bheadh sé léirithe amháin DocId ar, Ní teidil).
I searched high and low for the answer to this and failed. Mo chomhghleacaí, an venerable Jonathan Bradshaw, had faced and solved this issue. When I reached out to him for help, Dúirt sé liom sa treo ceart.
Configure the picker to show multiple columns via the "ShowInPicker" maoin sa ADF:
<Maoin Ainm="ShowInPicker" Cineál="System.Boolean">fíor</Maoin>
I níos mine:
<!-- Teideal --> <TypeDescriptor TypeName="System.String" Ainm="Teideal" > <LocalizedDisplayNames> <LocalizedDisplayName LCID="1033">Teideal</LocalizedDisplayName> </LocalizedDisplayNames> <Airíonna> <Maoin Ainm="DisplayByDefault" Cineál="System.Boolean">fíor</Maoin> <Maoin Ainm="ShowInPicker" Cineál="System.Boolean">fíor</Maoin> </Airíonna> </TypeDescriptor>
Setting this property does introduce a minor problem. As soon as you set it once, you need to set it for every column you want to show. I mo chás, BDC picker showed DocId by default. Mar sin féin, once I added "ShowInPicker" Theideal, DocId no longer displayed. I solved that by explicitly setting the ShowInPicker property for Doc ID.
Seo é an toradh:
(I’ll explain the odd-looking "168 – CamlSchema.xsd" construction in a future blog post. I mbeagán focal, tá sé ina teaghrán concatenated a ligeann le haghaidh taithí úsáideora beagán níos fearr).
Ar ndóigh,, tar éis scríofa iontráil seo blog, I just did a search for "ShowInPicker" agus fuair amas iomadúla, lena n-áirítear an ceann seo: http://msdn2.microsoft.com/en-us/library/ms583986.aspx. It explains the meaning of that property along with some other good BDC stuff.
</deireadh>
Damn… An tAirteagal seo a shábháil dom a lán ama agus mo beo :-))
Mór Post agus do Blag leanas le mo rogha. Dála an scéil, I found the article by googling "bdc could not find fields to insert all the identifier values" *lol * 😉
Maidir is, JM
Hi Paul,
táimid iontach Fuair screencast de conas is féidir leat a leagtar an mhaoin le Meta Man BDC
http://support.lighteningtools.com/default.asp?W12
Go raibh maith agat
Nick