Instructions
1) Prepare Your Data:
Format your data as a JSON string. For example:
[{"name":"John","age":30,"city":"New York"},{"name":"Jane","age":25,"city":"Paris"},{"name":"Tom","age":35,"city":"Berlin"}]
2) Define Your Query:
Write your SQL query. Use data as the table name. For example:
SELECT * FROM ? WHERE age > 28
3) Using the Plugin:
In the "Data Source" field, enter your JSON data string or use a dynamic expression that returns a JSON string.
In the "Query String" field, enter your SQL query.
4) Retrieving Results:
The plugin will return the query results as a JSON string in the "Query Result" field.
If an error occurs, a detailed error message will be returned in JSON format.
** Tips for Efficient Use **
Ensure your data is in valid JSON format.
Double-check your SQL syntax before running the query.
For complex queries, consider indexing frequently accessed fields in your data structure.
When dealing with large datasets, optimize your queries to limit the result set size.
** Error Handling **
If you encounter an error, check the returned JSON for detailed error information.
Common errors include invalid JSON data, incorrect SQL syntax, or referencing non-existent fields.
** Performance Considerations **
This plugin is suitable for datasets of very large size.
it use server-side processing.
Complex queries may take longer to execute. Optimize your queries for better performance.