Retrieving data from ProfileManager database
Hello
I have the next information which locates in ProfileManager database (SQL 2000):
<rdf:RDFxmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
xmlns:UserInfo="http://example.org/stuff/1.0/">
<rdf:Descriptionrdf:about="http://www.contoso.com/csf/pm/syedabbas/User1">
<UserInfo:FullName>User1</UserInfo:FullName>
<UserInfo:UserId>1</UserInfo:UserId>
<UserInfo:Content>
<rdf:Descriptionrdf:about="http://www.example.org/Ch1">
<UserInfo:ContentCategory>xRate</UserInfo:ContentCategory>
</rdf:Description>
</UserInfo:Content>
<UserInfo:Content>
<rdf:Descriptionrdf:about="http://www.example.org/Ch2">
<UserInfo:ContentPrice>0</UserInfo:ContentPrice>
</rdf:Description>
</UserInfo:Content>
<UserInfo:Content>
<rdf:Descriptionrdf:about="http://www.example.org/Ch3">
<UserInfo:ContentName>Channel3</UserInfo:ContentName>
<UserInfo:ContentPrice>10</UserInfo:ContentPrice>
<UserInfo:ContentCategory>xRate</UserInfo:ContentCategory>
</rdf:Description>
</UserInfo:Content>
</rdf:Description>
<rdf:Descriptionrdf:about="http://www.contoso.com/csf/pm/syedabbas/User2">
<UserInfo:FullName>User2</UserInfo:FullName>
<UserInfo:UserId>2</UserInfo:UserId>
<UserInfo:Content>
<rdf:Descriptionrdf:about="http://www.example.org/Ch2">
<UserInfo:ContentName>Channel5</UserInfo:ContentName>
<UserInfo:ContentCategory>Cool</UserInfo:ContentCategory>
</rdf:Description>
</UserInfo:Content>
</rdf:Description>
</rdf:RDF>
Now I want to retrieve, for example, for User1 next information with help of ProfileManager SPARQL query, but I fail.
<UserInfo:Content>
<rdf:Descriptionrdf:about="http://www.example.org/Ch2">
<UserInfo:ContentPrice>0</UserInfo:ContentPrice>
</rdf:Description>
</UserInfo:Content>
Could you please help me with this?
Thank you in advance!
