0 Replies Latest reply on Jul 22, 2010 9:24 PM by 786700

    Cytoscape plugin - Get Subset issue

    786700
      Has anyone tried to use the "Get Subset" option in the Cytoscape Plugin on more than 1 triple pattern?

      Using one triple pattern is fine but any more is causing the following error on the database:

      ORA-00904: "TRIPLE": invalid identifier
      ORA-06512: at "MDSYS.SEM_ANALYSIS", line 995
      ORA-06512: at line 1
      00904. 00000 - "%s: invalid identifier"
      *Cause:   
      *Action:

      The SQL that is being sent is:

      select *
      from table(mdsys.sem_analysis.get_matching_triples('DATAGOV', null, 100, 1,
      '(?s <http://www.data.gov/semantic/data/alpha/1354/dataset-1354.rdf#year> "2006")
      (?s <http://www.data.gov/semantic/data/alpha/1354/dataset-1354.rdf#make> "Hummer")',
      'triple(s,''http://www.data.gov/semantic/data/alpha/1354/dataset-1354.rdf#year'',''"2006"'') c1,
      triple(s,''http://www.data.gov/semantic/data/alpha/1354/dataset-1354.rdf#make'',''"Hummer"'') c2', null));

      It may be that I'm just doing something dumb.

      The following sem_match query I wrote does return the desired result but I was hoping to use Cytoscape for visualisation.

      select s, p , o
      from table(sem_match(
      '{ ?s d:make "Hummer" .
      ?s d:year "2008" .
      ?s ?p ?o
      }'
      ,sem_models('datagov')
      ,null
      ,sem_aliases(sem_alias('d','http://www.data.gov/semantic/data/alpha/1354/dataset-1354.rdf#'))
      ,null
      ))

      Edited by: Dave Ramsden on 22-Jul-2010 14:22