You can find some information here
https://www.semantic-mediawiki.org/wiki/SQLStore_update

But directly accessing the SQL tables is not recommended.

Regards,
Nischay Nahata

On Wed, Sep 14, 2016 at 7:02 AM, James HK <jamesin.hongkon...@gmail.com>
wrote:

> Hi,
>
> >>> > > changed since the introduction of Store3 if I am not mistaken which
> >>> > > happened four years ago with SMW 1.8.0.
>
> >>> > >> select object_title from smw_relations where subject_title
> >>> > >> in('Page1','Page2') and relation_title='Section_of'
>
> > MW :1.21.3
> > SMW:1.8
>
> SMW 1.8 has been long out of maintenance and given that you make
> reference to SQLStore version 2 (I think `smw_relations` was used as
> table name back then) I cannot given any assistance or advice other
> than upgrade to a more recent version.
>
> PS: I do think SQLStore version 2 had an abstraction layer to avoid
> interacting directly with the DB (which I'm assuming from your
> example), so my advise also here is DON'T query tables in a SQL like
> fashion and instead use the interfaces available.
>
> PSS: Some examples on how to interact with a more recent SQLStore to
> match properties and/or values can be found at [0].
>
> [0] https://github.com/SemanticMediaWiki/SemanticMediaWiki/blob/master/
> docs/technical/code-snippets/match.property.values.md
>
> Cheers
>
> On 9/13/16, Rajesh S6 <rajesh...@tcs.com> wrote:
> > Hi
> > Thanx lot for response
> >
> > MW :1.21.3
> > SMW:1.8
> >
> > Sent from my iPhone
> >
> >> On 13-Sep-2016, at 11:02 PM, Nischay Nahata <nischay...@gmail.com>
> wrote:
> >>
> >> Hi Rajesh,
> >>
> >> It would be great if you could include both the versions of SMW you are
> >> using for others to help you.
> >>
> >> Regards,
> >> Nischay
> >>
> >>
> >>> On Sep 13, 2016 10:52 PM, "Rajesh S6" <rajesh...@tcs.com> wrote:
> >>>
> >>> > Hi,
> >>> Sorry my previous mail not delivered to Dev team due to subscriptions
> >>> issue.
> >>>
> >>> > Please help us on the mentioned doubt. Eagerly waiting for response.
> >>> >
> >>> > Regards,
> >>> > Rajesh s
> >>>
> >>>
> >>> > On 13-Sep-2016, at 10:33 PM, Rajesh S6 <rajesh...@tcs.com> wrote:
> >>> >
> >>> > Hi,
> >>> > Please help us on the mentioned doubt. Eagerly waiting for response.
> >>> >
> >>> > Regards,
> >>> > Rajesh s
> >>> >
> >>> > > On 13-Sep-2016, at 3:49 AM, kghbln <mediaw...@kghoffmeyer.de>
> wrote:
> >>> > >
> >>> > > Heiya Rajesh,
> >>> > >
> >>> > > I cannot tell but it seems to me that this may be something for the
> >>> > > developer list (copied). The structure of the relational backend
> has
> >>> > > not
> >>> > > changed since the introduction of Store3 if I am not mistaken which
> >>> > > happened four years ago with SMW 1.8.0.
> >>> > >
> >>> > > Cheers Karsten
> >>> > >
> >>> > >> Am 12.09.2016 um 07:46 schrieb Rajesh S6:
> >>> > >> Hi ,
> >>> > >>
> >>> > >>
> >>> > >> In earlier semantic we used to get the object_title
> >>> > >>
> >>> > >> select object_title from smw_relations where subject_title
> >>> > >> in('Page1','Page2') and relation_title='Section_of'
> >>> > >>
> >>> > >> now it is not storing in this table, please help how to get. it is
> >>> > >> very
> >>> > >> urgent and show stopper issue for us.
> >>> > >>
> >>> > >> Thanks & Regards
> >>> > >> S. Rajesh
> >>> > >> =====-----=====-----=====
> >>> > >> Notice: The information contained in this e-mail
> >>> > >> message and/or attachments to it may contain
> >>> > >> confidential or privileged information. If you are
> >>> > >> not the intended recipient, any dissemination, use,
> >>> > >> review, distribution, printing or copying of the
> >>> > >> information contained in this e-mail message
> >>> > >> and/or attachments to it are strictly prohibited. If
> >>> > >> you have received this communication in error,
> >>> > >> please notify us by reply e-mail or telephone and
> >>> > >> immediately and permanently delete the message
> >>> > >> and any attachments. Thank you
> >>> > >>
> >>> > >>
> >>> > >> ------------------------------------------------------------
> ------------------
> >>> > >> _______________________________________________
> >>> > >> Semediawiki-user mailing list
> >>> > >> semediawiki-u...@lists.sourceforge.net
> >>> > >> https://lists.sourceforge.net/lists/listinfo/semediawiki-user
> >>> > >
> >>> > > ------------------------------------------------------------
> ------------------
> >>> > > What NetFlow Analyzer can do for you? Monitors network bandwidth
> and
> >>> > > traffic
> >>> > > patterns at an interface-level. Reveals which users, apps, and
> >>> > > protocols are
> >>> > > consuming the most bandwidth. Provides multi-vendor support for
> >>> > > NetFlow,
> >>> > > J-Flow, sFlow and other flows. Make informed decisions using
> >>> > > capacity
> >>> > > planning reports. http://sdm.link/zohodev2dev
> >>> > > _______________________________________________
> >>> > > Semediawiki-user mailing list
> >>> > > semediawiki-u...@lists.sourceforge.net
> >>> > > https://lists.sourceforge.net/lists/listinfo/semediawiki-user
> >>> ------------------------------------------------------------
> ------------------
> >>> _______________________________________________
> >>> Semediawiki-user mailing list
> >>> semediawiki-u...@lists.sourceforge.net
> >>> https://lists.sourceforge.net/lists/listinfo/semediawiki-user
> >
>
------------------------------------------------------------------------------
_______________________________________________
Semediawiki-devel mailing list
Semediawiki-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel

Reply via email to