From: Hans F. <han...@gm...> - 2013-08-26 14:10:36
|
Hi, I tried to implement the employee / position example from Yaron's book. In short, an employee has a phone number and an email address and multiple past positions, each with a title, a start and an end date. So I created two templates, employee and position: Template:Employee [[Has phone number::{{{phone number|}}}]] [[Has email address::{{{email address|}}}]] Template:Position {{#subobject: |[[Has title::{{{title|}}}]] |[[Has start date::{{{start date|}}}]] |[[Has end date::{{{end date|}}}]] }} A page created with these forms would look like this: John Doe {{Employee |phone number=... |email address=... }} {{Position |title=Senior Professional |start date=August 2, 2013 |end date=August 3, 2013 }} {{Position |title=Junior Professional |start date=January 1, 2013 |end date=February 1, 2013 }} But when I query it on the same page using {{#ask:[[-Has subobject::{{FULLPAGENAME}}]] |?Has title |?Has start date |?Has end date |}} I do get two rows, but no entries in the cells... Where did the error occur? |
From: Hans F. <han...@gm...> - 2013-08-26 14:15:06
|
Hi, I tried to implement the employee / position example from Yaron's book. In short, an employee has a phone number and an email address and multiple past positions, each with a title, a start and an end date. So I created two templates, employee and position: Template:Employee [[Has phone number::{{{phone number|}}}]] [[Has email address::{{{email address|}}}]] Template:Position {{#subobject: |[[Has title::{{{title|}}}]] |[[Has start date::{{{start date|}}}]] |[[Has end date::{{{end date|}}}]] }} A page created with these forms would look like this: John Doe {{Employee |phone number=... |email address=... }} {{Position |title=Senior Professional |start date=August 2, 2013 |end date=August 3, 2013 }} {{Position |title=Junior Professional |start date=January 1, 2013 |end date=February 1, 2013 }} But when I query it on the same page using {{#ask:[[-Has subobject::{{FULLPAGENAME}}]] |?Has title |?Has start date |?Has end date |}} I do get two rows, but no entries in the cells... Where did the error occur? |
From: Yaron K. <ya...@wi...> - 2013-08-27 03:50:46
|
Hi Hans, There's an error in your #subobject syntax - it should look like: {{#subobject:Has title={{{title|}}}|...}} Also, I think it's useful for every #subobject call to point back to the page it's on, so I would add something like "|Is position of={{FULLPAGENAME}}" to the call. That way, you can query on "Is position of::{{FULLPAGENAME}}" instead of relying on "Has subobject". -Yaron On Mon, Aug 26, 2013 at 10:14 AM, Hans Faynmann <han...@gm...>wrote: > Hi, > I tried to implement the employee / position example from Yaron's book. > In short, an employee has a phone number and an email address and multiple > past positions, each with a title, a start and an end date. > So I created two templates, employee and position: > > Template:Employee > [[Has phone number::{{{phone number|}}}]] > [[Has email address::{{{email address|}}}]] > > Template:Position > {{#subobject: > |[[Has title::{{{title|}}}]] > |[[Has start date::{{{start date|}}}]] > |[[Has end date::{{{end date|}}}]] > }} > > A page created with these forms would look like this: > > John Doe > {{Employee > |phone number=... > |email address=... > }} > {{Position > |title=Senior Professional > |start date=August 2, 2013 > |end date=August 3, 2013 > }} > {{Position > |title=Junior Professional > |start date=January 1, 2013 > |end date=February 1, 2013 > }} > > But when I query it on the same page using > {{#ask:[[-Has subobject::{{FULLPAGENAME}}]] |?Has title |?Has start date > |?Has end date |}} > > I do get two rows, but no entries in the cells... > > Where did the error occur? > > ------------------------------------------------------------------------------ > Introducing Performance Central, a new site from SourceForge and > AppDynamics. Performance Central is your source for news, insights, > analysis and resources for efficient Application Performance Management. > Visit us today! > http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > -- WikiWorks · MediaWiki Consulting · http://wikiworks.com |
From: Hans F. <han...@gm...> - 2013-08-27 13:54:13
|
Thanks, that did the trick (obviously... I had a blackout). And thanks for the advice to use the additional call. I also need some support in building a car maker database: Let’s say I have a corporation [[Category:Corporations]] Each corporation has facilities [[Category:Facilities]] Then there are cars: Each car can be built in various facilities, each has its own building period (like the past and present positions of an employee in Yaron’s book) Example: - Corporation: BMW (address of headquarter, …) - Facility: Werk 1.1 (CORPORATION:BMW, address, …) - Car: BMW 3 Series Saloon (CORPORATION: BMW, model range: 3 series, ...) -- Subobjects Building period: --- Facility: Werk 1.1 --- Start of production: September 1, 2012 --- End of production: --- Facility: Werk 6.1 --- Start of production: November 22, 2012 --- End of production: How can I show a list on the page of BMW (how should the #ask call look like) that looks like: Facility, Car, Start of Production, End of Production And probably actually much more important: is this a good way to model the data? |
From: Yaron K. <ya...@wi...> - 2013-08-27 21:59:59
|
Hi Hans, This seems like a very reasonable data structure. Do you have such a query, that displays that information (or at least the last three columns) for a given facility? If so, you have two options: you can include on the BMW page a set of hardcoded queries showing that information, one for each facility; or you can have a query on all the facilities, in template format, and then create a template that contains that other query, given a passed-in facility name. The main query could look like: {{#ask:[[Facility of::BMW]]|format=template|template=Query for facility}} -Yaron On Tue, Aug 27, 2013 at 9:54 AM, Hans Faynmann <han...@gm...>wrote: > Thanks, that did the trick (obviously... I had a blackout). And thanks for > the advice to use the additional call. > > > I also need some support in building a car maker database: > > Let’s say I have a corporation [[Category:Corporations]] > > Each corporation has facilities [[Category:Facilities]] > > Then there are cars: Each car can be built in various facilities, each has > its own building period (like the past and present positions of an employee > in Yaron’s book) > > > Example: > > - Corporation: BMW (address of headquarter, …) > > - Facility: Werk 1.1 (CORPORATION:BMW, address, …) > > - Car: BMW 3 Series Saloon (CORPORATION: BMW, model range: 3 series, ...) > > -- Subobjects Building period: > > --- Facility: Werk 1.1 > > --- Start of production: September 1, 2012 > > --- End of production: > > > --- Facility: Werk 6.1 > > --- Start of production: November 22, 2012 > > --- End of production: > > > How can I show a list on the page of BMW (how should the #ask call look > like) that looks like: > > Facility, Car, Start of Production, End of Production > > > And probably actually much more important: is this a good way to model the > data? > > ------------------------------------------------------------------------------ > Introducing Performance Central, a new site from SourceForge and > AppDynamics. Performance Central is your source for news, insights, > analysis and resources for efficient Application Performance Management. > Visit us today! > http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > -- WikiWorks · MediaWiki Consulting · http://wikiworks.com |
From: Hans F. <han...@gm...> - 2013-08-28 08:27:42
|
Thanks, that's something I didn't think of doing first: querying every car a facility produces first... But even then, I need some advice on how to query for another page's subobjects. How can I query on the facility's page for all the cars that are produced there (with date), as the data is stored in the cars's subobjects? I would like to use "generic" queries instead of hardcoded ones as I would like to create a database of all car makers, populated by me and others and by using forms to fill in the data so that noone has to edit pages individually... Is there probably a possibility to nest queries in others? Like #ask: -has subobject:{{first result of query for cars by bmw}} ? 2013/8/27 Yaron Koren <ya...@wi...> > Hi Hans, > > This seems like a very reasonable data structure. Do you have such a > query, that displays that information (or at least the last three columns) > for a given facility? If so, you have two options: you can include on the > BMW page a set of hardcoded queries showing that information, one for each > facility; or you can have a query on all the facilities, in template > format, and then create a template that contains that other query, given a > passed-in facility name. The main query could look like: > > {{#ask:[[Facility of::BMW]]|format=template|template=Query for facility}} > > -Yaron > > > On Tue, Aug 27, 2013 at 9:54 AM, Hans Faynmann <han...@gm...>wrote: > >> Thanks, that did the trick (obviously... I had a blackout). And thanks for >> the advice to use the additional call. >> >> >> I also need some support in building a car maker database: >> >> Let’s say I have a corporation [[Category:Corporations]] >> >> Each corporation has facilities [[Category:Facilities]] >> >> Then there are cars: Each car can be built in various facilities, each has >> its own building period (like the past and present positions of an >> employee >> in Yaron’s book) >> >> >> Example: >> >> - Corporation: BMW (address of headquarter, …) >> >> - Facility: Werk 1.1 (CORPORATION:BMW, address, …) >> >> - Car: BMW 3 Series Saloon (CORPORATION: BMW, model range: 3 series, ...) >> >> -- Subobjects Building period: >> >> --- Facility: Werk 1.1 >> >> --- Start of production: September 1, 2012 >> >> --- End of production: >> >> >> --- Facility: Werk 6.1 >> >> --- Start of production: November 22, 2012 >> >> --- End of production: >> >> >> How can I show a list on the page of BMW (how should the #ask call look >> like) that looks like: >> >> Facility, Car, Start of Production, End of Production >> >> >> And probably actually much more important: is this a good way to model the >> data? >> >> ------------------------------------------------------------------------------ >> Introducing Performance Central, a new site from SourceForge and >> AppDynamics. Performance Central is your source for news, insights, >> analysis and resources for efficient Application Performance Management. >> Visit us today! >> >> http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk >> _______________________________________________ >> Semediawiki-user mailing list >> Sem...@li... >> https://lists.sourceforge.net/lists/listinfo/semediawiki-user >> > > > > -- > WikiWorks · MediaWiki Consulting · http://wikiworks.com > |
From: Yaron K. <ya...@wi...> - 2013-08-28 12:39:42
|
Hi, Well, each subobject is a "child" of both a car and a facility - so you could subdivide by either - though since the data is stored on car pages, it probably makes sense to subdivide by car, not by facility, contrary to what I said earlier. I don't know what your "Building period" template looks like, but the #subobject call should contain a property pointing back to the page. Then, it's just a matter of querying on "[[Has car::<car name>]]" or some such to get all the building periods for a certain car. -Yaron On Wed, Aug 28, 2013 at 4:27 AM, Hans Faynmann <han...@gm...>wrote: > Thanks, that's something I didn't think of doing first: querying every car > a facility produces first... > But even then, I need some advice on how to query for another page's > subobjects. > How can I query on the facility's page for all the cars that are produced > there (with date), as the data is stored in the cars's subobjects? > > I would like to use "generic" queries instead of hardcoded ones as I would > like to create a database of all car makers, populated by me and others and > by using forms to fill in the data so that noone has to edit pages > individually... > > Is there probably a possibility to nest queries in others? Like #ask: -has > subobject:{{first result of query for cars by bmw}} ? > > > 2013/8/27 Yaron Koren <ya...@wi...> > > > Hi Hans, > > > > This seems like a very reasonable data structure. Do you have such a > > query, that displays that information (or at least the last three > columns) > > for a given facility? If so, you have two options: you can include on the > > BMW page a set of hardcoded queries showing that information, one for > each > > facility; or you can have a query on all the facilities, in template > > format, and then create a template that contains that other query, given > a > > passed-in facility name. The main query could look like: > > > > {{#ask:[[Facility of::BMW]]|format=template|template=Query for facility}} > > > > -Yaron > > > > > > On Tue, Aug 27, 2013 at 9:54 AM, Hans Faynmann <han...@gm... > >wrote: > > > >> Thanks, that did the trick (obviously... I had a blackout). And thanks > for > >> the advice to use the additional call. > >> > >> > >> I also need some support in building a car maker database: > >> > >> Let’s say I have a corporation [[Category:Corporations]] > >> > >> Each corporation has facilities [[Category:Facilities]] > >> > >> Then there are cars: Each car can be built in various facilities, each > has > >> its own building period (like the past and present positions of an > >> employee > >> in Yaron’s book) > >> > >> > >> Example: > >> > >> - Corporation: BMW (address of headquarter, …) > >> > >> - Facility: Werk 1.1 (CORPORATION:BMW, address, …) > >> > >> - Car: BMW 3 Series Saloon (CORPORATION: BMW, model range: 3 series, > ...) > >> > >> -- Subobjects Building period: > >> > >> --- Facility: Werk 1.1 > >> > >> --- Start of production: September 1, 2012 > >> > >> --- End of production: > >> > >> > >> --- Facility: Werk 6.1 > >> > >> --- Start of production: November 22, 2012 > >> > >> --- End of production: > >> > >> > >> How can I show a list on the page of BMW (how should the #ask call look > >> like) that looks like: > >> > >> Facility, Car, Start of Production, End of Production > >> > >> > >> And probably actually much more important: is this a good way to model > the > >> data? > >> > >> > ------------------------------------------------------------------------------ > >> Introducing Performance Central, a new site from SourceForge and > >> AppDynamics. Performance Central is your source for news, insights, > >> analysis and resources for efficient Application Performance Management. > >> Visit us today! > >> > >> > http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk > >> _______________________________________________ > >> Semediawiki-user mailing list > >> Sem...@li... > >> https://lists.sourceforge.net/lists/listinfo/semediawiki-user > >> > > > > > > > > -- > > WikiWorks · MediaWiki Consulting · http://wikiworks.com > > > > ------------------------------------------------------------------------------ > Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! > Discover the easy way to master current and previous Microsoft technologies > and advance your career. Get an incredible 1,500+ hours of step-by-step > tutorial videos with LearnDevNow. Subscribe today and save! > http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > -- WikiWorks · MediaWiki Consulting · http://wikiworks.com |
From: Hans F. <han...@gm...> - 2013-08-28 13:29:33
|
Thanks to your answer I figured out how to query all the cars that are produced by a facility by putting this query on a facility-page: {{#ask:[[is building period of::+]] [[has facility::{{FULLPAGENAME}}]]| ?has build date start|?has facility}} with "is building period of" being the property pointing back to the page of the car. (You can find a sample facility here: http://wlw.referata.com/wiki/Werk_2.4 ) The subobject "Building period" is being created on the page "Cars". The page cars has - among the subobject and other properties the property "has corporation". The page facility has no subobjects, and among other properties the property "has corporation". You can find samples here: - Sample facility: http://wlw.referata.com/wiki/Werk_2.4 - Sample car: http://wlw.referata.com/wiki/BMW_3er_GT - Sample corporation: http://wlw.referata.com/wiki/BMW What should the query look like if I want to show all the facilities with every car that is produced there and its building period? Or the other way round: Show all the cars that are produced by the corporation with the respective facilities. 2013/8/28 Yaron Koren <ya...@wi...> > Hi, > > Well, each subobject is a "child" of both a car and a facility - so you > could subdivide by either - though since the data is stored on car pages, > it probably makes sense to subdivide by car, not by facility, contrary to > what I said earlier. > > I don't know what your "Building period" template looks like, but the > #subobject call should contain a property pointing back to the page. Then, > it's just a matter of querying on "[[Has car::<car name>]]" or some such to > get all the building periods for a certain car. > > -Yaron > > > On Wed, Aug 28, 2013 at 4:27 AM, Hans Faynmann <han...@gm...>wrote: > >> Thanks, that's something I didn't think of doing first: querying every car >> a facility produces first... >> But even then, I need some advice on how to query for another page's >> subobjects. >> How can I query on the facility's page for all the cars that are produced >> there (with date), as the data is stored in the cars's subobjects? >> >> I would like to use "generic" queries instead of hardcoded ones as I would >> like to create a database of all car makers, populated by me and others >> and >> by using forms to fill in the data so that noone has to edit pages >> individually... >> >> Is there probably a possibility to nest queries in others? Like #ask: -has >> subobject:{{first result of query for cars by bmw}} ? >> >> >> 2013/8/27 Yaron Koren <ya...@wi...> >> >> > Hi Hans, >> > >> > This seems like a very reasonable data structure. Do you have such a >> > query, that displays that information (or at least the last three >> columns) >> > for a given facility? If so, you have two options: you can include on >> the >> > BMW page a set of hardcoded queries showing that information, one for >> each >> > facility; or you can have a query on all the facilities, in template >> > format, and then create a template that contains that other query, >> given a >> > passed-in facility name. The main query could look like: >> > >> > {{#ask:[[Facility of::BMW]]|format=template|template=Query for >> facility}} >> > >> > -Yaron >> > >> > >> > On Tue, Aug 27, 2013 at 9:54 AM, Hans Faynmann <han...@gm... >> >wrote: >> > >> >> Thanks, that did the trick (obviously... I had a blackout). And thanks >> for >> >> the advice to use the additional call. >> >> >> >> >> >> I also need some support in building a car maker database: >> >> >> >> Let’s say I have a corporation [[Category:Corporations]] >> >> >> >> Each corporation has facilities [[Category:Facilities]] >> >> >> >> Then there are cars: Each car can be built in various facilities, each >> has >> >> its own building period (like the past and present positions of an >> >> employee >> >> in Yaron’s book) >> >> >> >> >> >> Example: >> >> >> >> - Corporation: BMW (address of headquarter, …) >> >> >> >> - Facility: Werk 1.1 (CORPORATION:BMW, address, …) >> >> >> >> - Car: BMW 3 Series Saloon (CORPORATION: BMW, model range: 3 series, >> ...) >> >> >> >> -- Subobjects Building period: >> >> >> >> --- Facility: Werk 1.1 >> >> >> >> --- Start of production: September 1, 2012 >> >> >> >> --- End of production: >> >> >> >> >> >> --- Facility: Werk 6.1 >> >> >> >> --- Start of production: November 22, 2012 >> >> >> >> --- End of production: >> >> >> >> >> >> How can I show a list on the page of BMW (how should the #ask call look >> >> like) that looks like: >> >> >> >> Facility, Car, Start of Production, End of Production >> >> >> >> >> >> And probably actually much more important: is this a good way to model >> the >> >> data? >> >> >> >> >> ------------------------------------------------------------------------------ >> >> Introducing Performance Central, a new site from SourceForge and >> >> AppDynamics. Performance Central is your source for news, insights, >> >> analysis and resources for efficient Application Performance >> Management. >> >> Visit us today! >> >> >> >> >> http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk >> >> _______________________________________________ >> >> Semediawiki-user mailing list >> >> Sem...@li... >> >> https://lists.sourceforge.net/lists/listinfo/semediawiki-user >> >> >> > >> > >> > >> > -- >> > WikiWorks · MediaWiki Consulting · http://wikiworks.com >> > >> >> ------------------------------------------------------------------------------ >> Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! >> Discover the easy way to master current and previous Microsoft >> technologies >> and advance your career. Get an incredible 1,500+ hours of step-by-step >> tutorial videos with LearnDevNow. Subscribe today and save! >> >> http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk >> >> _______________________________________________ >> Semediawiki-user mailing list >> Sem...@li... >> https://lists.sourceforge.net/lists/listinfo/semediawiki-user >> > > > > -- > WikiWorks · MediaWiki Consulting · http://wikiworks.com > |
From: Yaron K. <ya...@wi...> - 2013-08-29 02:13:25
|
Hi, See my previous answer for that - you either need to hardcode the list, or use a templated query result. On Wed, Aug 28, 2013 at 9:29 AM, Hans Faynmann <han...@gm...>wrote: > Thanks to your answer I figured out how to query all the cars that are > produced by a facility by putting this query on a facility-page: > {{#ask:[[is building period of::+]] [[has facility::{{FULLPAGENAME}}]]| > ?has build date start|?has facility}} > > with "is building period of" being the property pointing back to the page > of the car. > (You can find a sample facility here: > http://wlw.referata.com/wiki/Werk_2.4 > ) > > The subobject "Building period" is being created on the page "Cars". > > The page cars has - among the subobject and other properties the property > "has corporation". > > The page facility has no subobjects, and among other properties the > property "has corporation". > > You can find samples here: > - Sample facility: http://wlw.referata.com/wiki/Werk_2.4 > - Sample car: http://wlw.referata.com/wiki/BMW_3er_GT > - Sample corporation: http://wlw.referata.com/wiki/BMW > > What should the query look like if I want to show all the facilities with > every car that is produced there and its building period? > Or the other way round: Show all the cars that are produced by the > corporation with the respective facilities. > > > 2013/8/28 Yaron Koren <ya...@wi...> > > > Hi, > > > > Well, each subobject is a "child" of both a car and a facility - so you > > could subdivide by either - though since the data is stored on car pages, > > it probably makes sense to subdivide by car, not by facility, contrary to > > what I said earlier. > > > > I don't know what your "Building period" template looks like, but the > > #subobject call should contain a property pointing back to the page. > Then, > > it's just a matter of querying on "[[Has car::<car name>]]" or some such > to > > get all the building periods for a certain car. > > > > -Yaron > > > > > > On Wed, Aug 28, 2013 at 4:27 AM, Hans Faynmann <han...@gm... > >wrote: > > > >> Thanks, that's something I didn't think of doing first: querying every > car > >> a facility produces first... > >> But even then, I need some advice on how to query for another page's > >> subobjects. > >> How can I query on the facility's page for all the cars that are > produced > >> there (with date), as the data is stored in the cars's subobjects? > >> > >> I would like to use "generic" queries instead of hardcoded ones as I > would > >> like to create a database of all car makers, populated by me and others > >> and > >> by using forms to fill in the data so that noone has to edit pages > >> individually... > >> > >> Is there probably a possibility to nest queries in others? Like #ask: > -has > >> subobject:{{first result of query for cars by bmw}} ? > >> > >> > >> 2013/8/27 Yaron Koren <ya...@wi...> > >> > >> > Hi Hans, > >> > > >> > This seems like a very reasonable data structure. Do you have such a > >> > query, that displays that information (or at least the last three > >> columns) > >> > for a given facility? If so, you have two options: you can include on > >> the > >> > BMW page a set of hardcoded queries showing that information, one for > >> each > >> > facility; or you can have a query on all the facilities, in template > >> > format, and then create a template that contains that other query, > >> given a > >> > passed-in facility name. The main query could look like: > >> > > >> > {{#ask:[[Facility of::BMW]]|format=template|template=Query for > >> facility}} > >> > > >> > -Yaron > >> > > >> > > >> > On Tue, Aug 27, 2013 at 9:54 AM, Hans Faynmann < > han...@gm... > >> >wrote: > >> > > >> >> Thanks, that did the trick (obviously... I had a blackout). And > thanks > >> for > >> >> the advice to use the additional call. > >> >> > >> >> > >> >> I also need some support in building a car maker database: > >> >> > >> >> Let’s say I have a corporation [[Category:Corporations]] > >> >> > >> >> Each corporation has facilities [[Category:Facilities]] > >> >> > >> >> Then there are cars: Each car can be built in various facilities, > each > >> has > >> >> its own building period (like the past and present positions of an > >> >> employee > >> >> in Yaron’s book) > >> >> > >> >> > >> >> Example: > >> >> > >> >> - Corporation: BMW (address of headquarter, …) > >> >> > >> >> - Facility: Werk 1.1 (CORPORATION:BMW, address, …) > >> >> > >> >> - Car: BMW 3 Series Saloon (CORPORATION: BMW, model range: 3 series, > >> ...) > >> >> > >> >> -- Subobjects Building period: > >> >> > >> >> --- Facility: Werk 1.1 > >> >> > >> >> --- Start of production: September 1, 2012 > >> >> > >> >> --- End of production: > >> >> > >> >> > >> >> --- Facility: Werk 6.1 > >> >> > >> >> --- Start of production: November 22, 2012 > >> >> > >> >> --- End of production: > >> >> > >> >> > >> >> How can I show a list on the page of BMW (how should the #ask call > look > >> >> like) that looks like: > >> >> > >> >> Facility, Car, Start of Production, End of Production > >> >> > >> >> > >> >> And probably actually much more important: is this a good way to > model > >> the > >> >> data? > >> >> > >> >> > >> > ------------------------------------------------------------------------------ > >> >> Introducing Performance Central, a new site from SourceForge and > >> >> AppDynamics. Performance Central is your source for news, insights, > >> >> analysis and resources for efficient Application Performance > >> Management. > >> >> Visit us today! > >> >> > >> >> > >> > http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk > >> >> _______________________________________________ > >> >> Semediawiki-user mailing list > >> >> Sem...@li... > >> >> https://lists.sourceforge.net/lists/listinfo/semediawiki-user > >> >> > >> > > >> > > >> > > >> > -- > >> > WikiWorks · MediaWiki Consulting · http://wikiworks.com > >> > > >> > >> > ------------------------------------------------------------------------------ > >> Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! > >> Discover the easy way to master current and previous Microsoft > >> technologies > >> and advance your career. Get an incredible 1,500+ hours of step-by-step > >> tutorial videos with LearnDevNow. Subscribe today and save! > >> > >> > http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk > >> > >> _______________________________________________ > >> Semediawiki-user mailing list > >> Sem...@li... > >> https://lists.sourceforge.net/lists/listinfo/semediawiki-user > >> > > > > > > > > -- > > WikiWorks · MediaWiki Consulting · http://wikiworks.com > > > > ------------------------------------------------------------------------------ > Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! > Discover the easy way to master current and previous Microsoft technologies > and advance your career. Get an incredible 1,500+ hours of step-by-step > tutorial videos with LearnDevNow. Subscribe today and save! > http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > -- WikiWorks · MediaWiki Consulting · http://wikiworks.com |
From: Hans F. <han...@gm...> - 2013-08-31 17:18:44
|
Hi, thanks again, I think I got it now. But after displaying the results, I get an error stating: The part "|BMW Werk 1.1" of the query was not understood. Results might not be as expected. The part "]]" of the query was not understood. Results might not be as expected. My queries: In BMW's page (the corporation): {{#ask: [[Category:Facilities]] [[has corporation::{{FULLPAGENAME}}]] | format=template | template=QueryForCar }} Query in template "QueryForCar": {{#ask: [[has facility::{{{1}}}]] |?has code name |?has facility |?has build date start |?has build date end }} If I "hardcode" the query like "has facility: Werk 2.4" I don't get an error... I think I have to do something before passing the parameter that goes into {{{1}}}?!? 2013/8/29 Yaron Koren <ya...@wi...> > Hi, > > See my previous answer for that - you either need to hardcode the list, or > use a templated query result. > > > On Wed, Aug 28, 2013 at 9:29 AM, Hans Faynmann <han...@gm...>wrote: > >> Thanks to your answer I figured out how to query all the cars that are >> produced by a facility by putting this query on a facility-page: >> {{#ask:[[is building period of::+]] [[has facility::{{FULLPAGENAME}}]]| >> ?has build date start|?has facility}} >> >> with "is building period of" being the property pointing back to the page >> of the car. >> (You can find a sample facility here: >> http://wlw.referata.com/wiki/Werk_2.4 >> ) >> >> The subobject "Building period" is being created on the page "Cars". >> >> The page cars has - among the subobject and other properties the property >> "has corporation". >> >> The page facility has no subobjects, and among other properties the >> property "has corporation". >> >> You can find samples here: >> - Sample facility: http://wlw.referata.com/wiki/Werk_2.4 >> - Sample car: http://wlw.referata.com/wiki/BMW_3er_GT >> - Sample corporation: http://wlw.referata.com/wiki/BMW >> >> What should the query look like if I want to show all the facilities with >> every car that is produced there and its building period? >> Or the other way round: Show all the cars that are produced by the >> corporation with the respective facilities. >> >> >> 2013/8/28 Yaron Koren <ya...@wi...> >> >> > Hi, >> > >> > Well, each subobject is a "child" of both a car and a facility - so you >> > could subdivide by either - though since the data is stored on car >> pages, >> > it probably makes sense to subdivide by car, not by facility, contrary >> to >> > what I said earlier. >> > >> > I don't know what your "Building period" template looks like, but the >> > #subobject call should contain a property pointing back to the page. >> Then, >> > it's just a matter of querying on "[[Has car::<car name>]]" or some >> such to >> > get all the building periods for a certain car. >> > >> > -Yaron >> > >> > >> > On Wed, Aug 28, 2013 at 4:27 AM, Hans Faynmann <han...@gm... >> >wrote: >> > >> >> Thanks, that's something I didn't think of doing first: querying every >> car >> >> a facility produces first... >> >> But even then, I need some advice on how to query for another page's >> >> subobjects. >> >> How can I query on the facility's page for all the cars that are >> produced >> >> there (with date), as the data is stored in the cars's subobjects? >> >> >> >> I would like to use "generic" queries instead of hardcoded ones as I >> would >> >> like to create a database of all car makers, populated by me and others >> >> and >> >> by using forms to fill in the data so that noone has to edit pages >> >> individually... >> >> >> >> Is there probably a possibility to nest queries in others? Like #ask: >> -has >> >> subobject:{{first result of query for cars by bmw}} ? >> >> >> >> >> >> 2013/8/27 Yaron Koren <ya...@wi...> >> >> >> >> > Hi Hans, >> >> > >> >> > This seems like a very reasonable data structure. Do you have such a >> >> > query, that displays that information (or at least the last three >> >> columns) >> >> > for a given facility? If so, you have two options: you can include on >> >> the >> >> > BMW page a set of hardcoded queries showing that information, one for >> >> each >> >> > facility; or you can have a query on all the facilities, in template >> >> > format, and then create a template that contains that other query, >> >> given a >> >> > passed-in facility name. The main query could look like: >> >> > >> >> > {{#ask:[[Facility of::BMW]]|format=template|template=Query for >> >> facility}} >> >> > >> >> > -Yaron >> >> > >> >> > >> >> > On Tue, Aug 27, 2013 at 9:54 AM, Hans Faynmann < >> han...@gm... >> >> >wrote: >> >> > >> >> >> Thanks, that did the trick (obviously... I had a blackout). And >> thanks >> >> for >> >> >> the advice to use the additional call. >> >> >> >> >> >> >> >> >> I also need some support in building a car maker database: >> >> >> >> >> >> Let’s say I have a corporation [[Category:Corporations]] >> >> >> >> >> >> Each corporation has facilities [[Category:Facilities]] >> >> >> >> >> >> Then there are cars: Each car can be built in various facilities, >> each >> >> has >> >> >> its own building period (like the past and present positions of an >> >> >> employee >> >> >> in Yaron’s book) >> >> >> >> >> >> >> >> >> Example: >> >> >> >> >> >> - Corporation: BMW (address of headquarter, …) >> >> >> >> >> >> - Facility: Werk 1.1 (CORPORATION:BMW, address, …) >> >> >> >> >> >> - Car: BMW 3 Series Saloon (CORPORATION: BMW, model range: 3 series, >> >> ...) >> >> >> >> >> >> -- Subobjects Building period: >> >> >> >> >> >> --- Facility: Werk 1.1 >> >> >> >> >> >> --- Start of production: September 1, 2012 >> >> >> >> >> >> --- End of production: >> >> >> >> >> >> >> >> >> --- Facility: Werk 6.1 >> >> >> >> >> >> --- Start of production: November 22, 2012 >> >> >> >> >> >> --- End of production: >> >> >> >> >> >> >> >> >> How can I show a list on the page of BMW (how should the #ask call >> look >> >> >> like) that looks like: >> >> >> >> >> >> Facility, Car, Start of Production, End of Production >> >> >> >> >> >> >> >> >> And probably actually much more important: is this a good way to >> model >> >> the >> >> >> data? >> >> >> >> >> >> >> >> >> ------------------------------------------------------------------------------ >> >> >> Introducing Performance Central, a new site from SourceForge and >> >> >> AppDynamics. Performance Central is your source for news, insights, >> >> >> analysis and resources for efficient Application Performance >> >> Management. >> >> >> Visit us today! >> >> >> >> >> >> >> >> >> http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk >> >> >> _______________________________________________ >> >> >> Semediawiki-user mailing list >> >> >> Sem...@li... >> >> >> https://lists.sourceforge.net/lists/listinfo/semediawiki-user >> >> >> >> >> > >> >> > >> >> > >> >> > -- >> >> > WikiWorks · MediaWiki Consulting · http://wikiworks.com >> >> > >> >> >> >> >> ------------------------------------------------------------------------------ >> >> Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! >> >> Discover the easy way to master current and previous Microsoft >> >> technologies >> >> and advance your career. Get an incredible 1,500+ hours of step-by-step >> >> tutorial videos with LearnDevNow. Subscribe today and save! >> >> >> >> >> http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk >> >> >> >> _______________________________________________ >> >> Semediawiki-user mailing list >> >> Sem...@li... >> >> https://lists.sourceforge.net/lists/listinfo/semediawiki-user >> >> >> > >> > >> > >> > -- >> > WikiWorks · MediaWiki Consulting · http://wikiworks.com >> > >> >> ------------------------------------------------------------------------------ >> Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! >> Discover the easy way to master current and previous Microsoft >> technologies >> and advance your career. Get an incredible 1,500+ hours of step-by-step >> tutorial videos with LearnDevNow. Subscribe today and save! >> >> http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk >> _______________________________________________ >> Semediawiki-user mailing list >> Sem...@li... >> https://lists.sourceforge.net/lists/listinfo/semediawiki-user >> > > > > -- > WikiWorks · MediaWiki Consulting · http://wikiworks.com > |
From: Hans F. <han...@gm...> - 2013-08-31 17:31:31
|
Okay, I tried naming the parameter with named args=yes and it worked. But as output, I get separate tables for each factory. Is it possible to get all the information in one big table so one could sort it? 2013/8/31 Hans Faynmann <han...@gm...> > Hi, > thanks again, I think I got it now. > But after displaying the results, I get an error stating: > > The part "|BMW Werk 1.1" of the query was not understood. > Results might not be as expected. > The part "]]" of the query was not understood. Results might not be as > expected. > > > My queries: > In BMW's page (the corporation): > {{#ask: > [[Category:Facilities]] > [[has corporation::{{FULLPAGENAME}}]] > | format=template > | template=QueryForCar > }} > > Query in template "QueryForCar": > {{#ask: > [[has facility::{{{1}}}]] > |?has code name > |?has facility > |?has build date start > |?has build date end > }} > > If I "hardcode" the query like "has facility: Werk 2.4" I don't get an > error... > > I think I have to do something before passing the parameter that goes into > {{{1}}}?!? > > > > 2013/8/29 Yaron Koren <ya...@wi...> > >> Hi, >> >> See my previous answer for that - you either need to hardcode the list, >> or use a templated query result. >> >> >> On Wed, Aug 28, 2013 at 9:29 AM, Hans Faynmann <han...@gm...>wrote: >> >>> Thanks to your answer I figured out how to query all the cars that are >>> produced by a facility by putting this query on a facility-page: >>> {{#ask:[[is building period of::+]] [[has facility::{{FULLPAGENAME}}]]| >>> ?has build date start|?has facility}} >>> >>> with "is building period of" being the property pointing back to the page >>> of the car. >>> (You can find a sample facility here: >>> http://wlw.referata.com/wiki/Werk_2.4 >>> ) >>> >>> The subobject "Building period" is being created on the page "Cars". >>> >>> The page cars has - among the subobject and other properties the property >>> "has corporation". >>> >>> The page facility has no subobjects, and among other properties the >>> property "has corporation". >>> >>> You can find samples here: >>> - Sample facility: http://wlw.referata.com/wiki/Werk_2.4 >>> - Sample car: http://wlw.referata.com/wiki/BMW_3er_GT >>> - Sample corporation: http://wlw.referata.com/wiki/BMW >>> >>> What should the query look like if I want to show all the facilities with >>> every car that is produced there and its building period? >>> Or the other way round: Show all the cars that are produced by the >>> corporation with the respective facilities. >>> >>> >>> 2013/8/28 Yaron Koren <ya...@wi...> >>> >>> > Hi, >>> > >>> > Well, each subobject is a "child" of both a car and a facility - so you >>> > could subdivide by either - though since the data is stored on car >>> pages, >>> > it probably makes sense to subdivide by car, not by facility, contrary >>> to >>> > what I said earlier. >>> > >>> > I don't know what your "Building period" template looks like, but the >>> > #subobject call should contain a property pointing back to the page. >>> Then, >>> > it's just a matter of querying on "[[Has car::<car name>]]" or some >>> such to >>> > get all the building periods for a certain car. >>> > >>> > -Yaron >>> > >>> > >>> > On Wed, Aug 28, 2013 at 4:27 AM, Hans Faynmann < >>> han...@gm...>wrote: >>> > >>> >> Thanks, that's something I didn't think of doing first: querying >>> every car >>> >> a facility produces first... >>> >> But even then, I need some advice on how to query for another page's >>> >> subobjects. >>> >> How can I query on the facility's page for all the cars that are >>> produced >>> >> there (with date), as the data is stored in the cars's subobjects? >>> >> >>> >> I would like to use "generic" queries instead of hardcoded ones as I >>> would >>> >> like to create a database of all car makers, populated by me and >>> others >>> >> and >>> >> by using forms to fill in the data so that noone has to edit pages >>> >> individually... >>> >> >>> >> Is there probably a possibility to nest queries in others? Like #ask: >>> -has >>> >> subobject:{{first result of query for cars by bmw}} ? >>> >> >>> >> >>> >> 2013/8/27 Yaron Koren <ya...@wi...> >>> >> >>> >> > Hi Hans, >>> >> > >>> >> > This seems like a very reasonable data structure. Do you have such a >>> >> > query, that displays that information (or at least the last three >>> >> columns) >>> >> > for a given facility? If so, you have two options: you can include >>> on >>> >> the >>> >> > BMW page a set of hardcoded queries showing that information, one >>> for >>> >> each >>> >> > facility; or you can have a query on all the facilities, in template >>> >> > format, and then create a template that contains that other query, >>> >> given a >>> >> > passed-in facility name. The main query could look like: >>> >> > >>> >> > {{#ask:[[Facility of::BMW]]|format=template|template=Query for >>> >> facility}} >>> >> > >>> >> > -Yaron >>> >> > >>> >> > >>> >> > On Tue, Aug 27, 2013 at 9:54 AM, Hans Faynmann < >>> han...@gm... >>> >> >wrote: >>> >> > >>> >> >> Thanks, that did the trick (obviously... I had a blackout). And >>> thanks >>> >> for >>> >> >> the advice to use the additional call. >>> >> >> >>> >> >> >>> >> >> I also need some support in building a car maker database: >>> >> >> >>> >> >> Let’s say I have a corporation [[Category:Corporations]] >>> >> >> >>> >> >> Each corporation has facilities [[Category:Facilities]] >>> >> >> >>> >> >> Then there are cars: Each car can be built in various facilities, >>> each >>> >> has >>> >> >> its own building period (like the past and present positions of an >>> >> >> employee >>> >> >> in Yaron’s book) >>> >> >> >>> >> >> >>> >> >> Example: >>> >> >> >>> >> >> - Corporation: BMW (address of headquarter, …) >>> >> >> >>> >> >> - Facility: Werk 1.1 (CORPORATION:BMW, address, …) >>> >> >> >>> >> >> - Car: BMW 3 Series Saloon (CORPORATION: BMW, model range: 3 >>> series, >>> >> ...) >>> >> >> >>> >> >> -- Subobjects Building period: >>> >> >> >>> >> >> --- Facility: Werk 1.1 >>> >> >> >>> >> >> --- Start of production: September 1, 2012 >>> >> >> >>> >> >> --- End of production: >>> >> >> >>> >> >> >>> >> >> --- Facility: Werk 6.1 >>> >> >> >>> >> >> --- Start of production: November 22, 2012 >>> >> >> >>> >> >> --- End of production: >>> >> >> >>> >> >> >>> >> >> How can I show a list on the page of BMW (how should the #ask call >>> look >>> >> >> like) that looks like: >>> >> >> >>> >> >> Facility, Car, Start of Production, End of Production >>> >> >> >>> >> >> >>> >> >> And probably actually much more important: is this a good way to >>> model >>> >> the >>> >> >> data? >>> >> >> >>> >> >> >>> >> >>> ------------------------------------------------------------------------------ >>> >> >> Introducing Performance Central, a new site from SourceForge and >>> >> >> AppDynamics. Performance Central is your source for news, insights, >>> >> >> analysis and resources for efficient Application Performance >>> >> Management. >>> >> >> Visit us today! >>> >> >> >>> >> >> >>> >> >>> http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk >>> >> >> _______________________________________________ >>> >> >> Semediawiki-user mailing list >>> >> >> Sem...@li... >>> >> >> https://lists.sourceforge.net/lists/listinfo/semediawiki-user >>> >> >> >>> >> > >>> >> > >>> >> > >>> >> > -- >>> >> > WikiWorks · MediaWiki Consulting · http://wikiworks.com >>> >> > >>> >> >>> >> >>> ------------------------------------------------------------------------------ >>> >> Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! >>> >> Discover the easy way to master current and previous Microsoft >>> >> technologies >>> >> and advance your career. Get an incredible 1,500+ hours of >>> step-by-step >>> >> tutorial videos with LearnDevNow. Subscribe today and save! >>> >> >>> >> >>> http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk >>> >> >>> >> _______________________________________________ >>> >> Semediawiki-user mailing list >>> >> Sem...@li... >>> >> https://lists.sourceforge.net/lists/listinfo/semediawiki-user >>> >> >>> > >>> > >>> > >>> > -- >>> > WikiWorks · MediaWiki Consulting · http://wikiworks.com >>> > >>> >>> ------------------------------------------------------------------------------ >>> Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! >>> Discover the easy way to master current and previous Microsoft >>> technologies >>> and advance your career. Get an incredible 1,500+ hours of step-by-step >>> tutorial videos with LearnDevNow. Subscribe today and save! >>> >>> http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk >>> _______________________________________________ >>> Semediawiki-user mailing list >>> Sem...@li... >>> https://lists.sourceforge.net/lists/listinfo/semediawiki-user >>> >> >> >> >> -- >> WikiWorks · MediaWiki Consulting · http://wikiworks.com >> > > |
From: Hans F. <han...@gm...> - 2013-09-01 10:09:13
|
If I hardcode the query on the corporation's page like: {{#ask: [[has facility::Werk 2.4||BMW Werk 1.1]] |?has code name |?has facility |?has build date start |?has build date end |?has city }} I get everything in a table. Is it possible to get something like Werk 2.4||BMW Werk 1.1 out of a query and put it into another query? Is using the Array-extension useful or is it too much of a hassle for something like this? Or is there another way in putting all information in one table? 2013/8/31 Hans Faynmann <han...@gm...> > Okay, I tried naming the parameter with named args=yes and it worked. > > But as output, I get separate tables for each factory. > Is it possible to get all the information in one big table so one could > sort it? > > > > 2013/8/31 Hans Faynmann <han...@gm...> > >> Hi, >> thanks again, I think I got it now. >> But after displaying the results, I get an error stating: >> >> The part "|BMW Werk 1.1" of the query was not understood. >> Results might not be as expected. >> The part "]]" of the query was not understood. Results might not be as >> expected. >> >> >> My queries: >> In BMW's page (the corporation): >> {{#ask: >> [[Category:Facilities]] >> [[has corporation::{{FULLPAGENAME}}]] >> | format=template >> | template=QueryForCar >> }} >> >> Query in template "QueryForCar": >> {{#ask: >> [[has facility::{{{1}}}]] >> |?has code name >> |?has facility >> |?has build date start >> |?has build date end >> }} >> >> If I "hardcode" the query like "has facility: Werk 2.4" I don't get an >> error... >> >> I think I have to do something before passing the parameter that goes >> into {{{1}}}?!? >> >> >> >> 2013/8/29 Yaron Koren <ya...@wi...> >> >>> Hi, >>> >>> See my previous answer for that - you either need to hardcode the list, >>> or use a templated query result. >>> >>> >>> On Wed, Aug 28, 2013 at 9:29 AM, Hans Faynmann <han...@gm...>wrote: >>> >>>> Thanks to your answer I figured out how to query all the cars that are >>>> produced by a facility by putting this query on a facility-page: >>>> {{#ask:[[is building period of::+]] [[has facility::{{FULLPAGENAME}}]]| >>>> ?has build date start|?has facility}} >>>> >>>> with "is building period of" being the property pointing back to the >>>> page >>>> of the car. >>>> (You can find a sample facility here: >>>> http://wlw.referata.com/wiki/Werk_2.4 >>>> ) >>>> >>>> The subobject "Building period" is being created on the page "Cars". >>>> >>>> The page cars has - among the subobject and other properties the >>>> property >>>> "has corporation". >>>> >>>> The page facility has no subobjects, and among other properties the >>>> property "has corporation". >>>> >>>> You can find samples here: >>>> - Sample facility: http://wlw.referata.com/wiki/Werk_2.4 >>>> - Sample car: http://wlw.referata.com/wiki/BMW_3er_GT >>>> - Sample corporation: http://wlw.referata.com/wiki/BMW >>>> >>>> What should the query look like if I want to show all the facilities >>>> with >>>> every car that is produced there and its building period? >>>> Or the other way round: Show all the cars that are produced by the >>>> corporation with the respective facilities. >>>> >>>> >>>> 2013/8/28 Yaron Koren <ya...@wi...> >>>> >>>> > Hi, >>>> > >>>> > Well, each subobject is a "child" of both a car and a facility - so >>>> you >>>> > could subdivide by either - though since the data is stored on car >>>> pages, >>>> > it probably makes sense to subdivide by car, not by facility, >>>> contrary to >>>> > what I said earlier. >>>> > >>>> > I don't know what your "Building period" template looks like, but the >>>> > #subobject call should contain a property pointing back to the page. >>>> Then, >>>> > it's just a matter of querying on "[[Has car::<car name>]]" or some >>>> such to >>>> > get all the building periods for a certain car. >>>> > >>>> > -Yaron >>>> > >>>> > >>>> > On Wed, Aug 28, 2013 at 4:27 AM, Hans Faynmann < >>>> han...@gm...>wrote: >>>> > >>>> >> Thanks, that's something I didn't think of doing first: querying >>>> every car >>>> >> a facility produces first... >>>> >> But even then, I need some advice on how to query for another page's >>>> >> subobjects. >>>> >> How can I query on the facility's page for all the cars that are >>>> produced >>>> >> there (with date), as the data is stored in the cars's subobjects? >>>> >> >>>> >> I would like to use "generic" queries instead of hardcoded ones as I >>>> would >>>> >> like to create a database of all car makers, populated by me and >>>> others >>>> >> and >>>> >> by using forms to fill in the data so that noone has to edit pages >>>> >> individually... >>>> >> >>>> >> Is there probably a possibility to nest queries in others? Like >>>> #ask: -has >>>> >> subobject:{{first result of query for cars by bmw}} ? >>>> >> >>>> >> >>>> >> 2013/8/27 Yaron Koren <ya...@wi...> >>>> >> >>>> >> > Hi Hans, >>>> >> > >>>> >> > This seems like a very reasonable data structure. Do you have such >>>> a >>>> >> > query, that displays that information (or at least the last three >>>> >> columns) >>>> >> > for a given facility? If so, you have two options: you can include >>>> on >>>> >> the >>>> >> > BMW page a set of hardcoded queries showing that information, one >>>> for >>>> >> each >>>> >> > facility; or you can have a query on all the facilities, in >>>> template >>>> >> > format, and then create a template that contains that other query, >>>> >> given a >>>> >> > passed-in facility name. The main query could look like: >>>> >> > >>>> >> > {{#ask:[[Facility of::BMW]]|format=template|template=Query for >>>> >> facility}} >>>> >> > >>>> >> > -Yaron >>>> >> > >>>> >> > >>>> >> > On Tue, Aug 27, 2013 at 9:54 AM, Hans Faynmann < >>>> han...@gm... >>>> >> >wrote: >>>> >> > >>>> >> >> Thanks, that did the trick (obviously... I had a blackout). And >>>> thanks >>>> >> for >>>> >> >> the advice to use the additional call. >>>> >> >> >>>> >> >> >>>> >> >> I also need some support in building a car maker database: >>>> >> >> >>>> >> >> Let’s say I have a corporation [[Category:Corporations]] >>>> >> >> >>>> >> >> Each corporation has facilities [[Category:Facilities]] >>>> >> >> >>>> >> >> Then there are cars: Each car can be built in various facilities, >>>> each >>>> >> has >>>> >> >> its own building period (like the past and present positions of an >>>> >> >> employee >>>> >> >> in Yaron’s book) >>>> >> >> >>>> >> >> >>>> >> >> Example: >>>> >> >> >>>> >> >> - Corporation: BMW (address of headquarter, …) >>>> >> >> >>>> >> >> - Facility: Werk 1.1 (CORPORATION:BMW, address, …) >>>> >> >> >>>> >> >> - Car: BMW 3 Series Saloon (CORPORATION: BMW, model range: 3 >>>> series, >>>> >> ...) >>>> >> >> >>>> >> >> -- Subobjects Building period: >>>> >> >> >>>> >> >> --- Facility: Werk 1.1 >>>> >> >> >>>> >> >> --- Start of production: September 1, 2012 >>>> >> >> >>>> >> >> --- End of production: >>>> >> >> >>>> >> >> >>>> >> >> --- Facility: Werk 6.1 >>>> >> >> >>>> >> >> --- Start of production: November 22, 2012 >>>> >> >> >>>> >> >> --- End of production: >>>> >> >> >>>> >> >> >>>> >> >> How can I show a list on the page of BMW (how should the #ask >>>> call look >>>> >> >> like) that looks like: >>>> >> >> >>>> >> >> Facility, Car, Start of Production, End of Production >>>> >> >> >>>> >> >> >>>> >> >> And probably actually much more important: is this a good way to >>>> model >>>> >> the >>>> >> >> data? >>>> >> >> >>>> >> >> >>>> >> >>>> ------------------------------------------------------------------------------ >>>> >> >> Introducing Performance Central, a new site from SourceForge and >>>> >> >> AppDynamics. Performance Central is your source for news, >>>> insights, >>>> >> >> analysis and resources for efficient Application Performance >>>> >> Management. >>>> >> >> Visit us today! >>>> >> >> >>>> >> >> >>>> >> >>>> http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk >>>> >> >> _______________________________________________ >>>> >> >> Semediawiki-user mailing list >>>> >> >> Sem...@li... >>>> >> >> https://lists.sourceforge.net/lists/listinfo/semediawiki-user >>>> >> >> >>>> >> > >>>> >> > >>>> >> > >>>> >> > -- >>>> >> > WikiWorks · MediaWiki Consulting · http://wikiworks.com >>>> >> > >>>> >> >>>> >> >>>> ------------------------------------------------------------------------------ >>>> >> Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, >>>> more! >>>> >> Discover the easy way to master current and previous Microsoft >>>> >> technologies >>>> >> and advance your career. Get an incredible 1,500+ hours of >>>> step-by-step >>>> >> tutorial videos with LearnDevNow. Subscribe today and save! >>>> >> >>>> >> >>>> http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk >>>> >> >>>> >> _______________________________________________ >>>> >> Semediawiki-user mailing list >>>> >> Sem...@li... >>>> >> https://lists.sourceforge.net/lists/listinfo/semediawiki-user >>>> >> >>>> > >>>> > >>>> > >>>> > -- >>>> > WikiWorks · MediaWiki Consulting · http://wikiworks.com >>>> > >>>> >>>> ------------------------------------------------------------------------------ >>>> Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! >>>> Discover the easy way to master current and previous Microsoft >>>> technologies >>>> and advance your career. Get an incredible 1,500+ hours of step-by-step >>>> tutorial videos with LearnDevNow. Subscribe today and save! >>>> >>>> http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk >>>> _______________________________________________ >>>> Semediawiki-user mailing list >>>> Sem...@li... >>>> https://lists.sourceforge.net/lists/listinfo/semediawiki-user >>>> >>> >>> >>> >>> -- >>> WikiWorks · MediaWiki Consulting · http://wikiworks.com >>> >> >> > |
From: Hans F. <han...@gm...> - 2013-09-01 14:33:10
|
Next step (nothing to do with Steve Jobs): I got the same result using Semantic Result Format's arrays: {{#ask: [[Category:Facilities]] [[has corporation::{{FULLPAGENAME}}]] | format=array | name=BMW-Array | propsep=propsep | sep={{!}}{{!}} }} {{#arrayprint:BMW-Array|{{!}}{{!}} }} {{#ask: [[has facility::{{#arrayprint:BMW-Array|{{!}}{{!}} }}]] |?has code name |?has facility |?has build date start |?has build date end }} But I also want to show a column "City"; the parameter "has city" is located in the facilities. How do I get it to show up? just "|?has city" obviously does not work 2013/9/1 Hans Faynmann <han...@gm...> > If I hardcode the query on the corporation's page like: > > {{#ask: > [[has facility::Werk 2.4||BMW Werk 1.1]] > |?has code name > |?has facility > |?has build date start > |?has build date end > |?has city > }} > > I get everything in a table. > Is it possible to get something like Werk 2.4||BMW Werk 1.1 out of a query > and put it into another query? > Is using the Array-extension useful or is it too much of a hassle for > something like this? > > Or is there another way in putting all information in one table? > > > 2013/8/31 Hans Faynmann <han...@gm...> > >> Okay, I tried naming the parameter with named args=yes and it worked. >> >> But as output, I get separate tables for each factory. >> Is it possible to get all the information in one big table so one could >> sort it? >> >> >> >> 2013/8/31 Hans Faynmann <han...@gm...> >> >>> Hi, >>> thanks again, I think I got it now. >>> But after displaying the results, I get an error stating: >>> >>> The part "|BMW Werk 1.1" of the query was not understood. >>> Results might not be as expected. >>> The part "]]" of the query was not understood. Results might not be as >>> expected. >>> >>> >>> My queries: >>> In BMW's page (the corporation): >>> {{#ask: >>> [[Category:Facilities]] >>> [[has corporation::{{FULLPAGENAME}}]] >>> | format=template >>> | template=QueryForCar >>> }} >>> >>> Query in template "QueryForCar": >>> {{#ask: >>> [[has facility::{{{1}}}]] >>> |?has code name >>> |?has facility >>> |?has build date start >>> |?has build date end >>> }} >>> >>> If I "hardcode" the query like "has facility: Werk 2.4" I don't get an >>> error... >>> >>> I think I have to do something before passing the parameter that goes >>> into {{{1}}}?!? >>> >>> >>> >>> 2013/8/29 Yaron Koren <ya...@wi...> >>> >>>> Hi, >>>> >>>> See my previous answer for that - you either need to hardcode the list, >>>> or use a templated query result. >>>> >>>> >>>> On Wed, Aug 28, 2013 at 9:29 AM, Hans Faynmann <han...@gm... >>>> > wrote: >>>> >>>>> Thanks to your answer I figured out how to query all the cars that are >>>>> produced by a facility by putting this query on a facility-page: >>>>> {{#ask:[[is building period of::+]] [[has facility::{{FULLPAGENAME}}]]| >>>>> ?has build date start|?has facility}} >>>>> >>>>> with "is building period of" being the property pointing back to the >>>>> page >>>>> of the car. >>>>> (You can find a sample facility here: >>>>> http://wlw.referata.com/wiki/Werk_2.4 >>>>> ) >>>>> >>>>> The subobject "Building period" is being created on the page "Cars". >>>>> >>>>> The page cars has - among the subobject and other properties the >>>>> property >>>>> "has corporation". >>>>> >>>>> The page facility has no subobjects, and among other properties the >>>>> property "has corporation". >>>>> >>>>> You can find samples here: >>>>> - Sample facility: http://wlw.referata.com/wiki/Werk_2.4 >>>>> - Sample car: http://wlw.referata.com/wiki/BMW_3er_GT >>>>> - Sample corporation: http://wlw.referata.com/wiki/BMW >>>>> >>>>> What should the query look like if I want to show all the facilities >>>>> with >>>>> every car that is produced there and its building period? >>>>> Or the other way round: Show all the cars that are produced by the >>>>> corporation with the respective facilities. >>>>> >>>>> >>>>> 2013/8/28 Yaron Koren <ya...@wi...> >>>>> >>>>> > Hi, >>>>> > >>>>> > Well, each subobject is a "child" of both a car and a facility - so >>>>> you >>>>> > could subdivide by either - though since the data is stored on car >>>>> pages, >>>>> > it probably makes sense to subdivide by car, not by facility, >>>>> contrary to >>>>> > what I said earlier. >>>>> > >>>>> > I don't know what your "Building period" template looks like, but the >>>>> > #subobject call should contain a property pointing back to the page. >>>>> Then, >>>>> > it's just a matter of querying on "[[Has car::<car name>]]" or some >>>>> such to >>>>> > get all the building periods for a certain car. >>>>> > >>>>> > -Yaron >>>>> > >>>>> > >>>>> > On Wed, Aug 28, 2013 at 4:27 AM, Hans Faynmann < >>>>> han...@gm...>wrote: >>>>> > >>>>> >> Thanks, that's something I didn't think of doing first: querying >>>>> every car >>>>> >> a facility produces first... >>>>> >> But even then, I need some advice on how to query for another page's >>>>> >> subobjects. >>>>> >> How can I query on the facility's page for all the cars that are >>>>> produced >>>>> >> there (with date), as the data is stored in the cars's subobjects? >>>>> >> >>>>> >> I would like to use "generic" queries instead of hardcoded ones as >>>>> I would >>>>> >> like to create a database of all car makers, populated by me and >>>>> others >>>>> >> and >>>>> >> by using forms to fill in the data so that noone has to edit pages >>>>> >> individually... >>>>> >> >>>>> >> Is there probably a possibility to nest queries in others? Like >>>>> #ask: -has >>>>> >> subobject:{{first result of query for cars by bmw}} ? >>>>> >> >>>>> >> >>>>> >> 2013/8/27 Yaron Koren <ya...@wi...> >>>>> >> >>>>> >> > Hi Hans, >>>>> >> > >>>>> >> > This seems like a very reasonable data structure. Do you have >>>>> such a >>>>> >> > query, that displays that information (or at least the last three >>>>> >> columns) >>>>> >> > for a given facility? If so, you have two options: you can >>>>> include on >>>>> >> the >>>>> >> > BMW page a set of hardcoded queries showing that information, one >>>>> for >>>>> >> each >>>>> >> > facility; or you can have a query on all the facilities, in >>>>> template >>>>> >> > format, and then create a template that contains that other query, >>>>> >> given a >>>>> >> > passed-in facility name. The main query could look like: >>>>> >> > >>>>> >> > {{#ask:[[Facility of::BMW]]|format=template|template=Query for >>>>> >> facility}} >>>>> >> > >>>>> >> > -Yaron >>>>> >> > >>>>> >> > >>>>> >> > On Tue, Aug 27, 2013 at 9:54 AM, Hans Faynmann < >>>>> han...@gm... >>>>> >> >wrote: >>>>> >> > >>>>> >> >> Thanks, that did the trick (obviously... I had a blackout). And >>>>> thanks >>>>> >> for >>>>> >> >> the advice to use the additional call. >>>>> >> >> >>>>> >> >> >>>>> >> >> I also need some support in building a car maker database: >>>>> >> >> >>>>> >> >> Let’s say I have a corporation [[Category:Corporations]] >>>>> >> >> >>>>> >> >> Each corporation has facilities [[Category:Facilities]] >>>>> >> >> >>>>> >> >> Then there are cars: Each car can be built in various >>>>> facilities, each >>>>> >> has >>>>> >> >> its own building period (like the past and present positions of >>>>> an >>>>> >> >> employee >>>>> >> >> in Yaron’s book) >>>>> >> >> >>>>> >> >> >>>>> >> >> Example: >>>>> >> >> >>>>> >> >> - Corporation: BMW (address of headquarter, …) >>>>> >> >> >>>>> >> >> - Facility: Werk 1.1 (CORPORATION:BMW, address, …) >>>>> >> >> >>>>> >> >> - Car: BMW 3 Series Saloon (CORPORATION: BMW, model range: 3 >>>>> series, >>>>> >> ...) >>>>> >> >> >>>>> >> >> -- Subobjects Building period: >>>>> >> >> >>>>> >> >> --- Facility: Werk 1.1 >>>>> >> >> >>>>> >> >> --- Start of production: September 1, 2012 >>>>> >> >> >>>>> >> >> --- End of production: >>>>> >> >> >>>>> >> >> >>>>> >> >> --- Facility: Werk 6.1 >>>>> >> >> >>>>> >> >> --- Start of production: November 22, 2012 >>>>> >> >> >>>>> >> >> --- End of production: >>>>> >> >> >>>>> >> >> >>>>> >> >> How can I show a list on the page of BMW (how should the #ask >>>>> call look >>>>> >> >> like) that looks like: >>>>> >> >> >>>>> >> >> Facility, Car, Start of Production, End of Production >>>>> >> >> >>>>> >> >> >>>>> >> >> And probably actually much more important: is this a good way to >>>>> model >>>>> >> the >>>>> >> >> data? >>>>> >> >> >>>>> >> >> >>>>> >> >>>>> ------------------------------------------------------------------------------ >>>>> >> >> Introducing Performance Central, a new site from SourceForge and >>>>> >> >> AppDynamics. Performance Central is your source for news, >>>>> insights, >>>>> >> >> analysis and resources for efficient Application Performance >>>>> >> Management. >>>>> >> >> Visit us today! >>>>> >> >> >>>>> >> >> >>>>> >> >>>>> http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk >>>>> >> >> _______________________________________________ >>>>> >> >> Semediawiki-user mailing list >>>>> >> >> Sem...@li... >>>>> >> >> https://lists.sourceforge.net/lists/listinfo/semediawiki-user >>>>> >> >> >>>>> >> > >>>>> >> > >>>>> >> > >>>>> >> > -- >>>>> >> > WikiWorks · MediaWiki Consulting · http://wikiworks.com >>>>> >> > >>>>> >> >>>>> >> >>>>> ------------------------------------------------------------------------------ >>>>> >> Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, >>>>> more! >>>>> >> Discover the easy way to master current and previous Microsoft >>>>> >> technologies >>>>> >> and advance your career. Get an incredible 1,500+ hours of >>>>> step-by-step >>>>> >> tutorial videos with LearnDevNow. Subscribe today and save! >>>>> >> >>>>> >> >>>>> http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk >>>>> >> >>>>> >> _______________________________________________ >>>>> >> Semediawiki-user mailing list >>>>> >> Sem...@li... >>>>> >> https://lists.sourceforge.net/lists/listinfo/semediawiki-user >>>>> >> >>>>> > >>>>> > >>>>> > >>>>> > -- >>>>> > WikiWorks · MediaWiki Consulting · http://wikiworks.com >>>>> > >>>>> >>>>> ------------------------------------------------------------------------------ >>>>> Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! >>>>> Discover the easy way to master current and previous Microsoft >>>>> technologies >>>>> and advance your career. Get an incredible 1,500+ hours of step-by-step >>>>> tutorial videos with LearnDevNow. Subscribe today and save! >>>>> >>>>> http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk >>>>> _______________________________________________ >>>>> Semediawiki-user mailing list >>>>> Sem...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/semediawiki-user >>>>> >>>> >>>> >>>> >>>> -- >>>> WikiWorks · MediaWiki Consulting · http://wikiworks.com >>>> >>> >>> >> > |
From: Hans F. <han...@gm...> - 2013-09-01 20:03:34
|
I extended my approach according to this explanation: http://smw.referata.com/wiki/Use_the_ask_template_format_to_create_tabular_output So on the page of Audi I have implemented these queries: {{#ask: [[Category:Cars]] [[has corporation::{{FULLPAGENAME}}]] | format=array | name=Audi-Car-Array | sep={{!}}{{!}} }} {{#ask: [[is building period of::{{#arrayprint:Audi-Car-Array|{{!}}{{!}} }}]] | ?has corporation=corp | ?has facility #=facilityname | ?has build date start=startdatum | format=template | template=CarTableTemplate | named args=yes | mainlabel=carname | introtemplate=CarTableTemplateHeader | outrotemplate=CarTableTemplateFooter | userparam={{FULLPAGENAME}} }} In the resulting table (CarTableTemplate) I added further queries: |{{{?carname}}} || Corporation: {{#ask: [[{{#sub: {{#explode: {{{?carname}}}|#|0}} |3 }}]]|?has corporation= |mainlabel=- |format=list}} || {{#ask: [[{{{?facilityname|}}}]] }} ||{{#ask: [[{{{?facilityname|}}}]] |?has street= |mainlabel=- |format=list}} || {{#ask: [[{{{?facilityname|}}}]] |?has city= |mainlabel=- |format=list}} || {{{?startdatum}}} |- In the field Corporation I want to show the corporation the car is building (later I want to refer to this as "brand", seperating the corporation that builds cars from the corporation the facilities belong to). As I am querying for subobjects, the result I get for {{?carname}} is in the form: http://wlw.referata.com/wiki/Audi_A6#_bcf59e877d93643c972a171740dbc1c7 When I use {{#explode}}, I get "[[:Audi A6" with leading [[:, so I have to parse the string another time with #sub. Why do I get the additional [[:? And isn't there a solution to only get the car name? mainlabel # = carname does not work... 2013/9/1 Hans Faynmann <han...@gm...> > Next step (nothing to do with Steve Jobs): > I got the same result using Semantic Result Format's arrays: > > {{#ask: > [[Category:Facilities]] > [[has corporation::{{FULLPAGENAME}}]] > | format=array > | name=BMW-Array > | propsep=propsep > | sep={{!}}{{!}} > }} > > {{#arrayprint:BMW-Array|{{!}}{{!}} }} > > {{#ask: > [[has facility::{{#arrayprint:BMW-Array|{{!}}{{!}} }}]] > |?has code name > |?has facility > |?has build date start > |?has build date end > }} > > But I also want to show a column "City"; the parameter "has city" is > located in the facilities. > > How do I get it to show up? > just "|?has city" obviously does not work > > > > 2013/9/1 Hans Faynmann <han...@gm...> > >> If I hardcode the query on the corporation's page like: >> >> {{#ask: >> [[has facility::Werk 2.4||BMW Werk 1.1]] >> |?has code name >> |?has facility >> |?has build date start >> |?has build date end >> |?has city >> }} >> >> I get everything in a table. >> Is it possible to get something like Werk 2.4||BMW Werk 1.1 out of a >> query and put it into another query? >> Is using the Array-extension useful or is it too much of a hassle for >> something like this? >> >> Or is there another way in putting all information in one table? >> >> >> 2013/8/31 Hans Faynmann <han...@gm...> >> >>> Okay, I tried naming the parameter with named args=yes and it worked. >>> >>> But as output, I get separate tables for each factory. >>> Is it possible to get all the information in one big table so one could >>> sort it? >>> >>> >>> >>> 2013/8/31 Hans Faynmann <han...@gm...> >>> >>>> Hi, >>>> thanks again, I think I got it now. >>>> But after displaying the results, I get an error stating: >>>> >>>> The part "|BMW Werk 1.1" of the query was not understood. >>>> Results might not be as expected. >>>> The part "]]" of the query was not understood. Results might not be as >>>> expected. >>>> >>>> >>>> My queries: >>>> In BMW's page (the corporation): >>>> {{#ask: >>>> [[Category:Facilities]] >>>> [[has corporation::{{FULLPAGENAME}}]] >>>> | format=template >>>> | template=QueryForCar >>>> }} >>>> >>>> Query in template "QueryForCar": >>>> {{#ask: >>>> [[has facility::{{{1}}}]] >>>> |?has code name >>>> |?has facility >>>> |?has build date start >>>> |?has build date end >>>> }} >>>> >>>> If I "hardcode" the query like "has facility: Werk 2.4" I don't get an >>>> error... >>>> >>>> I think I have to do something before passing the parameter that goes >>>> into {{{1}}}?!? >>>> >>>> >>>> >>>> 2013/8/29 Yaron Koren <ya...@wi...> >>>> >>>>> Hi, >>>>> >>>>> See my previous answer for that - you either need to hardcode the >>>>> list, or use a templated query result. >>>>> >>>>> >>>>> On Wed, Aug 28, 2013 at 9:29 AM, Hans Faynmann < >>>>> han...@gm...> wrote: >>>>> >>>>>> Thanks to your answer I figured out how to query all the cars that >>>>>> are >>>>>> produced by a facility by putting this query on a facility-page: >>>>>> {{#ask:[[is building period of::+]] [[has >>>>>> facility::{{FULLPAGENAME}}]]| >>>>>> ?has build date start|?has facility}} >>>>>> >>>>>> with "is building period of" being the property pointing back to the >>>>>> page >>>>>> of the car. >>>>>> (You can find a sample facility here: >>>>>> http://wlw.referata.com/wiki/Werk_2.4 >>>>>> ) >>>>>> >>>>>> The subobject "Building period" is being created on the page "Cars". >>>>>> >>>>>> The page cars has - among the subobject and other properties the >>>>>> property >>>>>> "has corporation". >>>>>> >>>>>> The page facility has no subobjects, and among other properties the >>>>>> property "has corporation". >>>>>> >>>>>> You can find samples here: >>>>>> - Sample facility: http://wlw.referata.com/wiki/Werk_2.4 >>>>>> - Sample car: http://wlw.referata.com/wiki/BMW_3er_GT >>>>>> - Sample corporation: http://wlw.referata.com/wiki/BMW >>>>>> >>>>>> What should the query look like if I want to show all the facilities >>>>>> with >>>>>> every car that is produced there and its building period? >>>>>> Or the other way round: Show all the cars that are produced by the >>>>>> corporation with the respective facilities. >>>>>> >>>>>> >>>>>> 2013/8/28 Yaron Koren <ya...@wi...> >>>>>> >>>>>> > Hi, >>>>>> > >>>>>> > Well, each subobject is a "child" of both a car and a facility - so >>>>>> you >>>>>> > could subdivide by either - though since the data is stored on car >>>>>> pages, >>>>>> > it probably makes sense to subdivide by car, not by facility, >>>>>> contrary to >>>>>> > what I said earlier. >>>>>> > >>>>>> > I don't know what your "Building period" template looks like, but >>>>>> the >>>>>> > #subobject call should contain a property pointing back to the >>>>>> page. Then, >>>>>> > it's just a matter of querying on "[[Has car::<car name>]]" or some >>>>>> such to >>>>>> > get all the building periods for a certain car. >>>>>> > >>>>>> > -Yaron >>>>>> > >>>>>> > >>>>>> > On Wed, Aug 28, 2013 at 4:27 AM, Hans Faynmann < >>>>>> han...@gm...>wrote: >>>>>> > >>>>>> >> Thanks, that's something I didn't think of doing first: querying >>>>>> every car >>>>>> >> a facility produces first... >>>>>> >> But even then, I need some advice on how to query for another >>>>>> page's >>>>>> >> subobjects. >>>>>> >> How can I query on the facility's page for all the cars that are >>>>>> produced >>>>>> >> there (with date), as the data is stored in the cars's subobjects? >>>>>> >> >>>>>> >> I would like to use "generic" queries instead of hardcoded ones as >>>>>> I would >>>>>> >> like to create a database of all car makers, populated by me and >>>>>> others >>>>>> >> and >>>>>> >> by using forms to fill in the data so that noone has to edit pages >>>>>> >> individually... >>>>>> >> >>>>>> >> Is there probably a possibility to nest queries in others? Like >>>>>> #ask: -has >>>>>> >> subobject:{{first result of query for cars by bmw}} ? >>>>>> >> >>>>>> >> >>>>>> >> 2013/8/27 Yaron Koren <ya...@wi...> >>>>>> >> >>>>>> >> > Hi Hans, >>>>>> >> > >>>>>> >> > This seems like a very reasonable data structure. Do you have >>>>>> such a >>>>>> >> > query, that displays that information (or at least the last three >>>>>> >> columns) >>>>>> >> > for a given facility? If so, you have two options: you can >>>>>> include on >>>>>> >> the >>>>>> >> > BMW page a set of hardcoded queries showing that information, >>>>>> one for >>>>>> >> each >>>>>> >> > facility; or you can have a query on all the facilities, in >>>>>> template >>>>>> >> > format, and then create a template that contains that other >>>>>> query, >>>>>> >> given a >>>>>> >> > passed-in facility name. The main query could look like: >>>>>> >> > >>>>>> >> > {{#ask:[[Facility of::BMW]]|format=template|template=Query for >>>>>> >> facility}} >>>>>> >> > >>>>>> >> > -Yaron >>>>>> >> > >>>>>> >> > >>>>>> >> > On Tue, Aug 27, 2013 at 9:54 AM, Hans Faynmann < >>>>>> han...@gm... >>>>>> >> >wrote: >>>>>> >> > >>>>>> >> >> Thanks, that did the trick (obviously... I had a blackout). And >>>>>> thanks >>>>>> >> for >>>>>> >> >> the advice to use the additional call. >>>>>> >> >> >>>>>> >> >> >>>>>> >> >> I also need some support in building a car maker database: >>>>>> >> >> >>>>>> >> >> Let’s say I have a corporation [[Category:Corporations]] >>>>>> >> >> >>>>>> >> >> Each corporation has facilities [[Category:Facilities]] >>>>>> >> >> >>>>>> >> >> Then there are cars: Each car can be built in various >>>>>> facilities, each >>>>>> >> has >>>>>> >> >> its own building period (like the past and present positions of >>>>>> an >>>>>> >> >> employee >>>>>> >> >> in Yaron’s book) >>>>>> >> >> >>>>>> >> >> >>>>>> >> >> Example: >>>>>> >> >> >>>>>> >> >> - Corporation: BMW (address of headquarter, …) >>>>>> >> >> >>>>>> >> >> - Facility: Werk 1.1 (CORPORATION:BMW, address, …) >>>>>> >> >> >>>>>> >> >> - Car: BMW 3 Series Saloon (CORPORATION: BMW, model range: 3 >>>>>> series, >>>>>> >> ...) >>>>>> >> >> >>>>>> >> >> -- Subobjects Building period: >>>>>> >> >> >>>>>> >> >> --- Facility: Werk 1.1 >>>>>> >> >> >>>>>> >> >> --- Start of production: September 1, 2012 >>>>>> >> >> >>>>>> >> >> --- End of production: >>>>>> >> >> >>>>>> >> >> >>>>>> >> >> --- Facility: Werk 6.1 >>>>>> >> >> >>>>>> >> >> --- Start of production: November 22, 2012 >>>>>> >> >> >>>>>> >> >> --- End of production: >>>>>> >> >> >>>>>> >> >> >>>>>> >> >> How can I show a list on the page of BMW (how should the #ask >>>>>> call look >>>>>> >> >> like) that looks like: >>>>>> >> >> >>>>>> >> >> Facility, Car, Start of Production, End of Production >>>>>> >> >> >>>>>> >> >> >>>>>> >> >> And probably actually much more important: is this a good way >>>>>> to model >>>>>> >> the >>>>>> >> >> data? >>>>>> >> >> >>>>>> >> >> >>>>>> >> >>>>>> ------------------------------------------------------------------------------ >>>>>> >> >> Introducing Performance Central, a new site from SourceForge and >>>>>> >> >> AppDynamics. Performance Central is your source for news, >>>>>> insights, >>>>>> >> >> analysis and resources for efficient Application Performance >>>>>> >> Management. >>>>>> >> >> Visit us today! >>>>>> >> >> >>>>>> >> >> >>>>>> >> >>>>>> http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk >>>>>> >> >> _______________________________________________ >>>>>> >> >> Semediawiki-user mailing list >>>>>> >> >> Sem...@li... >>>>>> >> >> https://lists.sourceforge.net/lists/listinfo/semediawiki-user >>>>>> >> >> >>>>>> >> > >>>>>> >> > >>>>>> >> > >>>>>> >> > -- >>>>>> >> > WikiWorks · MediaWiki Consulting · http://wikiworks.com >>>>>> >> > >>>>>> >> >>>>>> >> >>>>>> ------------------------------------------------------------------------------ >>>>>> >> Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, >>>>>> more! >>>>>> >> Discover the easy way to master current and previous Microsoft >>>>>> >> technologies >>>>>> >> and advance your career. Get an incredible 1,500+ hours of >>>>>> step-by-step >>>>>> >> tutorial videos with LearnDevNow. Subscribe today and save! >>>>>> >> >>>>>> >> >>>>>> http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk >>>>>> >> >>>>>> >> _______________________________________________ >>>>>> >> Semediawiki-user mailing list >>>>>> >> Sem...@li... >>>>>> >> https://lists.sourceforge.net/lists/listinfo/semediawiki-user >>>>>> >> >>>>>> > >>>>>> > >>>>>> > >>>>>> > -- >>>>>> > WikiWorks · MediaWiki Consulting · http://wikiworks.com >>>>>> > >>>>>> >>>>>> ------------------------------------------------------------------------------ >>>>>> Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! >>>>>> Discover the easy way to master current and previous Microsoft >>>>>> technologies >>>>>> and advance your career. Get an incredible 1,500+ hours of >>>>>> step-by-step >>>>>> tutorial videos with LearnDevNow. Subscribe today and save! >>>>>> >>>>>> http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk >>>>>> _______________________________________________ >>>>>> Semediawiki-user mailing list >>>>>> Sem...@li... >>>>>> https://lists.sourceforge.net/lists/listinfo/semediawiki-user >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> WikiWorks · MediaWiki Consulting · http://wikiworks.com >>>>> >>>> >>>> >>> >> > |