To add to Scott's reply, pretty much every SM module does one of the following:
1. Adds more triples into the pipeline (e.g., modules that import (load) RDF files or files that are auto-converted to RDF such as XML) 2. Establishes connection to external sources of triples (e.g., modules that connect to RDF databases, they are call "import" as well, but they just establish connection, they don't actually add triples from the external source into the pipeline) 3. Performs some processing based on triples that are passed to them as an input a) through the pipeline or b) from an external source (e.g, module that converts RDF to XML) 4. Does both 1 and 3 (e.g., inferencing modules or perform SPARQL update module) 5. Controls the processing (e.g., iterate over select) 6. Exports the results (e.g, all the "return" modules) Thus, a question to ask is what do you want to happen as a result of the select query? Depending on the answer, you may or may not need to run the select. Are you trying to return some RDF as a web service, for example? Then you don't really need the select query. Instead, you get to the point where the pipeline contains only the triples you want to return and the return module would return all of them. If you do need a select query and want to see modules that have it as a parameter, open your script, navigate to sml:selectQuery and see all the places it is referenced. Regards, Irene -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Scott Henninger Sent: Wednesday, October 03, 2012 6:06 PM To: TopBraid Suite Users Subject: [topbraid-users] Re: SPARQLMotion Distinct Mark; Most SPARQLMotion modules include a query property. Some examples - that you can download - are found at http://www.topquadrant.com/products/SPARQLMotion_docs/SPARQLMotion_ex_dbpedi aCapitals.html. I'd also suggest spending some time with the SPARQLMotion home page (http://www.topquadrant.com/products/SPARQLMotion.html) and the Getting Started Guide, Tutorial, and Videos provided on that page. Beyond that, if you have a more specific place you were looking to "use in a SPARQLMotion script to perform a SELECT query", let us know. A hint: IterateOverSelect is needed less often than one would initially believe because SPARQL's declarative nature take care of iteratively finding results. -- Scott On Oct 3, 3:02 pm, Mark Colquhoun <[email protected]> wrote: > Hi Scott, > > Yes that will work but I guess I'm missing something as I couldn't see > which module I could use in a SPARQLMotion script to perform a SELECT query > apart from an Iterate Over Select? > > Regards, > Mark. > > > > > > > > On Thursday, October 4, 2012 12:11:28 AM UTC+10, Scott Henninger wrote: > > > Will SELECT DISTINCT ?substr work? If not, we will need more > > information on what your queries and script look like, etc. > > > -- Scott > > > On Oct 2, 11:50 pm, Mark Colquhoun <[email protected]> > > wrote: > > > Hi, > > > > Within a SPARQLMotion script, I need to read a spreadsheet and find the > > > distinct values in a column based on a substring performed on the > > column. I > > > can do all of this except the distinct part and am looking for some > > > pointers. An example of the data might be: > > > > AI4120_0306_cH > > > AI4120_0306_cHH > > > AIC4120_0042_cSP > > > AIC4120_0042_sCV > > > > From these values, I want to create a substring including everything to > > the > > > left of the last _. > > > > AI4120_0306 > > > AI4120_0306 > > > AIC4120_0042 > > > AIC4120_0042 > > > > Easy enough so far but from here I want to select the distinct values. > > I'm > > > sure this should be easy but I haven't been able to find any build in > > > functionality to achieve this. The end result that am after should look > > > like: > > > > AI4120_0306 > > > AIC4120_0042 > > > > I'm sure there is something that I am overlooking so any help would be > > > greatly appreciated. > > > > Regards, > > > Mark. -- -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include Enterprise Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid Ensemble, SPARQLMotion, SPARQL Web Pages and SPIN. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en -- -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include Enterprise Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid Ensemble, SPARQLMotion, SPARQL Web Pages and SPIN. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en
