marklogic-community / data-explorer

Data Explorer Tool
Other
15 stars 4 forks source link

Database Sampling not working for JSON #193

Open josvanroosmalen opened 5 years ago

josvanroosmalen commented 5 years ago

Several MLCS people reported that JSON Database sampling is not working. I have analysed this issue, and I am working on a fix.

markschiffner commented 4 years ago

I created a gradle task to load the farmers data as json. When I try to create a query, I get a UI error "Server Error. Please try again later." when trying to save the query. Steps to reproduce: 1) Load the farmers data: gradle loadDemoDataJSON 2) Edit Config, Create a query 3) Sample the database, choose JSON 4) Choose Data-Explorer-content; should have 8,675 json documents 5) Set collections to JSONDemoData, hit enter, not sure if the lookup button does anything. 6) Choose document type "/" - Not sure what this means in context of JSON, could be the issue? 7) Press select fields button 8) Enter query name 9) Path filter is a issue!!! We don't see, to have a "root" json choice - Choose /MarketPlace 10) Set MarketName to Both and save -- Gets the error!!!

Issues: 1) The error upon saving 2) Having the path filter that does not have root, seems like it will use / on the screen, but not the choose relevant fields page. 3) On pick a Document Type, does Lookup button do anything?