Forum | Appery.io

Hi Pavan,

Please tell us detailed what q parameter you are referring to.
Show screen shot.

I am having trouble.

This returns all
code
return 'PIN__c = '+value+'';
/code

This is the statement it generates in the app...
code
q=SELECT+Id%2C+Name%2C+PINc+%0AFROM+Employeec&WHERE=PIN__c+%3D+1234
/code

This is based on your syntax above, but gives an error.
code
return 'PIN__c = '"+value+"'&quot
/code

This is a successful SOQL statement in Salesforce. So I feel like I need the single quotes.
codeSELECT Id,Name,PINc FROM Employeec WHERE PIN__c = '1234'
/code
.

Can you help?

I added the " before PIN and I am still getting all of the records, instead of the filter query.

codereturn "PIN__c = '"+value+"'&quot /code

Still need help, something isn't right.

It seems to be returning a : after the WHERE statement. That is not right???

Hi Lee,

Please show us screen shots of your implementations and what is not works.

Thanks.

I found a solution yesterday. The problem is that you cannot add a parameter to the SOQL statement within Appery.io. It is formatted incorrectly. You have to pass the entire query. I would recommend you at least provide feedback to a developer on this situation.

Hello Lee,

Thanks for update.
Just to clarify, could you tell us what do you mean
" cannot add a parameter to the SOQL statement"

As I understood SQL statement it's just a string, and since Appery.io works with JS you can add any parameter to any string,

Sure. I was able to pass the entire string via JS. What I wanted to do, was to add a Parameter to the Appery.io database service that is built into Appery.io. I am not a programmer and I made the assumption that your custom integration service would return a WHERE statement within the service. however, it formatted the statement with a ":" and rendered the wrong syntax. I had to go into the testing component of Chrome and determine what the system was doing and then re-create the proper syntax in JS. Again, as a non-programmer this took me a long time to solve. SOQL is the query language used by Salesforce. I think you should make it very clear that your Salesforce integration does not render SOQL statements correctly so that folks will know. Thanks for following up.

Appery.io uses pure REST, so it doesn't contain any additional parameters and templates

That is why you need to make users aware when using your Salesforce integration. It is limited.