View Complete Post
I would like to know how I can filter a SharePoint library list based on current user login.
Suppose I have created the followings:
1) A SharePoint form library containing bunch of uploaded InfoPath form data.
2) The InfoPath form template contains a promoted text field called "TargetUser" to store user domain login (ex: DOMAIN\JOE) and every InfoPath form file in the library has a valid domain name stored in the "TargetUser" field.
I have created a custom view for the form library and would like to filter this view so only items whose "TargetUser" field matches current user's login ID are displayed.
I went to Edit View page to customize the view and tried to use the [Me] function but I got a "Filter value is not a valid text string" message instead when clicking OK. Apparently [Me] returns a Person/Group data type and the filter cannot compare its value
to that of "TargetUser".
I tried using text functions (ex: TEXT([Me],"") hoping to extract default string value from [Me]. The filter accepts the parameter without any error but the resulting fitlered list does not display any items at all.
I have googled this subject for hours but I have not found any solution.
It would be greatly appreciated if anyone can help me t
I have a table which has few rows.
A row contain few textboxes, one file upload field and a dropdown list in its cells.
I want to make it a dynamic table that is i should be able to add extra rows in table at runtime, but I dont know how to do it.
I have requirement where I want the current date and time in the newform opened by users. I can get the current date with Today's Date option. But not able to find the time option. Is there a possibility with SPD. Tried using button option to activate a formula
to the textbox value so the user can jus click the button to get the current time and date. but facing problem in that. Kindly advice.
I'm having a gridview in my aspx page with checkbox, User can select one or more than one record(s) at a time and clicks on delete button, Then i'm constructing an object of my DTO and adding all the checked row's Primary Key (DataKeyNames - GUID's in my case) to a serializable class and generating an XML and sending it as parameter to the Stored Procedure.
My Doubt is, can i bulk delete all the rows from database table those are present in my XML document??
If it works, I can do bulk update with XML only, i already did bulk insertion by generating an XML..
My Another Question is, Will it affect the performance? Each time when i construct an DTO object and adding it to the Generic List??
WHich one is better, I mean ObjectDataSource or SQLDataSource or my XML method??
Can anyone please help me out clarifying my doubts and also XML Delete Query..
My XML will be like this
Will bulk delete happen in the above case?
I am trying to create a page that displays documents based on the company of the current user. The problem that i am experiencing is that the Company field is not available from the Current User Filter. Any suggestions on how I can filter on
this user property.
Thanks in advance
I have this calculated set to return the previous 3 months. How do I rewrite to get the last 3 quarters?
+ Format(Now(),"yyyy-MM") +