Mark VanLandingham
30fe9289b8
Allow groups to access queries ( #36 )
...
* [WIP] group ids saving on new reports
* Add groups to default queries, and added tab connector
* group_ids set to empty array for default queries
* group reports route (in & and) action
* [WIP] created group reports show route/controller
* Find correct query in show route
* Removed empty array for group_ids in query file
* Add report show view, where users can run queries
* Removed unneeded commas from queries.rb
* Allow non-admin group members to access reports
* query-result component dynamic download url based on location
* Removed accidental changes, and corrected tab size
* Group members can add params to queries
* Specs for new QueryController actions
* remove "Inlude query plan" from group reports
* Run prettier
* return and return -> return render
Co-Authored-By: Robin Ward <robin.ward@gmail.com>
* [WIP] changes from review
* Remove weird [-1] group_ids logic, for a simply check for [] in query update action
* Added integration tests for group report access
* Using guardian for securing endpoints, and much improved specs
* Update assets/javascripts/discourse/components/group-reports-nav-item.js.es6
Co-Authored-By: Robin Ward <robin.ward@gmail.com>
2019-09-11 10:09:41 -04:00
Joffrey JAFFEUX
677722d676
FIX: prevents egression mutating read only object
2019-07-25 07:50:31 +02:00
Joffrey JAFFEUX
8f0bd298b1
fixes prettier
2019-07-16 13:15:27 +02:00
Joffrey JAFFEUX
b9169ec28e
REFACTOR: old patterns, deprecations and dead code ( #35 )
2019-07-16 12:46:32 +02:00
Penar Musaraj
ed2e0b8c13
Run Prettier
2019-06-14 13:27:41 -04:00
Penar Musaraj
300c862244
Fix eslint
2019-06-14 12:29:06 -04:00
Sam Saffron
29862defaa
FEATURE: add support for _url to link to a url
...
This new feature means that if you name a column `xyz_url` then the return
value will be treated as a URL.
If you would like to name the link use the format `name,https://cnn.com `
2019-05-13 14:44:51 +10:00
Osama Sayegh
859021bb3c
UX: make SQL editor resizable ( #33 )
2019-04-07 09:05:43 +03:00
Rishabh
0ed53f7c5e
DEV: Remove debug statement in explorer-container.js
2019-02-05 16:42:07 +05:30
Rishabh
6a69daf39a
UX: Clean up button styles for query pages
...
- Add a "play" glyph for the Run & SaveRun buttons
- ensure that there's only one primary button on the page i.e. Run
- Remove btn-danger from discard button
- remove redundant button class from create button
- Improve redundant copy by removing the word "Query"
2019-02-05 14:21:52 +05:30
Rishabh
13ab013df2
FIX: Ensure that all query information persists after delete/un-delete operations
...
https://meta.discourse.org/t/data-explorer-created-by-missing/107195
2019-01-28 12:30:17 +05:30
Rishabh
a285a38e9c
FIX: Allow the Data Explorer API to set LIMIT to "ALL"
...
Fixes a bug that prevented returning unlimited rows.
Example request:
{{base_url}}/admin/plugins/explorer/queries/6/run?api_key={{api_key}}&api_username={{api_username}}&limit=ALL
From the PostgreSQL docs: "LIMIT ALL" is treated as no limit
https://www.postgresql.org/docs/current/static/sql-select.html#SQL-LIMIT
2019-01-23 16:18:06 +05:30
Rishabh
a96bfdf6d5
DEV: Remove ESLint warnings 🚨
2019-01-22 17:19:01 +05:30
Rishabh
8720c2cd5c
DEV: Replace hardcoded result limit with a module constant
2019-01-21 14:21:53 +05:30
Rishabh
f1b33cc64e
UX: Make the 'or' text in json-file-uploader smaller than the modal title
2019-01-09 15:24:06 +05:30
Joffrey JAFFEUX
0d655221f4
FIX: ensures filteredContent is recomputed when sortBy changes ( #30 )
2018-12-28 14:58:28 +05:30
Joffrey JAFFEUX
2b6357f8b4
FIX: ember 3 support
2018-12-16 15:22:23 +01:00
Rishabh
0af2453c23
FEATURE: Make searching case-insensitive
2018-11-16 16:13:40 +05:30
Penar Musaraj
061322e53a
Finalize FA5 fixes
2018-11-15 11:12:32 -05:00
Penar Musaraj
d05fb698d6
FA5 icon fix
2018-11-08 11:37:23 -05:00
Rishabh Nambiar
47f8de9c35
FIX: Show schema info tooltips inline
2018-11-08 12:04:04 +05:30
Rishabh
344f6e357d
FEATURE: Replace combo-box with search filter ( #28 )
...
* FEATURE: Replace combo-box with search filter
* Delete unused listname property and css fixes
* Use ES6 syntax and `@computed` decorator
2018-11-02 18:11:20 +05:30
Rishabh Nambiar
9dcba5c6e7
FEATURE: Allow clickable post titles in Data Explorer result view using post_id
2018-10-23 16:17:46 +05:30
Rishabh Nambiar
9d7db064af
run Prettier
2018-10-10 17:31:14 +05:30
Rishabh
b352e747c7
FEATURE: Ship default queries with the Data Explorer
...
Load default queries from queries.rb and save when run.
Each time a query is run, it picks up changes from queries.rb.
2018-10-10 16:59:13 +05:30
Rishabh Nambiar
f876cf66f1
Increase result limit from 250 to 1000
2018-09-18 11:24:37 +05:30
Rishabh Nambiar
316923f190
FEATURE: Show the number of results after running a query (limit 250)
2018-09-18 11:15:31 +05:30
Rishabh Nambiar
68059b540e
UX: Style improvements in query edit & result view
2018-09-12 18:58:54 +05:30
Rishabh Nambiar
90c2be7f82
FIX: Remove inconsistent row-highlight from the recent queries list
2018-09-12 16:38:08 +05:30
Rishabh Nambiar
1ea20132a0
FIX: Remove an unnecessary Handlebars condition
2018-09-12 14:53:29 +05:30
Rishabh Nambiar
dc91b7d0cd
FIX: Remove useless no_query_hook text and move create & import buttons to top right
2018-09-07 16:06:23 +05:30
Kris
6904e516ae
Removing br tags so an empty description doesn't add space
2018-09-05 13:33:06 -04:00
Kris
a8742f4c64
UX: Minor style improvements and consistency
2018-09-04 14:53:12 -04:00
Rishabh Nambiar
a518ac58fc
FIX: Restrict clickable area to the size of heading-toggle
2018-09-04 21:52:44 +05:30
Rishabh Nambiar
9e27d0b8d3
FIX: Update stylesheet to use indented sass syntax
2018-09-03 00:27:44 +05:30
Rishabh Nambiar
5edb8ea7f8
UX: Make Explorer UI similar to User Activity and Groups pages
2018-08-31 23:41:33 +05:30
Rishabh Nambiar
5a75b6c1e1
FIX: Fix ESLint issues and use d-icon instead of <i> tags
2018-08-30 21:35:43 +05:30
Rishabh Nambiar
d5d933c2a8
FEATURE: Sort queries by names, last_run_at by clicking table headers
2018-08-30 17:32:52 +05:30
Rishabh Nambiar
80f97d9514
UX: Force refresh model to update last_run_at after a query is run
2018-08-30 14:13:40 +05:30
Rishabh Nambiar
3bdf624ced
UX: Improve padding while editing a query and text-field width consistency
2018-08-29 13:21:02 +05:30
Rishabh Nambiar
0673b68a58
FIX: Make entire row clickable
2018-08-28 12:39:33 +05:30
Rishabh Nambiar
6a57f6536d
FIX: Render creation date instead of run date if query was never run
2018-08-28 12:14:43 +05:30
Rishabh Nambiar
1fc73a211a
FIX: Improved username alignment
2018-08-28 12:00:25 +05:30
Rishabh Nambiar
1b68847d21
FEATURE: Sort queries by last_run_at as default
2018-08-27 20:10:25 +05:30
Rishabh Nambiar
feb8a1ce0f
FIX: Don't save placeholder text only if description is empty
2018-08-25 23:02:43 +05:30
Rishabh Nambiar
2f0400a7e0
FIX: Don't save placeholder text if description is empty
2018-08-24 12:43:18 +05:30
Rishabh
71845a3d87
Merge pull request #17 from discourse/fix_default_description_text
...
FIX: Remove bad default query description and add placeholder instead
2018-08-20 14:05:05 +05:30
Rishabh Nambiar
7647b1597f
FIX: Use predefined SCSS colors instead of hardcoded colors
2018-08-20 11:32:41 +05:30
Arpit Jalan
4af28311ab
hide controls on query page
2018-08-19 16:28:24 +05:30
Rishabh Nambiar
42b6dbbae2
FIX: Remove bad default query description and add placeholder instead
2018-08-19 10:24:53 +05:30
Rishabh Nambiar
86a4957bd1
FIX: Ensure that back button always redirects to index page
2018-08-17 15:30:07 +05:30
Rishabh Nambiar
a64ef6c6c7
Added button to go back to query list after visiting a query
2018-08-16 23:14:07 +05:30
Rishabh Nambiar
83b1fcb54b
Added User.find() & fixed scroll history bug
2018-08-14 17:38:08 +05:30
Rishabh Nambiar
6e806cc1df
Added clickable rows, default query sorting by id and clickable usernames
2018-08-14 17:38:08 +05:30
Rishabh Nambiar
e341d5a6fa
List all previous queries on Data Explorer homepage
2018-08-14 17:38:08 +05:30
Régis Hanol
7c94f98436
FIX: prevent creation of query with an empty name
2018-05-09 22:23:56 +02:00
Régis Hanol
aca7b188f6
UX: better blank state (create vs select a query)
2018-05-09 22:23:49 +02:00
Kris
7077a646c0
Hide none state from dropdown
2018-05-09 15:49:43 -04:00
Kris
41106fed61
class fix
2018-05-09 14:06:39 -04:00
Kris
c6f0284529
Adding placeholder for none state
2018-05-09 14:04:14 -04:00
Guo Xiang Tan
bcdff915dc
Make eslint happy.
2017-08-02 18:05:33 +09:00
Robin Ward
e68813e6dc
FIX: You don't need to require the route map, it's automatically found
2017-07-05 14:16:40 -04:00
Robin Ward
d82109b00b
FIX: Adds back removed component
2017-05-11 12:45:15 -04:00
Arpit Jalan
0d6af9d920
FIX: importing query was broken
2017-04-04 14:07:07 +05:30
Robin Ward
4b3e5d547d
FIX: Support raw templates in the latest discourse releases
2016-12-27 11:47:50 -05:00
Robin Ward
e2ee693f64
This file should be removed
2016-12-01 13:56:09 -05:00
Robin Ward
91815c9f00
FIX: Remove Deprecated Views
2016-12-01 13:54:21 -05:00
Robin Ward
0d62ad73d4
FIX: Don't have CPs perform sets
2016-11-24 15:31:05 -05:00
Robin Ward
f9e1177981
FIX: Invalid use of controller in a component
2016-11-09 12:49:25 -05:00
Robin Ward
8d72e979a5
FIX: Old Ember idioms
2016-11-09 11:58:18 -05:00
Guo Xiang Tan
414cda5578
FIX: Import `ajax` instead.
2016-10-31 09:12:01 +08:00
Robin Ward
37fe36778b
FIX: Deprecated debounce function
2016-02-17 17:17:43 -05:00
Sam
587e9d917c
fixes so it works in no constants mode
2015-11-21 12:49:23 +11:00
Arpit Jalan
34af6a5d54
FIX: group name can have dash and capital letters
2015-11-19 13:30:33 +05:30
Kane York
9956b9833e
Add topic,category,group,reltime rendering
2015-09-21 14:43:23 -07:00
Kane York
9145e32162
FIX: Show error message, not exception page, to mods
2015-09-21 11:19:31 -07:00
Kane York
4b3188c111
Fix rendering of columns named topic_id
2015-09-14 16:00:39 -07:00
Kane York
86a3d16ad4
Deprecations fixes
2015-09-14 15:34:57 -07:00
Kane York
7f96ea5632
Looks like it's working
2015-08-25 21:36:39 -07:00
Kane York
e0e7022538
WIP commit
2015-08-25 20:48:19 -07:00
Kane York
658d49393a
The new window is not used except by name
2015-08-03 15:28:09 -07:00
Kane York
43756ec8b6
Adjust styling of download results
2015-08-03 15:19:31 -07:00
Kane York
cb18bb9cd7
make that even bigger
2015-08-03 15:15:04 -07:00
Kane York
aff32aefa1
Move around data explorer UI stuff
2015-08-03 15:14:23 -07:00
Kane York
7201823c6b
Remove HTTPS warning
2015-08-03 15:09:51 -07:00
Kane York
1601f4f269
Add 'download results as CSV'
2015-08-03 15:07:29 -07:00
Kane York
fb42dc483c
Add denormalized column info
2015-07-28 11:18:22 -07:00
Kane York
ea1d38da57
Add foreign key info, column comment support
2015-07-28 09:59:26 -07:00
Kane York
d79f667a9b
Use this.site.categories
2015-07-15 16:16:07 -07:00
Kane York
5156ab1f72
Use HTTP status 422 for failures
2015-07-15 12:51:33 -07:00
Kane York
6a61f694ee
Fix float type checks
2015-07-15 12:23:56 -07:00
Kane York
45c2636ea0
Fix boolean parameters
2015-07-15 11:00:31 -07:00
Kane York
5b11bbec68
Finish group/category validation, add user lists
2015-07-14 16:49:23 -07:00
Kane York
0672e99da2
Work on new parameter model
2015-07-14 16:01:38 -07:00
Kane York
198c64d86a
Don't show the ace editor right away, wait for edit pencil to be clicked
2015-07-14 10:34:23 -07:00
Kane York
c7a947542e
Allow expanding/collapsing the schema view
2015-07-14 09:44:42 -07:00
Kane York
f67d18d503
Fix the resizing (remove debounce on mousemove)
2015-07-14 09:04:18 -07:00
Kane York
2bbe69d67e
Include enum values in schema
2015-07-09 15:46:19 -07:00
Kane York
a953f83574
Use appEvents for ace resize
2015-07-09 14:10:45 -07:00
Kane York
09398dc8c2
add bottom pad to explorer page
2015-07-09 13:58:22 -07:00
Kane York
7f644019a8
Add resizing
2015-07-09 13:20:21 -07:00
Kane York
d748e0dae5
give instructions in hanging tab
2015-07-09 12:45:02 -07:00
Kane York
71c3b73ef8
FEATURE: 'Download Result' removes 250-row limit
2015-07-09 12:03:25 -07:00
Kane York
7b6b4f9222
Fold plugins-explorer-show into main template
2015-07-09 10:50:00 -07:00
Kane York
dad55e085b
Restyling of data explorer
2015-07-08 16:46:36 -07:00
Kane York
6ac463290e
Add DB schema view beside query editor
2015-07-08 13:45:13 -07:00
Kane York
a0f38a2d17
Preserve pre-typed query parameters
2015-07-02 09:19:30 -07:00
Kane York
d9dbfc8408
Add text for no queries, keep results in query object
2015-07-02 09:15:55 -07:00
Kane York
b68ca164dd
CSS chnages
2015-07-01 12:31:55 -07:00
Kane York
88d7fa955a
Add HTTPS warning
2015-06-30 21:21:14 -07:00
Kane York
1ea74847ae
Display errors, convert integers
2015-06-30 19:51:38 -07:00
Kane York
baeb747fcb
Fix param-extraction
2015-06-30 16:43:43 -07:00
Kane York
a81f8495b0
Update URL. Regression - select2 not updating
2015-06-30 15:56:09 -07:00
Kane York
c56a40cacd
Import the result table and we're live
2015-06-30 15:12:12 -07:00
Kane York
dba181d92e
Bunch of progress. Tuesday 1PM
2015-06-30 12:52:17 -07:00
Kane York
78dafcc631
Rename the stylesheet
2015-06-30 10:37:48 -07:00
Kane York
ee1cc2d96d
Tuesday morning, 10AM
2015-06-30 10:20:22 -07:00
Kane York
95a50e1116
Tuesday morning, 9 AM
2015-06-30 09:07:33 -07:00
Kane York
a12c906c9a
mostly styling change
2015-06-29 12:10:24 -07:00
Kane York
c52ac59eee
Missed description sections, try to get model to work
2015-06-26 09:16:09 -07:00
Kane York
2c71bc11aa
More work on interface, fixes for backend
2015-06-25 14:53:03 -07:00
Kane York
01b38207d9
Start work on JS side
2015-06-25 13:26:31 -07:00
Kane York
174e6d6ecc
Initial commit as a clone of discourse-tagging
2015-06-25 09:25:15 -07:00