CID Fusion Query

This chrome extension allows Oracle Fusion SaaS developers and business analysts to run SQL queries against database. ** Changed…

This chrome extension allows Oracle Fusion SaaS developers and business analysts to run SQL queries against database. ** Changed in version 2.6 ** 1. One Click Login - community voted feature ** Changed in version 2.5.4 ** 1. Bug fixing in parameter popup. ** Changed in version 2.5.3 ** 1. Fix data display when fetching nested or malformed XML from columns. 2. Make Run button to be default in parameter screen. ** Changed in version 2.5.1 ** 1. Added leading whitespace in query to allow bigger query processing ** Changed in version 2.4 ** 1. Fixed special characters in SQL history 2. Fixed storage quota 3. Make SQL available immediately in SQL history 4. Fix sorting in SQL history window ** Changed in version 2.3 ** 1. Added export to Excel 2. Added Execution timing 3. Added SQL History ** Changed in version 2.2 ** 1. Parameters support added. ** Changed in version 2.1 ** 1. Fixed special HTML/XML characters ** Changed in version 2.0 ** 1. Add option of SSO login without password. Click on Login with SSO when you have already open tab matching the environment. 2. Remove default sorting on first result column ** Changes in version 1.9.1: 1. WITH function support restored 2. Support for special characters added. 3. Now characters like < > and other XML special characters will not break the results. 4. In order to use it - please reinstall the utility report by using the Installation instructions. ** Changes in version 1.9: 1. Support for special characters added. 2. Now characters like < > and other XML special characters will not break the results. 3. In order to use it - please reinstall the utility report by using the Installation instructions. ** Changes in version 1.8: 1. Reverted query calculation to support big records. ** Changes in version 1.7: 1. Added support for special characters in SQL and in response. Previously broke the results. ** Changes in version 1.6: 1. Added support for unicode characters in results. ** Changes in version 1.5: 1. Corrupted ZIP fixed. ** Changes in version 1.4: 1. Added divider between SQL and results. 2. Utils report changed to show empty columns. Users will have to update the report in BIP catalog. ** Changes in version 1.3: 1. Added Object Browser and Refresh Metadata. ** Changes in version 1.2: 1. Syntax highlight is added by implementing SQL editor as Visual Studio Monaco editor. To use this extension follow the next steps: 1. Install the extension and expose it on your browser toolbar. 2. Click on CFQ icon on the toolbar - it will open CFQ UI. 3. Register the Fusion SaaS instances you want to work with by using Environments button. 4. If you are using CFQ for the first time with currently logged in instance, follow the steps described in Installation instructions. 5. Click on Login button and provide Fusion SaaS environment which is currently selected. Currently we support only local Fusion SaaS users. Your password will be kept in the session for subsequent query executions and will be sent to Fusion SaaS server only. Upon Login process the values are just saved in the session but not checked, they will be checked during the first query execution. If your password or user are not valid - you will get Unauthorized error. 6. Enter one or more queries in the Query box 7. Use Run Query button or Ctrl/Cmd+Enter combination to run currently selected text or full text if nothing selected. You are welcome to rate this plugin and let us know what you think about it to info@cidsolutions.co.il.