PSQL Query Execute
Run the PSQL query in the Cyllo user interface
From Settings > Technical > Database structures you can select the PSQL and create the query and execute. The fetched output from the query can then be printed to an Excel spreadsheet.
This module allows you to directly execute a query within the Cyllo interface and view the results there. The fetched output can then be printed to an Excel spreadsheet.
Key Features
- Execute and save the SQL query.
- Fetch Data Easily
- Print XLXS Report
Data Fetching
The module fetches data based on the chosen query or user-defined criteria.
Result Viewing
Users can view the retrieved data directly within the Cyllo interface.
Data Export
The fetched data can be exported to an Excel spreadsheet for further analysis or sharing.
PSQL Query.
Go To Settings -> Technical -> Database Structures -> PSQL Query.
Create New PostgreSQL Query
Write the SQL query for you to execute
Execute/Refresh the Query
Result of the query
Print Result
Downloaded Query Result.XLSX PSQL Result
Query Error
GNU Lesser General Public License v3.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you comply with the terms of the GNU Lesser General Public License, version 3.0, available at https://www.gnu.org/licenses/lgpl-3.0.html. You may develop software that uses the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those software under the terms of the GNU Lesser General Public License, version 3.0. It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software without including the complete text of the GNU Lesser General Public License, version 3.0, along with any applicable additional permissions. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
- base