Rlabkey and flow question

LabKey Support Forum
Rlabkey and flow question alexander karpikov  2013-09-10 15:49
Status: Closed
 
Hi all,

I have successfully installed rLabkey and can query from a flow analysis. For instance this works

  getRows(s, scobj$FCSAnalyses$Run)

However, I can not seem to query statistics. The following statement fails.

  getRows(s, scobj$FCSAnalyses$Statistic/Lymphocytes:Freq_Of_Parent)

Do you have advice on the correct syntax for querying statistic columns?

Thanks,
Sasha
 
 
Leo Dashevskiy responded:  2013-09-10 18:46
Hey, Sasha, how about enclosing the last lookup token in quotes:

getRows(s, scobj$FCSAnalyses$'Statistic/Lymphocytes:Freq_Of_Parent')

does that work for you?

-L.
 
alexander karpikov responded:  2013-09-16 15:19
Hi Leo,
Thanks for you reply!
Yes it worked, but it gave me the same output as:
getRows(s, scobj$FCSAnalyses$Statistic)
do you know by any chance why it gives me the whole thing instead of giving only:
Lymphocytes:Freq_Of_Parent
Thank you,
Sasha.
 
Leo Dashevskiy responded:  2013-09-16 15:27
Hm, I'm not sure about that one.

I personally do not use this approach with a session.

I use the other flavor of the API:

labkey.selectRows(), labkey.deleteRows(), labkey.insertRows() and labkey.executeSql() -- there you must specify the server address and the folder path with each call -- have you tried it at all, does it produce same or different results?
 
alexander karpikov responded:  2013-09-16 15:34
Thanks again Leo.
I have not tried it yet but I am interested- are those Java API?
Sasha
 
Leo Dashevskiy responded:  2013-09-16 15:38
No-no, those are equivalents to use in R within the Rlabkey package...
 
alexander karpikov responded:  2013-09-16 15:43
Great,
I will try it and I will let you know.
Best,
Sasha