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

Tech-Archive recommends: Speed Up your PC by fixing your registry

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.

See http://www.zimmergren.net/archive/2008/05/05/how-to-easily-construct-your-caml-queries-with-spquery.aspx 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 Zimmergren
http://www.zimmergren.net

"Tribal" <phekkenberg@xxxxxxxxx> skrev i meddelandet news: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,

.

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 (Collaborative Application ... query" objects from different lists or objects in your site collection. ... the query and the database which the query ...
    (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)