SQL Query in Rollbase

I suppose adding a onclick event to the button, in this event you execute the query.

Hi Seema,

Go to Object Definition page.

Create a button.

In that button, provide script to executed sql query while creating it. And save the button.

Ex:

rbf_selectQuery("SELECT loginName FROM portalvisitor_obj where id={!id}", 10, callback);

function callback(values)

{

rbf_setFieldValue("name", values[0][0]);

}

The above code will get executed whenever you clicked on the button.

Please let me know if you have any questions.

Thanks and Regards,

Chandra.G