Stump the Panel: SharePoint Q&A

SharePoint Designer and the Data View Web Part • Re: AJAX or Refreshing a DVWP in 2007

2011-05-17T22:17:51-04:00

Hey Eric, I wanted to dive more into this technique, so I figured, I'd post back my findings.
I noticed on your offerings call, there were missing quotes around that ID. The script tag was also missing a quote around javascript. I think it's not working b/c of your hyperlink. After trying your hyperlink code, I took my code block and slapped it into doc.ready. This code works as is:

$.ajax({
async: false,
url: "http://moss2007x86/Pages/FixedHeaderRow.aspx",
complete: function (xData, Status) {

alert(Status);
//console.log(xData.responseText);
//Hardcoded Webpart ID for accuracy
var DVWPMarkup = $(xData.responseText).find("#MSOZoneCell_WebPartWPQ4").html();
$("#Output").html(DVWPMarkup);
//Used to determine the ID was correct on the current page
$("#Output").append("Text");
}
});

Hope it helps!

Statistics: Posted by RemyMaza — Tue May 17, 2011 10:17 pm

SharePoint for Non-Geeks • Re: Need a Better Way

2011-05-17T10:47:36-04:00

pinkstonm, I feel like I need to ask a dumb question. Why does the list need to be reloaded ever day? I have not heard of a requirement like that before because lists we have used for 8+ have not needed a daily reload.
- Jack

Statistics: Posted by JLapke — Tue May 17, 2011 10:47 am

SharePoint Designer Workflow • Re: Workflows not triggering when replied to discussion boar

2011-05-17T09:08:16-04:00

The reply is actually a new item in the list. If you go into the discussion board and turn on management of content types from the Advanced Settings, you'll see there are 2 content types associated with the discussion board.

I haven't tested this, but I'd imagine you'll want to create a new on creation workflow that looks at If Content Type equals Reply, do something.

Statistics: Posted by eric — Tue May 17, 2011 9:08 am

SharePoint Designer Workflow • Workflows not triggering when replied to discussion board

2011-05-17T08:53:20-04:00

Hi Team,

I am using discussion board values into some other list. For this to implement i have designed a workflow when ever an item gets added/updated in the discussion board. But when we reply to the existing item(post) , the workflow is not triggering.
I have observed that the modified date will not change when replied.

Please let me know any other alternatives to trigger the workflow when replied to any of the post.

Thanks,
Srihari

Statistics: Posted by sriharikanchi — Tue May 17, 2011 8:53 am

SharePoint Designer and the Data View Web Part • Re: Displaying data from 2 list collections

2011-05-16T17:33:32-04:00

Update - nevermind, you figured it out lol.

Eric,
If you are willing, PM me with some screenshots or email me at [email protected] and I'll try to look at both the xsl you've been generating plus the settings you've set for your linked data source. I did find that if you change the data source's settings itself in the UI, you have to delete and re-add the dvwp to the page to get it to manage the caml correctly (so maybe that will help some). Also, is the Person/Group column you are dealing with defining specific users to own the data or groups to own it? I had to do this with a scheduling system where I wanted to display a user's classes that they registered for and provide a way to unregister to it so this gave me quite a bit of evil (even consulted Mark on it and posted my results on my blog here to give you an idea of what I had to to with the CAML: here). It definitely is possible and, in theory, possible without directly editing the CAML/XSL.

Statistics: Posted by bhorner — Mon May 16, 2011 5:33 pm

SharePoint Designer and the Data View Web Part • Re: Displaying data from 2 list collections

2011-05-16T16:28:35-04:00

You bet! Glad you got it.

M.

Statistics: Posted by sympmarc — Mon May 16, 2011 4:28 pm

SharePoint Designer and the Data View Web Part • Re: Displaying data from 2 list collections

2011-05-16T16:21:10-04:00

I think my frustration built up on this and caused me to rage. I replaced the Row filter with /dsQueryResponse/Labs/Rows/Row[substring-after(substring-before(substring-after(@Data_x0020_Owner, 'ID='), '<'), '>') = $UserID] which I know I've already tried at some point (have SPXSLT.codeplex.com open).

This returns my 1 record and I can add a subview. Now I have to work some stuff out on my subview template but I think I should be ok for the tiem being.

Thanks Marc, really appreciate the assistance.

Statistics: Posted by eric — Mon May 16, 2011 4:21 pm

SharePoint Designer and the Data View Web Part • Re: Displaying data from 2 list collections

2011-05-16T16:06:30-04:00

Ok, note what $UserID contains.

M.

Statistics: Posted by sympmarc — Mon May 16, 2011 4:06 pm

SharePoint Designer and the Data View Web Part • Re: Displaying data from 2 list collections

2011-05-16T16:00:46-04:00

Statistics: Posted by eric — Mon May 16, 2011 4:00 pm

SharePoint Designer and the Data View Web Part • Re: Displaying data from 2 list collections

2011-05-16T15:51:45-04:00

I build DVWPs like this all the time, so I'm 100% positive you can do it. Explaining it is another matter!

So if you switch from

Code:

you don't get any items?

I'd display
$UserID
@Data_x0020_Owner, and
substring-before(substring-after(@Data_x0020_Owner, 'ID='), '"')
in the rowview template without a filter so that I could see what values there are. This would tell me what I should expect when I filtered based on the actual data. Then I'd apply the filter and see what I got.

M.

Statistics: Posted by sympmarc — Mon May 16, 2011 3:51 pm