From: Schouten, E. J. (RB-NL) <Edg...@re...> - 2010-03-22 09:15:03
|
Dear Bob, Laurent, Thank you very much for your response, which was very clarifying for me. Following up on your suggestions: Because a person could have a career within a company, the relation between a person and a company, like [[Steve Johnson at BigMachines]] is not unique. I would probably need [[Steve Johnson as CEO at BigMachines]], with the assumption that a person never holds the same position twice within one company. In order to rule out that assumption (might be a false assumption) I would maybe even need: [[Steve Johnson starting as CEO in 2005 at BigMachines]] to describe the relation between position, person and company. Correct? Kind regards Edgar Schouten Message: 4 Date: Sat, 20 Mar 2010 15:31:33 +0100 From: "Schouten, Edgar J. (RB-NL)" <Edg...@re...> Subject: [Semediawiki-user] Co-working To: <sem...@li...> Message-ID: <081776E9B6E2A64C8BA2FDD150F802C6131905AD@RBNDTCEXCP01VB.b2b.regn.net> Content-Type: text/plain; charset="us-ascii" Dear Semediawikians, I'm trying to express the fact that a relation between a person and a position at a company is limited in time. Examples: Steve Johnson worked at SteelWorks as CFO from 01-01-2000 through 01-02-2005 Steve Johnson worked at BigMachines as CEO from 01-02-2005 through 01-02-2008 Bill McCoy worked at BigMachines as CTO from 01-01-2008 through 01-01-2010 My goal would be to make concepts asking about co-workers of a person in a particular timeframe While Steve Johnson worked at BigMachines as CEO, who else was working there? In this case: Bill MacCoy (they co-worked from 01-01-2008 (which is Bill's appointment) through 01-02-2008 (Steve resigning as CEO) I seem to be able to express the fact that Steve and Bill know each other. (as a static fact) But I can't get my finger around co-working (as a relationship to a company they have in common with date-boundaries) Is this something that somehow could be done using semantics? Thanks in advance for making suggestions that will point me in the right direction. Kind Regards EdgarS ------------------------------ Message: 5 Date: Sat, 20 Mar 2010 16:23:39 +0000 From: Bob MacCallum <unc...@gm...> Subject: Re: [Semediawiki-user] Co-working To: "Schouten, Edgar J. (RB-NL)" <Edg...@re...> Cc: sem...@li... Message-ID: <122...@ma...> Content-Type: text/plain; charset=ISO-8859-1 You could start with a page [[Steve Johnson at BigMachines]] and set a daily (or weekly or monthly) recurring event property "was employed on date" for the relevant period. The page would also [[has employee::Steve Johnson]] and [[has employer::BigMachines]] and probably [[Category:Employment]] Do the same for the other "Person at Company" facts you have at hand. Then for a given (single) date and company you can query who was employed there {{#ask: [[Category:Employment]] [[was employed on date::20-01-2008]] [[has employer::BigMachines]] |?has employee }} It's not exactly what you want, but it might be in the right direction. You should also be able to start the query on the Employee page e.g. [[Steve Johnson]] with something like {{#ask: [[Category:Employment]] [[was employed on date::20-01-2008]] [[has employee::{{PAGENAME}}]] |?has employer }} Once you have the employers (remember this guy could be moonlighting) you can arraymap another query to get the employees on that date. I haven't tried any of these queries, so you'll probably need mainlabel=- and link=none and other tricks. Looping all this for multiple dates is going to be expensive, I imagine. Any other suggestions? On Sat, Mar 20, 2010 at 2:31 PM, Schouten, Edgar J. (RB-NL) <Edg...@re...> wrote: > Dear Semediawikians, > > > > I'm trying to express the fact that a relation between a person and a > position at a company is limited in time. > > Examples: > > Steve Johnson worked at SteelWorks as CFO from 01-01-2000 through > 01-02-2005 > > Steve Johnson worked at BigMachines as CEO from 01-02-2005 through > 01-02-2008 > > Bill McCoy worked at BigMachines as CTO from 01-01-2008 through > 01-01-2010 > > > > My goal would be to make concepts asking about co-workers of a person in > a particular timeframe > > > > While Steve Johnson worked at BigMachines as CEO, who else was working > there? > > In this case: Bill MacCoy (they co-worked from 01-01-2008 (which is > Bill's appointment) through 01-02-2008 (Steve resigning as CEO) > > > > I seem to be able to express the fact that Steve and Bill know each > other. (as a static fact) > > But I can't get my finger around co-working (as a ?relationship to a > company they have in common with date-boundaries) > > > > Is this something that somehow could be done using semantics? > > Thanks in advance for making suggestions that will point me in the right > direction. > > > > Kind Regards > > EdgarS > > > > > > ------------------------------------------------------------------------ ------ > Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > -- http://darwintunes.org - a test-tube for cultural evolution http://evolectronica.com - survival of the funkiest http://compare-stuff.com - confused? you will be! http://twitter.com/darwintunes http://twitter.com/bobmaccallum ------------------------------ Message: 6 Date: Sat, 20 Mar 2010 13:21:19 -0400 From: Laurent Alquier <la...@al...> Subject: Re: [Semediawiki-user] Co-working To: sem...@li... Message-ID: <6f8...@ma...> Content-Type: text/plain; charset=ISO-8859-1 'Semediawikians' - I like that name :) For this kind of complex relationships, I found it easier to use a dedicated category/form/template set instead of using internal objects or n-ary properties. In this example, I would : 1- Create a category called something like 'employment' 2- The form and template for this category would include these properties (if you are not using Semantic Forms yet, now is a good time :) ). - Has employee name - Has start date - Has end date - Has company - Has job description - anything else you need to capture for a job. 3- Set up the form to create pages with an automated name (the 'One step process' in the documentation of Semantic Forms). That way, adding a new employment from the page of a person is a one-click process. That is, you can add a link or a button called 'Add a new employment' from a page of a category Person. 4- After that, it becomes relatively easy to query for co-employment (ask for people in the same company around the same time). It's a slight variation of what Bob suggested but it works very well in practice (now that I read again the previous answer, it is probably the same solution with different names - but I am sending this anyway in case it can cast the answer under a different light). - Laurent On Sat, Mar 20, 2010 at 12:23 PM, Bob MacCallum <unc...@gm...> wrote: > You could start with a page [[Steve Johnson at BigMachines]] > and set a daily (or weekly or monthly) recurring event property "was > employed on date" for the relevant period. > The page would also [[has employee::Steve Johnson]] and [[has > employer::BigMachines]] and probably [[Category:Employment]] > > Do the same for the other "Person at Company" facts you have at hand. > > Then for a given (single) date and company you can query who was employed > there > > {{#ask: [[Category:Employment]] [[was employed on date::20-01-2008]] > [[has employer::BigMachines]] > |?has employee > }} > > It's not exactly what you want, but it might be in the right direction. > > You should also be able to start the query on the Employee page e.g. > [[Steve Johnson]] > with something like > > {{#ask: [[Category:Employment]] [[was employed on date::20-01-2008]] > [[has employee::{{PAGENAME}}]] > |?has employer > }} > > Once you have the employers (remember this guy could be moonlighting) > you can arraymap another query to get the employees on that date. I > haven't tried any of these queries, so you'll probably need > mainlabel=- and link=none and other tricks. > > Looping all this for multiple dates is going to be expensive, I imagine. > > Any other suggestions? > > On Sat, Mar 20, 2010 at 2:31 PM, Schouten, Edgar J. (RB-NL) > <Edg...@re...> wrote: > > Dear Semediawikians, > > > > > > > > I'm trying to express the fact that a relation between a person and a > > position at a company is limited in time. > > > > Examples: > > > > Steve Johnson worked at SteelWorks as CFO from 01-01-2000 through > > 01-02-2005 > > > > Steve Johnson worked at BigMachines as CEO from 01-02-2005 through > > 01-02-2008 > > > > Bill McCoy worked at BigMachines as CTO from 01-01-2008 through > > 01-01-2010 > > > > > > > > My goal would be to make concepts asking about co-workers of a person in > > a particular timeframe > > > > > > > > While Steve Johnson worked at BigMachines as CEO, who else was working > > there? > > > > In this case: Bill MacCoy (they co-worked from 01-01-2008 (which is > > Bill's appointment) through 01-02-2008 (Steve resigning as CEO) > > > > > > > > I seem to be able to express the fact that Steve and Bill know each > > other. (as a static fact) > > > > But I can't get my finger around co-working (as a relationship to a > > company they have in common with date-boundaries) > > > > > > > > Is this something that somehow could be done using semantics? > > > > Thanks in advance for making suggestions that will point me in the right > > direction. > > > > > > > > Kind Regards > > > > EdgarS > > > > > > > > > > > > > ------------------------------------------------------------------------ ------ > > Download Intel® Parallel Studio Eval > > Try the new software tools for yourself. Speed compiling, find bugs > > proactively, and fine-tune applications for parallel performance. > > See why Intel Parallel Studio got high marks during beta. > > http://p.sf.net/sfu/intel-sw-dev > > _______________________________________________ > > Semediawiki-user mailing list > > Sem...@li... > > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > > > > > > -- > http://darwintunes.org - a test-tube for cultural evolution > http://evolectronica.com - survival of the funkiest > http://compare-stuff.com - confused? you will be! > http://twitter.com/darwintunes > http://twitter.com/bobmaccallum > > > ------------------------------------------------------------------------ ------ > Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > -- - Laurent Alquier http://www.linfa.net ------------------------------ ------------------------------------------------------------------------ ------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ------------------------------ _______________________________________________ Semediawiki-user mailing list Sem...@li... https://lists.sourceforge.net/lists/listinfo/semediawiki-user End of Semediawiki-user Digest, Vol 46, Issue 48 ************************************************ |
From: Schouten, E. J. (RB-NL) <Edg...@re...> - 2010-03-23 14:28:24
|
Hi, Thank you very much for pointing me to Semantic Internal Objects. SIO is a very interesting extension that I unfortunately somehow overlooked until now. After creating Internal objects like the following three for my friend Steven McCoy {{#set_internal:Has position |Has title=CFO |Has startdate=2003-01-01 |Has enddate=2004-04-01 |Has company=RBI }} {{#set_internal:Has position |Has title=CEO |Has startdate=2002-01-01 |Has enddate=2003-04-01 |Has company=KPN }} {{#set_internal:Has position |Has title=CTO |Has startdate=2005-01-01 |Has enddate=3000-01-01 |Has company=V&D }} I can successfully query for current and past positions of a person (and also make lists of current employees and former employees at the pages of the companies) === current positions === {{#ask:[[Has position::{{FULLPAGENAME}}]][[Has enddate::>{{CURRENTYEAR}}-{{CURRENTMONTH}}-{{CURRENTDAY}}]] |mainlabel=- |sort=Has startdate |? Has startdate |? Has title |? Has company }} === previous positions === {{#ask:[[Has position::{{FULLPAGENAME}}]][[Has enddate::<{{CURRENTYEAR}}-{{CURRENTMONTH}}-{{CURRENTDAY}}]] |mainlabel=- |sort=Has startdate |? Has startdate |? Has enddate = |? Has title |? Has company }} This is great! Really great! I am still struggling though, with making a list of co-workers of a person. Somehow I need to compare startdates and enddates of people (within one company). Can I use subqueries (<q></q>) somehow, or do I need some other mechanism that I can't seem to stumble upon. ===Co-workers of Steven McCoy at KPN=== {{#ask:[[Has position::+]] [[Has company::KPN]] [[Has startdate::< <q>...Steven McCoy's enddate at KPN</q>]] [[Has enddate::> <q>...Steven McCoy's startdate at KPN</q>]] |mainlabel=- |sort=Has startdate |? Has startdate |? Has enddate = |? Has title |? Has company }} The other thing is that - In order to keep things dynamic - I need to get red of the hard-coded [[has company::X]] in the example above and loop over the results of the list of companies that Steven McCoy worked for. Thank you very much in advance. Kind regards EdgarS Van: Yaron Koren [mailto:ya...@gm...] Verzonden: maandag 22 maart 2010 17:11 Aan: Schouten, Edgar J. (RB-NL) CC: sem...@li... Onderwerp: Re: [Semediawiki-user] Co-working (Schouten, Edgar J. (RB-NL)) Hi Edgar, I would strongly discourage you from creating a page for each of these combinations of data, and instead strongly encourage you to use the Semantic Internal Objects extension: http://www.mediawiki.org/wiki/Extension:Semantic_Internal_Objects If you're using Semantic Forms to input the data, you should use "mulitple-instance templates" to enter that internal-object data. -Yaron |
From: Yaron K. <ya...@gm...> - 2010-03-23 16:00:00
|
Hi, This is quite a thorny problem. I don't think there's a way to do this using a single query; and even if there were, it would be incredibly convoluted (I bet the same would be true if it were a SQL query with a regular database, by the way). I think this query would better be handled in a programmatic kind of way; here's some pseudocode that hopefully clarifies it: for each company the person has worked at print "co-workers at [company name]:" start date = the person's start date at that company end date = the person's end date at the company find and print all people who worked at that company after start date or before end date end for There are different ways you could accomplish this, though probably the most straightforward way is to define the array of companies using #arraydefine, which is defined in the ArrayExtension extension: http://www.mediawiki.org/wiki/Extension:ArrayExtension ...and then cycle through that array using #arraymaptemplate (and a template), which is defined in Semantic Forms. You could also use VariablesExtension to simplify the appearance, by setting variables for "start date" and "end "date: http://www.mediawiki.org/wiki/Extension:VariablesExtension ...though that's probably not necessary. -Yaron On Tue, Mar 23, 2010 at 10:13 AM, Schouten, Edgar J. (RB-NL) < Edg...@re...> wrote: > Hi Yaron, > > > > Thank you very much for pointing me to Semantic Internal Objects. > > SIO is a very interesting extension that I unfortunately somehow overlooked > until now. > > > > After creating Internal objects like the following three for my friend > Steven McCoy > > > > {{#set_internal:Has position > > |Has title=CFO > > |Has startdate=2003-01-01 > > |Has enddate=2004-04-01 > > |Has company=RBI > > }} > > > > {{#set_internal:Has position > > |Has title=CEO > > |Has startdate=2002-01-01 > > |Has enddate=2003-04-01 > > |Has company=KPN > > }} > > > > {{#set_internal:Has position > > |Has title=CTO > > |Has startdate=2005-01-01 > > |Has enddate=3000-01-01 > > |Has company=V&D > > }} > > > > I can successfully query for current and past positions of a person (and > also make lists of current employees and former employees at the pages of > the companies) > > > > === current positions === > > {{#ask:[[Has position::{{FULLPAGENAME}}]][[Has > enddate::>{{CURRENTYEAR}}-{{CURRENTMONTH}}-{{CURRENTDAY}}]] > > |mainlabel=- > > |sort=Has startdate > > |? Has startdate > > |? Has title > > |? Has company > > }} > > > > === previous positions === > > {{#ask:[[Has position::{{FULLPAGENAME}}]][[Has > enddate::<{{CURRENTYEAR}}-{{CURRENTMONTH}}-{{CURRENTDAY}}]] > > |mainlabel=- > > |sort=Has startdate > > |? Has startdate > > |? Has enddate = > > |? Has title > > |? Has company > > }} > > > > This is great! Really great! > > > > I am still struggling though, with making a list of *co-workers* of a > person. Somehow I need to compare startdates and enddates of people (within > one company). Can I use subqueries (<q></q>) somehow, or do I need some > other mechanism that I can’t seem to stumble upon. > > > > ===Co-workers of Steven McCoy at KPN=== > > {{#ask:[[Has position::+]] [[Has company::KPN]] [[Has startdate::< > <q>...Steven McCoy’s enddate at KPN</q>]] [[Has enddate::> <q>…Steven > McCoy’s startdate at KPN</q>]] > > |mainlabel=- > > |sort=Has startdate > > |? Has startdate > > |? Has enddate = > > |? Has title > > |? Has company > > }} > > > > The other thing is that - In order to keep things dynamic – I need to get > red of the hard-coded [[has company::X]] in the example above and loop over > the results of the list of companies that Steven McCoy worked for. > > > > Thank you very much in advance. > > > > Kind regards > > EdgarS > > > > > |
From: Yaron K. <ya...@gm...> - 2010-03-22 16:10:59
|
Hi Edgar, I would strongly discourage you from creating a page for each of these combinations of data, and instead strongly encourage you to use the Semantic Internal Objects extension: http://www.mediawiki.org/wiki/Extension:Semantic_Internal_Objects If you're using Semantic Forms to input the data, you should use "mulitple-instance templates" to enter that internal-object data. -Yaron On Mon, Mar 22, 2010 at 5:14 AM, Schouten, Edgar J. (RB-NL) < Edg...@re...> wrote: > Dear Bob, Laurent, > > Thank you very much for your response, which was very clarifying for me. > Following up on your suggestions: > Because a person could have a career within a company, the relation > between a person and a company, like [[Steve Johnson at BigMachines]] is > not unique. > I would probably need [[Steve Johnson as CEO at BigMachines]], with the > assumption that a person never holds the same position twice within one > company. > In order to rule out that assumption (might be a false assumption) I > would maybe even need: [[Steve Johnson starting as CEO in 2005 at > BigMachines]] to describe the relation between position, person and > company. > Correct? > > Kind regards > Edgar Schouten > > > > > > > Message: 4 > Date: Sat, 20 Mar 2010 15:31:33 +0100 > From: "Schouten, Edgar J. (RB-NL)" <Edg...@re...> > Subject: [Semediawiki-user] Co-working > To: <sem...@li...> > Message-ID: > > <081776E9B6E2A64C8BA2FDD150F802C6131905AD@RBNDTCEXCP01VB.b2b.regn.net> > Content-Type: text/plain; charset="us-ascii" > > Dear Semediawikians, > > > > I'm trying to express the fact that a relation between a person and a > position at a company is limited in time. > > Examples: > > Steve Johnson worked at SteelWorks as CFO from 01-01-2000 through > 01-02-2005 > > Steve Johnson worked at BigMachines as CEO from 01-02-2005 through > 01-02-2008 > > Bill McCoy worked at BigMachines as CTO from 01-01-2008 through > 01-01-2010 > > > > My goal would be to make concepts asking about co-workers of a person in > a particular timeframe > > > > While Steve Johnson worked at BigMachines as CEO, who else was working > there? > > In this case: Bill MacCoy (they co-worked from 01-01-2008 (which is > Bill's appointment) through 01-02-2008 (Steve resigning as CEO) > > > > I seem to be able to express the fact that Steve and Bill know each > other. (as a static fact) > > But I can't get my finger around co-working (as a relationship to a > company they have in common with date-boundaries) > > > > Is this something that somehow could be done using semantics? > > Thanks in advance for making suggestions that will point me in the right > direction. > > > > Kind Regards > > EdgarS > > > > > > > > ------------------------------ > > Message: 5 > Date: Sat, 20 Mar 2010 16:23:39 +0000 > From: Bob MacCallum <unc...@gm...> > Subject: Re: [Semediawiki-user] Co-working > To: "Schouten, Edgar J. (RB-NL)" <Edg...@re...> > Cc: sem...@li... > Message-ID: > <122...@ma...> > Content-Type: text/plain; charset=ISO-8859-1 > > You could start with a page [[Steve Johnson at BigMachines]] > and set a daily (or weekly or monthly) recurring event property "was > employed on date" for the relevant period. > The page would also [[has employee::Steve Johnson]] and [[has > employer::BigMachines]] and probably [[Category:Employment]] > > Do the same for the other "Person at Company" facts you have at hand. > > Then for a given (single) date and company you can query who was > employed there > > {{#ask: [[Category:Employment]] [[was employed on date::20-01-2008]] > [[has employer::BigMachines]] > |?has employee > }} > > It's not exactly what you want, but it might be in the right direction. > > You should also be able to start the query on the Employee page e.g. > [[Steve Johnson]] > with something like > > {{#ask: [[Category:Employment]] [[was employed on date::20-01-2008]] > [[has employee::{{PAGENAME}}]] > |?has employer > }} > > Once you have the employers (remember this guy could be moonlighting) > you can arraymap another query to get the employees on that date. I > haven't tried any of these queries, so you'll probably need > mainlabel=- and link=none and other tricks. > > Looping all this for multiple dates is going to be expensive, I imagine. > > Any other suggestions? > > On Sat, Mar 20, 2010 at 2:31 PM, Schouten, Edgar J. (RB-NL) > <Edg...@re...> wrote: > > Dear Semediawikians, > > > > > > > > I'm trying to express the fact that a relation between a person and a > > position at a company is limited in time. > > > > Examples: > > > > Steve Johnson worked at SteelWorks as CFO from 01-01-2000 through > > 01-02-2005 > > > > Steve Johnson worked at BigMachines as CEO from 01-02-2005 through > > 01-02-2008 > > > > Bill McCoy worked at BigMachines as CTO from 01-01-2008 through > > 01-01-2010 > > > > > > > > My goal would be to make concepts asking about co-workers of a person > in > > a particular timeframe > > > > > > > > While Steve Johnson worked at BigMachines as CEO, who else was working > > there? > > > > In this case: Bill MacCoy (they co-worked from 01-01-2008 (which is > > Bill's appointment) through 01-02-2008 (Steve resigning as CEO) > > > > > > > > I seem to be able to express the fact that Steve and Bill know each > > other. (as a static fact) > > > > But I can't get my finger around co-working (as a ?relationship to a > > company they have in common with date-boundaries) > > > > > > > > Is this something that somehow could be done using semantics? > > > > Thanks in advance for making suggestions that will point me in the > right > > direction. > > > > > > > > Kind Regards > > > > EdgarS > > > > > > > > > > > > > ------------------------------------------------------------------------ > ------ > > Download Intel® Parallel Studio Eval > > Try the new software tools for yourself. Speed compiling, find bugs > > proactively, and fine-tune applications for parallel performance. > > See why Intel Parallel Studio got high marks during beta. > > http://p.sf.net/sfu/intel-sw-dev > > _______________________________________________ > > Semediawiki-user mailing list > > Sem...@li... > > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > > > > > > -- > http://darwintunes.org - a test-tube for cultural evolution > http://evolectronica.com - survival of the funkiest > http://compare-stuff.com - confused? you will be! > http://twitter.com/darwintunes > http://twitter.com/bobmaccallum > > > > ------------------------------ > > Message: 6 > Date: Sat, 20 Mar 2010 13:21:19 -0400 > From: Laurent Alquier <la...@al...> > Subject: Re: [Semediawiki-user] Co-working > To: sem...@li... > Message-ID: > <6f8...@ma...> > Content-Type: text/plain; charset=ISO-8859-1 > > 'Semediawikians' - I like that name :) > > For this kind of complex relationships, I found it easier to use a > dedicated > category/form/template set instead of using internal objects or n-ary > properties. > > In this example, I would : > > 1- Create a category called something like 'employment' > > 2- The form and template for this category would include these > properties > (if you are not using Semantic Forms yet, now is a good time :) ). > > - Has employee name > - Has start date > - Has end date > - Has company > - Has job description > - anything else you need to capture for a job. > > 3- Set up the form to create pages with an automated name (the 'One step > process' in the documentation of Semantic Forms). That way, adding a new > employment from the page of a person is a one-click process. That is, > you > can add a link or a button called 'Add a new employment' from a page of > a > category Person. > > 4- After that, it becomes relatively easy to query for co-employment > (ask > for people in the same company around the same time). > > It's a slight variation of what Bob suggested but it works very well in > practice (now that I read again the previous answer, it is probably the > same > solution with different names - but I am sending this anyway in case it > can > cast the answer under a different light). > > - Laurent > > On Sat, Mar 20, 2010 at 12:23 PM, Bob MacCallum <unc...@gm...> > wrote: > > > You could start with a page [[Steve Johnson at BigMachines]] > > and set a daily (or weekly or monthly) recurring event property "was > > employed on date" for the relevant period. > > The page would also [[has employee::Steve Johnson]] and [[has > > employer::BigMachines]] and probably [[Category:Employment]] > > > > Do the same for the other "Person at Company" facts you have at hand. > > > > Then for a given (single) date and company you can query who was > employed > > there > > > > {{#ask: [[Category:Employment]] [[was employed on date::20-01-2008]] > > [[has employer::BigMachines]] > > |?has employee > > }} > > > > It's not exactly what you want, but it might be in the right > direction. > > > > You should also be able to start the query on the Employee page e.g. > > [[Steve Johnson]] > > with something like > > > > {{#ask: [[Category:Employment]] [[was employed on date::20-01-2008]] > > [[has employee::{{PAGENAME}}]] > > |?has employer > > }} > > > > Once you have the employers (remember this guy could be moonlighting) > > you can arraymap another query to get the employees on that date. I > > haven't tried any of these queries, so you'll probably need > > mainlabel=- and link=none and other tricks. > > > > Looping all this for multiple dates is going to be expensive, I > imagine. > > > > Any other suggestions? > > > > On Sat, Mar 20, 2010 at 2:31 PM, Schouten, Edgar J. (RB-NL) > > <Edg...@re...> wrote: > > > Dear Semediawikians, > > > > > > > > > > > > I'm trying to express the fact that a relation between a person and > a > > > position at a company is limited in time. > > > > > > Examples: > > > > > > Steve Johnson worked at SteelWorks as CFO from 01-01-2000 through > > > 01-02-2005 > > > > > > Steve Johnson worked at BigMachines as CEO from 01-02-2005 through > > > 01-02-2008 > > > > > > Bill McCoy worked at BigMachines as CTO from 01-01-2008 through > > > 01-01-2010 > > > > > > > > > > > > My goal would be to make concepts asking about co-workers of a > person in > > > a particular timeframe > > > > > > > > > > > > While Steve Johnson worked at BigMachines as CEO, who else was > working > > > there? > > > > > > In this case: Bill MacCoy (they co-worked from 01-01-2008 (which is > > > Bill's appointment) through 01-02-2008 (Steve resigning as CEO) > > > > > > > > > > > > I seem to be able to express the fact that Steve and Bill know each > > > other. (as a static fact) > > > > > > But I can't get my finger around co-working (as a relationship to a > > > company they have in common with date-boundaries) > > > > > > > > > > > > Is this something that somehow could be done using semantics? > > > > > > Thanks in advance for making suggestions that will point me in the > right > > > direction. > > > > > > > > > > > > Kind Regards > > > > > > EdgarS > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------------------------ > ------ > > > Download Intel® Parallel Studio Eval > > > Try the new software tools for yourself. Speed compiling, find bugs > > > proactively, and fine-tune applications for parallel performance. > > > See why Intel Parallel Studio got high marks during beta. > > > http://p.sf.net/sfu/intel-sw-dev > > > _______________________________________________ > > > Semediawiki-user mailing list > > > Sem...@li... > > > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > > > > > > > > > > > -- > > http://darwintunes.org - a test-tube for cultural evolution > > http://evolectronica.com - survival of the funkiest > > http://compare-stuff.com - confused? you will be! > > http://twitter.com/darwintunes > > http://twitter.com/bobmaccallum > > > > > > > ------------------------------------------------------------------------ > ------ > > Download Intel® Parallel Studio Eval > > Try the new software tools for yourself. Speed compiling, find bugs > > proactively, and fine-tune applications for parallel performance. > > See why Intel Parallel Studio got high marks during beta. > > http://p.sf.net/sfu/intel-sw-dev > > _______________________________________________ > > Semediawiki-user mailing list > > Sem...@li... > > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > > > > > > -- > - Laurent Alquier > http://www.linfa.net > > > ------------------------------ > > ------------------------------------------------------------------------ > ------ > Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > > ------------------------------ > > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > > > End of Semediawiki-user Digest, Vol 46, Issue 48 > ************************************************ > > > ------------------------------------------------------------------------------ > Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > -- WikiWorks · MediaWiki Consulting · http://wikiworks.com |