How to use generic values like ms2prec=X in SpectraQL query ?

[yguitton]

Hi @jorainer

I was trying to launch in R with SpectraQL the function below (found in https://msql.ucsd.edu/compendium/)
QUERY scaninfo(MS2DATA) WHERE MS2PREC=X AND MS1MZ=X AND MS1MZ=X+formula(Na)-formula(H)

I tried but failed because X is non numeric (I think)
<mh<- query(dda,"QUERY scaninfo(MS2DATA) WHERE MS2PREC=X AND MS1MZ=X AND MS1MZ=X+formula(Na)-formula(H)")
Error in .translate_condition_ms2prec(MS2PREC = c(MS2PREC = "X")) :
Missing or non-numeric value(s) for 'MS2PREC'
In addition: Warning message:
In .translate_condition_ms2prec(MS2PREC = c(MS2PREC = "X")) :
NAs introduced by coercion>

I know that not all massQL functions are already in SpectraQL, but would be super cool to be able to search for generic patterns
with X

Best
Yann

[jorainer]

Hm, good point. yes, and we did not (yet) implement things like formula(Na) - formula(H) - still lots of things to do I'm afraid - but thanks for pointing it out!