User bio
404 bio not found
Member since Feb 26, 2016

Hello again Benjamin!
Thank you for the quick reply.

The EntityAPI would indeed do the job for the query above but I haven't found any API for the query below. However, I found out that $SYSTEM.SQL.Execute() does precisely what I need!

I have a few more minor questions about strings if you don't mind.

  1. Is string addition/concatenation possible in Object Script? set query = "select * from " + tableName
    I've read "Basic String Operations and Functions" but didn't find any answers. 
  2. Does Object Script supports multiline strings? The query below is very long and it would look nicer if it could be divided it into multiple lines.

SET myquery="select Master->EntityValue , Relation->EntityValue , Slave->EntityValue, source.SourceId FROM %iKnow_Objects.CrcUnique crc  JOIN %iKnow_Objects.CrcInSourceDetails as source ON crc.CrcUniId = source.CrcUniId WHERE source.DomainId = 1 AND Relation->EntityValue LIKE 'ring%' ORDER BY CorpusFrequency  DESC " 
SET result=$SYSTEM.SQL.Execute( myquery )
DO result.%Display()

The query should look for CRCs containing some words, and then return the CRC and the source that contains the CRC


I'm sorry for the confusion. We are doing a qualitative study on a set of documents to see if we can find important features in them. What we want to do is answer the question "Which of these documents contains this CRC". 

I don't know if this is easier to do client side or server side but it don't think it matters in our case. The reason I wrote Atelier was because I thought that was the simplest way to get started for a beginner. 

If you have any suggestions on alternative methods I'd be happy to hear them!
I know PHP and SQL, is it possible to query iKnow from PHP? It seems possible but I could find anything on Learn -> FAQ or Google. If it's possible I would greatly appreciate if you could point me to some documentation on the subject.

Thank you all for the great answers!   

Benjamin has no followers yet.
Benjamin has not followed anybody yet.
Global Masters badges:
Benjamin has no Global Masters badges yet.