Retrieve data from list from different web application

Question

Hi,

in sharepoint i have different application running on different portal. For example HR attandance applicaiton on HR portal.
car request application on different web application like request.

Now i have created on sigle portal for all user so that user can have at a glance view from different application.

one view show data from HR application, HR data come from database, one view from request application, request application 
data from list. 

based on logged user details should be shown.

please guide me how i go about developing all these.

thanks

---

iffi

Answer 1

Hi imughal,

We can create a SOAP data connection from SharePoint Designer to get data across site. If you need to get data from list, then use Lists.asmx web services. If need site groups, use UserGoup.asmx web services. And user information gets from userprofileservice.asmx.

Here is the reference to create SOAP data source in SharePoint Designer.
http://office.microsoft.com/en-us/sharepoint-designer-help/add-a-soap-service-as-a-data-source-HA010355752.aspx

And here are all Web Services in SharePoint.
http://msdn.microsoft.com/en-us/library/bb862916(v=office.12).aspx

Thanks & Regards,
Emir

---

Emir Liu

TechNet Community Support

Answer 2

Hi,

i have created SOAP connection to show list list data on site. its working fine. list has filed created by. now problem with data view webpart in created by columns it shows values like

53;# user 1
123;# user 3
435;# user 5

pls tell how to get rid of additional number and # sign. Pls also give some reference to formatting of dataview web part to make it well look.

Thanks

---

iffi

Answer 3

Hi imughal,

You can use this XSLT to display the user field.

<xsl:value-of select="substring-after(@ows_columnname,';#')" />

Please replace @ows_columname with the name of your user field.

Thanks & Regards,
Emir

---

Emir Liu

TechNet Community Support

Answer 4

Hi,

Thanks, it works.

One more issue Data view not showing complete list. my list view has 65 records and data view just showing 35.

Please tell me where is issue. thanks.

---

iffi

Answer 5

Hi imughal,

Please check the paging option under Option tab on SharePoint Designer ribbon and see if you have set a limit size to display for the data view web part. And if you need to display All items, please select "Display All Items".

Thanks & Regards,
Emir

---

Emir Liu

TechNet Community Support

Answer 6

Hi,

if i select all items its show items without paging but still not showing all records. i am getting list which has workflow enable. when i access view directly it shows all records but data webpart view not showing all records. 

pls guide.

thanks.

---

iffi

Answer 7

Hi imughal,

Please check the total number of items in the data source, you can check it in Data Source Details pane.

Will you get correct number here?

If no, please check

1. Do you get lists using Lists.asmx web services, do you get the data from certain view which has filter on it?
2. Do the account you bind to the SOAP data source have permission to view all items? If versions is enabled, do the account has permission to see draft item?

If yes, have you add any filter to the data view web part?

Thanks & Regards,
Emir

---

Emir Liu

TechNet Community Support

Answer 8

Hi,

i am getting list using Lists.asmx web services, in view setting under item option there was an entry of 35 it can not accept blank so i increase the limit now all items shown. is there any way to select all item without any limit.

now i need to filter my view based on current user, if i apply filter on view and show it on data view webpart it not display any record where access view directly with current user show records.

so please guide how to filter data view web part based on user.

thanks

---

iffi

Answer 9

Hi imughal,

Do you mean that SOAP data connection will not accept a list item that is blank? And could you tell us how do you increase the limit?

When people or group field get by Lists.asmx web services, it will return as this format: ID;#username. But current user filter is returned as: Domain\username. So it will return a empty data view web part.

A workaround is:

1. Create a parameter to get current login user account by creating a Server Variable paramete using "LOGON_USER" Server Variable Name.
http://social.technet.microsoft.com/Forums/en-US/sharepoint2010customization/thread/bf7183a8-87bd-49e3-b720-8c54cd6cb9e1

2. Use following XPath as the filter condition:

[substring-after(@columnname,';#') = substring-after($Param1,'\')]

Thanks & Regards,
Emir

---

Emir Liu

TechNet Community Support