Code

Re: Code to Iterate through Secondary DataSource

mjarrett — Thu, 11 Dec 2008 18:57:32 GMT

Works perfectly! Thank you!

Re: Code to Iterate through Secondary DataSource

Shiva — Thu, 11 Dec 2008 05:39:01 GMT

Hello,

We can hide the section using expression as Jimmy said. If you want you can add one more field in schema and set the value is true for show the section otherwise hide the section. This new field value we have to set in code based on your condition.

Re: Code to Iterate through Secondary DataSource

Jimmy — Thu, 11 Dec 2008 00:16:10 GMT

Code for this would not require iteration. It would look like this:

XPathNavigator iLoveSharePointSource = DataSources["GetGroupsFromCurrentUser"].CreateNavigator();
if (iLoveSharePointSource.SelectSingleNode("//s1:UserGroups[s1:string = 'Human Resources']", NamespaceManager) != null)
{
// do stuff
}

You might need to change the GetGroupsFromCurrentUser and s1, depending on what those are called in your form.

But it sounds to me like you just want to show or hide a section, which would be done in conditional formatting, not code. Just hide the section based on this expression:

not(xdXDocument:GetDOM("GetGroupsFromCurrentUser")//s1:UserGroups[s1:string = "Human Resources"])

Again, you may need to adjust the bold parts.

Code to Iterate through Secondary DataSource

mjarrett — Wed, 10 Dec 2008 17:44:43 GMT

Hi all

I am using ILoveSharePoint's GetGroupsFromCurrentUser webservice which returns all SharePoint groups that the user is in. Anyhow, this is a secondary datasource. I need help writing the code to iterate through this repeating field. Then, I need to unhide a section based on whether or not they are in the group.

I have tried to populate a drop-down list with this information and use "Contains", "Is Equal to", "is present" to control the conditional formatting but it does not work.

I was thinking with something along the lines of <pseudo code>:

foreach(Group in GroupList)
{
   If (Group == "Human Resources")
      {
         show hidden section
       }
}

</pseudo code>

But I am not very proficient with C# and the XPathNavigators and such. Any help would be GREAT! Thanks in advance!