nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Een SharePoint-lijst opvragen

HeatherHainsworth

<\/HEAD>Hallo,

Ik probeer een SharePoint-lijst op te vragen in een ArcGIS Web Part. Dus ik heb het voorbeeld van de SDK online genomen en aangepast zodat het naar mijn lijst en mijn lijstvelden verwijst, maar het lijkt niet te werken.

Ik heb pop-upvensters in de code geplaatst en het lijkt nooit naar de on failure- of on success-functies te gaan; het stopt bij
clientContext.ExecuteQueryAsync(onQuerySucceeded, onQueryFailed);

Mijn X- en Y-velden die ik gebruik zijn nummervelden (ik heb ook geprobeerd de ShapeX- en ShapeY-velden van een ArcGIS Geocode Workflow te gebruiken) en niets lijkt te werken.

Ik heb het voorbeeld zoals het is genomen met de cities-lijst en ik heb de query by attribute op die manier aan de praat gekregen.

private void StateComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
 {
 ClientContext clientContext = ClientContext.Current;
 Web web = clientContext.Web;

 // Query de lijst "Cities" met de geselecteerde statenaam
 List citiesList = web.Lists.GetByTitle("Test"); // Mijn lijst heet Test
 CamlQuery camlQuery = new CamlQuery();
 string stateName = StateComboBox.SelectedValue.ToString();
 camlQuery.ViewXml =
 @<View>
 &amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;Query>
<Where>
<Eq>
<FieldRef Name='Title'\/>
<Value Type='Text'>" + stateName + @&lt;\/Value>
<\/Eq>
<\/Where>
<\/Query>
<RowLimit>1000<\/RowLimit>
<\/View>";

& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ; citiesListItems = citiesList.GetItems(camlQuery);
& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ; clientContext.Load(citiesList, list => list.Title); & nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ; clientContext.Load(citiesListItems, items => items.Include( & nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ; item => item["X"], & nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ;& nbsp ; item => item["Y"] & nb sp ;; & nb sp ;; & nb sp ;; )); & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; MapApplication.Current.ShowWindow("Klaar om uit te voeren", new TextBlock() & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; { & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; Text = "Klaar om uit te voeren.", & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; TextWrapping = TextWrapping.Wrap, & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; & nb sp ;; Margin = new Thickness(30), & nb sp ;; & nb sp;; MaxWidth = 480 ; }); ; clientContext.ExecuteQueryAsync(onQuerySucceeded, onQueryFailed); ; }</ BODY ></ HTML >

Vind meer berichten getagd met

Accepted answers

All comments

GarrettMoeller

So, all elements that call the field name should be using only the internal field name?
There is no use for the alias name (other than for display purposes)?

I am able to get the pop-up to show with the drop-down items,
but when you select, nothing happens afterwards -
no query, no error message, no new layer creation...

MichalGrinvald1

Hi

I have another question...
When I query the list I build the caml with the fields names I get as attributes to the graphics in the SharePointListGraphicsLayer.
These are the fields' internal names.
When I get the result I can only see again the internal name of the fields in the returned ListItemCollection.
How do I get the alias/display name of the fields?

Thanks
Michal

RichZwaap

Set the Renderer property on the GraphicsLayer before adding it to the map. The symbology functionality in the Map Web Part works with the Renderer property, so it checks this when a layer is added to see whether it is null. If it is, it adds a simple renderer that specifies the default symbol you are seeing. If the Renderer is specified, this takes precedence over the Symbol property on individual graphics.

HeatherHainsworth

Wow, that explains a lot and is very helpful! thanks so much for explaining that I had been wondering why the one field in the sample didn't match the list.

Ok, my last question about list queries is there any way to change the symbol of the features returned and placed on the map? It returns as a orange stick pin right now, I have tried setting a graphic symbol in the code but the orange stick pin always overrides it, the code below works in a normal ESRI Silverlight application... is there something special you need to do for SharePoint?

                ESRI.ArcGIS.Client.Symbols.PictureMarkerSymbol Arrow = new PictureMarkerSymbol();

                BitmapImage bitmap = new BitmapImage();
                Uri imgURL = new Uri("http://localhost/ArrowYellow.png", UriKind.Absolute);
                bitmap.UriSource = imgURL;

                Arrow.Source = bitmap;
                graphic.Symbol = Arrow;

RichZwaap

Hi Heather:

There are two things to be aware of here about the CAML query. First, you need to specify the internal field name of the fields you wish to return. The internal name is set at the time the column is created and never changes, even when you update the field's display name. Columns that are automatically generated by SharePoint, such as the Title field, often have special names. In other cases, some characters in the display name are substituted in the internal name. One example is spaces, which are replaced with "_x0020_" in the internal name.

One way to see the internal name of the field is to navigate to the list, sort on the field name you wish to know by clicking on that field's header, then look at the URL in the browser's address bar. Included in the URL you will see an "&SortField=" parameter. That will tell you the internal name is.

Second, if you are specifying a Value in the CAML, you need to correctly specify the Type attribute. So in the example, the type is specified as "Text."

While it's good to know how CAML queries work, writing them by hand can be quite laborious. You can instead use CAML generation tools for this. My favorite is the U2U CAML Query Builder. You can download the version for SharePoint 2007 - I have not yet experienced any issues when running this against SharePoint 2010.

Hope this helps.

HeatherHainsworth

Well I found a few things out, first I had taken the SDK Sample and just changed the names of the namespaces and XAP file which I have done on other silverlight applicaitons and I have had no issues with it but I must have missed a reference somewhere. Because I created the command from a blank silverlight application and I have it querying now.

I also learned that if you rename the Title Field (a default field with sharepoint) you still have to refer to it as Title in the application.

So now I have it querying and returning results and plotting on the map. It returns the Name (Title), Address, and City.

I tried to add 3 other fields and it fails again. Sois there any requirement for the types of fields you can return in the query?

I tried number fields, fields without spaces and with spaces, and I tried converting Number fields to single text and I still can't get the query to return results when I add those fields....

RichZwaap

Hi Heather:

Your code looks fine. Do the field names match what you have in your "Test" list? The CAML assumes that the state name is stored in a field called "Title," and the items.Include statement specifies field names of X and Y.

If the field names check out and you still have problems, I would recommend putting together a quick Silverlight app that does nothing other than querying your SharePoint list. Once you get that working, then you can move it into your command implementation.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.