Re: qeury other list using input from selected item in current list

Hi,

Thank you for the answer. I have figured out how to do it.
I used this site: http://blah.winsmarts.com/2007-10-Performing_joins_between_SharePoint_lists.aspx
and did some final adjustments in sharepoint designer.


On May 6, 10:04 am, "Tobias Zimmergren"
<tobias.zimmerg...@xxxxxxxxxxxx> wrote:
Hi,

If you decide to develop something yourself, have a look at the following:

Look into SPQuery and SPSiteDataQuery.
With SPQuery you can query a list based on a CAML (Collaborative Application
Markup Language) statement where you can specify what results you'd like.

Seehttp://www.zimmergren.net/archive/2008/05/05/how-to-easily-construct-....
for details on how you can construct your SPQuery.

Regarding SPSiteDataQuery, it's a class that allows you to "cross list
query" objects from different lists or objects in your site collection.
There's plenty of information about that on google :)

At least it's a starting point :)

Hope it helps

--
Best Regards,
Tobias Zimmergrenhttp://www.zimmergren.net

"Tribal" <phekkenb...@xxxxxxxxx> skrev i meddelandetnews:973a2d3c-1fd7-4135-9b2d-847759e057ee@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



Hello everyone,

I'm currently working on a sharepoint site where I want to manage a
lot of information sharing. I'm looking for something which I think
should be possible but I can't figure out how to do it.

I have two custom lists, one with general information about a database
and a second with queries for the databases. The list with query's is
quite basic. A description, the query and the database which the query
applies to (using a lookup value from the databases list). This al
works fine. I also want this to work the other way around, without
having to select the query's. So when I look at the details of a
database, I want to get a list of query's which are developed for the
specific database. All the information should be there, since I
specify a database for each query.

Any help would be appriciated. I think I might have to develop
something myself for this, so if anybody has an example on how to
that, that would be great!

Kind regards,- Hide quoted text -

- Show quoted text -

.

Relevant Pages

  • Re: A little more meat this week
    ... said data includes lists." ... implementation with a query processor capable of returning a result set ... then we can call it a result bag (SQL ... I'm looking at the data model and not database tools at this ...
    (comp.databases.pick)
  • Re: Append Query Problem
    ... Completed all steps including importing into a blank database. ... It is not an attached table, linked to a back end that is missing. ... If you are still stuck, see if this query returns your linklist table: ... there are 2 internal canonical lists of tables. ...
    (microsoft.public.access.queries)
  • Re: Data sources for different mailmerge letters
    ... try the following (I'm not going to go along the Query route ... In another database, I have Test B with "Verbal Comprehension" field, ... If you have two OALs (Office address lists) with identical data fields, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: qeury other list using input from selected item in current list
    ... With SPQuery you can query a list based on a CAML statement where you can specify what results you'd like. ... it's a class that allows you to "cross list query" objects from different lists or objects in your site collection. ... one with general information about a database ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Append Query Problem
    ... Completed all steps including importing into a blank database. ... > in the append query drop down. ... see if this query returns your linklist>> table: ... >> In Access 2000 and later, there are 2 internal canonical lists of>> tables. ...
    (microsoft.public.access.queries)