Timeline for Is it possible to use spquery in WCF for sharepoint
Current License: CC BY-SA 3.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 2, 2012 at 14:07 | comment | added | Alexander | No. I know that it is possible, but I have not got this task before ) | |
| Apr 2, 2012 at 13:57 | vote | accept | yogesh | ||
| Apr 2, 2012 at 13:43 | comment | added | Alexander | Sorry, but I can't help you (( I have never used Join in spquery before ( | |
| Apr 2, 2012 at 13:39 | comment | added | yogesh | Sorry i don't know how to display code in comment | |
| Apr 2, 2012 at 13:38 | comment | added | yogesh | The above is join query code.I am getting execption if the lookup is multivale if the lookup is not multivalue then working fine | |
| Apr 2, 2012 at 13:37 | comment | added | yogesh |
SPQuery listQueries = new SPQuery();listQueries.Query = "<Where><Eq><FieldRef Name='Title'/><Value Type='Text'>" + username + "</Value></Eq></Where>";listQueries.Joins = "<Join Type='Left' ListAlias='countryListAlias'><Eq><FieldRef Name='Country' RefType='ID'/><FieldRef List='countryListAlias' Name='ID'/></Eq></Join>";listQueries.ProjectedFields = "<Field Name='Code' List='countryListAlias' Type='Lookup' ShowField='Code'/>";listQueries.ViewFields = "<FieldRef List='countryListAlias' Name='Code' />";listQueries .ViewFieldsOnly = true;
|
|
| Apr 2, 2012 at 13:08 | comment | added | Alexander | This info lesser than you provided before. Could you provide a code that trows exception. Also you can try to test your query in U2U Caml Builder tool. | |
| Apr 2, 2012 at 13:03 | comment | added | yogesh |
Thanks i overcome this exception(I didn't end <Eq> taq).Now another exception <nativehr>0x80070057</nativehr> .I used multi value lookup for joining two lists.pls help
|
|
| Apr 2, 2012 at 11:28 | comment | added | Alexander | this exception does not give any helpful information that I can use to help you ( | |
| Apr 2, 2012 at 6:36 | comment | added | yogesh |
I can access client objects but when i test with wcftestclient exception shows Failed to invoke the service. Possible causes: The service is offline or inaccessible; the client-side configuration does not match the proxy; the existing proxy is invalid. Refer to the stack trace for more detail. You can try to recover by starting a new proxy, restoring to default configuration, or refreshing the service.
|
|
| Mar 23, 2012 at 14:25 | history | edited | Alexander | CC BY-SA 3.0 |
added 256 characters in body
|
| Mar 23, 2012 at 12:23 | history | answered | Alexander | CC BY-SA 3.0 |