[ https://issues.jboss.org/browse/ISPN-8760?page=com.atlassian.jira.plugin.... ] Vladimir Blagojevic edited comment on ISPN-8760 at 2/12/18 4:14 AM: -------------------------------------------------------------------- *Use case scenario*: Upon selecting "RW+Query" action item on the "Actions" cache menu (see ISPN-8759) a user should be taken to a page that should be similar to Google's BigQuery (see screenshots below). Query console screen should have two text areas: query area and results area. Query text area should allow users to write our queries as-is and response text area should be rendered in JSON or tabular view. Query area is editable and response area non-editable. There should be a switch between JSON/tabular view for response area. Between query and results text area that are stacked on top of each other, there should be a submit button for submitting queries to the server. For example: {code:title=JSON query example|borderStyle=solid} { query: select id,name from Character where name:"Abomination (Emil Blonsky)", max_results:2 } {code} {code:title=JSON query result|borderStyle=solid} { "id": 1009146, "name": "Abomination (Emil Blonsky)", "description": "Formerly known as Emil Blonsky, a spy of Soviet Yugoslavian origin working for the KGB, the Abomination gained his powers after receiving a dose of gamma radiation similar to that which transformed Bruce Banner into the incredible Hulk.", "modified": "2012-03-20T12:32:12-0400", "thumbnail": { "path": "http://i.annihil.us/u/prod/marvel/i/mg/9/50/4ce18691cbf04", "extension": "jpg" }, "resourceURI": "http://gateway.marvel.com/v1/public/characters/1009146", "comics": { "available": 43, "collectionURI": "http://gateway.marvel.com/v1/public/characters/1009146/comics", "items": [{ "id": 34050, "resourceURI": "http://gateway.marvel.com/v1/public/comics/34050", "name": "Incredible Hulks (2009) #619" }] }, "wiki": { "universe": "Marvel Universe", "real_name": "Emil Blonsky", "identity": "Secret", "occupation": "Professional Criminal, Former Spy", "place_of_birth": "Zagreb, Yugoslavia", "groups": "Ally of the [[Abominations]] and the Forgotten; Formerly partner of the [[Rhino]], crew of the starship Andromeda, agent of the [[Galaxy Master]], and [[MODOK]].", "citizenship": "Citizen of Croatia; former citizen of Yugoslavia", "education": "Unrevealed", "aliases": "Agent R-7, the Ravager of Worlds", "relatives": "Nadia Dornova Blonsky (wife, divorced)", "height": "(Abomination) 6'8\"; (Blonsky) 5'10\"", "weight": "(Abomination) 980 lbs.; (Blonsky) 180 lbs.", "eyes": "(Abomination) Green; (Blonsky) Blue", "hair": "(Abomination) None; (Blonsky) Blond", "powers": "Blonsky's transformation into the Abomination substantially increased his strength and durability. Like the Hulk, the Abomination can use his superhumanly strong leg muscles to leap great distances, covering miles in a single bound. The Abomination has vast physical strength.", "abilities": "None", "weapons": "None", "paraphernalia": "None", "debut": "Tales to Astonish #90 (1967)", "origin": "Tales to Astonish #90 (1967)", "significant_issues": "", "main_image": "Acotilletta2--Abomination HD.jpg", "bio_text": "Formerly known as Emil Blonsky, a spy of Soviet Yugoslavian origin working for the KGB, the Abomination gained his powers after receiving a dose of gamma radiation similar to that which transformed Bruce Banner into the incredible [[Hulk (Bruce Banner)|Hulk]]. As a result he was permanently transformed into a massive green-skinned monster whose physical power was equivalent to, if not greater than, that of the Hulk. While he was able to maintain his normal level of self-control and intelligence after this transformation, he is unable to return to human form.", "bio": "Formerly known as Emil Blonsky, a spy of Soviet Yugoslavian origin working for the KGB, the Abomination gained his powers after receiving a dose of gamma radiation similar to that which transformed Bruce Banner into the incredible [[Hulk (Bruce Banner)|Hulk]]. As a result he was permanently transformed into a massive green-skinned monster whose physical power was equivalent to, if not greater than, that of the Hulk. While he was able to maintain his normal level of self-control and intelligence after this transformation, he is unable to return to human form.\n\nGiven his gamma-spawned origins, Blonsky blames his condition on Banner and his alter ego, the Hulk. The Abomination and the Hulk have clashed on numerous occasions, with Blonsky perpetually playing the role of the aggressor. Although Blonsky occasionally gains the upper hand in their battles, the Hulk manages to triumph in the end. But not always; the Abomination is one of the few who can lay claim to victory over the green-skinned goliath.\n\nIn recent years, it was revealed that his hideous new visage had served to alienate Blonsky from his ex-wife, Nadia. Coupled with constant defeats at the hands of the Hulk, this has driven Blonsky nearly insane in his hatred for Banner. The Abomination also grew incensed upon learning that Banner had married [[Ross-Banner, Betty|Betty Ross]], the daughter of [[Ross, Thaddeus|General \"Thunderbolt\" Ross]]. With the loss of his wife, Blonsky figured it is only fair to him that Banner should lose Betty. Out of jealousy, he caused the apparent death of Bruce Banner's wife Betty. While she was recovering from radiation sickness caused by exposure to the gamma radiation within Banner, he poisoned her with his radioactive blood, causing Banner and his associates to believe that her close proximity to the Hulk had given her a fatal case of radiation poisoning. Banner later exposed the Abomination's role in Betty's seeming death, and defeated him in combat.\n\nNot only had his grand scheme failed, but Banner also forgave Blonsky. The Abomination could not comprehend and endure his enemy's absolution, and his moment of triumph was twisted into crushing defeat. Blonsky realized he had become what he abhorred the most - it was he who was the rampaging, inhuman monster; not the Hulk as he had religiously believed all these years.\n\nMonths later, the still-grieving General Ross manipulated the Hulk into attacking and almost killing Blonsky. The Abomination was taken into custody by the military; as punishment, he was forced to watch a film loop of himself and his wife prior to his transformation, making his incarceration a constant reminder of what he has lost.\n\nRecently, the Abomination was among the first victims murdered at the hands of the [[Red Hulk]].", "categories": [ "Avengers", "Deceased", "Hulk", "International", "Villains" ] } } {code} Upon query submission, we'll convert the raw query to JSON (e.g. we'll JSONify it) and send it to the server. was (Author: vblagojevic): Use case scenario: Upon selecting "RW+Query" action item on the "Actions" cache menu (see ISPN-8759) a user should be taken to a page that should be similar to Google's BigQuery (see screenshots below). Query console screen should have two text areas: query area and results area. Query text area should allow users to write our queries as-is and response text area should be rendered in JSON or tabular view. Query area is editable and response area non-editable. There should be a switch between JSON/tabular view for response area. Between query and results text area that are stacked on top of each other, there should be a submit button for submitting queries to the server. For example: {code:title=JSON query example|borderStyle=solid} { query: select id,name from Character where name:"Abomination (Emil Blonsky)", max_results:2 } {code} {code:title=JSON query result|borderStyle=solid} { "id": 1009146, "name": "Abomination (Emil Blonsky)", "description": "Formerly known as Emil Blonsky, a spy of Soviet Yugoslavian origin working for the KGB, the Abomination gained his powers after receiving a dose of gamma radiation similar to that which transformed Bruce Banner into the incredible Hulk.", "modified": "2012-03-20T12:32:12-0400", "thumbnail": { "path": "http://i.annihil.us/u/prod/marvel/i/mg/9/50/4ce18691cbf04", "extension": "jpg" }, "resourceURI": "http://gateway.marvel.com/v1/public/characters/1009146", "comics": { "available": 43, "collectionURI": "http://gateway.marvel.com/v1/public/characters/1009146/comics", "items": [{ "id": 34050, "resourceURI": "http://gateway.marvel.com/v1/public/comics/34050", "name": "Incredible Hulks (2009) #619" }] }, "wiki": { "universe": "Marvel Universe", "real_name": "Emil Blonsky", "identity": "Secret", "occupation": "Professional Criminal, Former Spy", "place_of_birth": "Zagreb, Yugoslavia", "groups": "Ally of the [[Abominations]] and the Forgotten; Formerly partner of the [[Rhino]], crew of the starship Andromeda, agent of the [[Galaxy Master]], and [[MODOK]].", "citizenship": "Citizen of Croatia; former citizen of Yugoslavia", "education": "Unrevealed", "aliases": "Agent R-7, the Ravager of Worlds", "relatives": "Nadia Dornova Blonsky (wife, divorced)", "height": "(Abomination) 6'8\"; (Blonsky) 5'10\"", "weight": "(Abomination) 980 lbs.; (Blonsky) 180 lbs.", "eyes": "(Abomination) Green; (Blonsky) Blue", "hair": "(Abomination) None; (Blonsky) Blond", "powers": "Blonsky's transformation into the Abomination substantially increased his strength and durability. Like the Hulk, the Abomination can use his superhumanly strong leg muscles to leap great distances, covering miles in a single bound. The Abomination has vast physical strength.", "abilities": "None", "weapons": "None", "paraphernalia": "None", "debut": "Tales to Astonish #90 (1967)", "origin": "Tales to Astonish #90 (1967)", "significant_issues": "", "main_image": "Acotilletta2--Abomination HD.jpg", "bio_text": "Formerly known as Emil Blonsky, a spy of Soviet Yugoslavian origin working for the KGB, the Abomination gained his powers after receiving a dose of gamma radiation similar to that which transformed Bruce Banner into the incredible [[Hulk (Bruce Banner)|Hulk]]. As a result he was permanently transformed into a massive green-skinned monster whose physical power was equivalent to, if not greater than, that of the Hulk. While he was able to maintain his normal level of self-control and intelligence after this transformation, he is unable to return to human form.", "bio": "Formerly known as Emil Blonsky, a spy of Soviet Yugoslavian origin working for the KGB, the Abomination gained his powers after receiving a dose of gamma radiation similar to that which transformed Bruce Banner into the incredible [[Hulk (Bruce Banner)|Hulk]]. As a result he was permanently transformed into a massive green-skinned monster whose physical power was equivalent to, if not greater than, that of the Hulk. While he was able to maintain his normal level of self-control and intelligence after this transformation, he is unable to return to human form.\n\nGiven his gamma-spawned origins, Blonsky blames his condition on Banner and his alter ego, the Hulk. The Abomination and the Hulk have clashed on numerous occasions, with Blonsky perpetually playing the role of the aggressor. Although Blonsky occasionally gains the upper hand in their battles, the Hulk manages to triumph in the end. But not always; the Abomination is one of the few who can lay claim to victory over the green-skinned goliath.\n\nIn recent years, it was revealed that his hideous new visage had served to alienate Blonsky from his ex-wife, Nadia. Coupled with constant defeats at the hands of the Hulk, this has driven Blonsky nearly insane in his hatred for Banner. The Abomination also grew incensed upon learning that Banner had married [[Ross-Banner, Betty|Betty Ross]], the daughter of [[Ross, Thaddeus|General \"Thunderbolt\" Ross]]. With the loss of his wife, Blonsky figured it is only fair to him that Banner should lose Betty. Out of jealousy, he caused the apparent death of Bruce Banner's wife Betty. While she was recovering from radiation sickness caused by exposure to the gamma radiation within Banner, he poisoned her with his radioactive blood, causing Banner and his associates to believe that her close proximity to the Hulk had given her a fatal case of radiation poisoning. Banner later exposed the Abomination's role in Betty's seeming death, and defeated him in combat.\n\nNot only had his grand scheme failed, but Banner also forgave Blonsky. The Abomination could not comprehend and endure his enemy's absolution, and his moment of triumph was twisted into crushing defeat. Blonsky realized he had become what he abhorred the most - it was he who was the rampaging, inhuman monster; not the Hulk as he had religiously believed all these years.\n\nMonths later, the still-grieving General Ross manipulated the Hulk into attacking and almost killing Blonsky. The Abomination was taken into custody by the military; as punishment, he was forced to watch a film loop of himself and his wife prior to his transformation, making his incarceration a constant reminder of what he has lost.\n\nRecently, the Abomination was among the first victims murdered at the hands of the [[Red Hulk]].", "categories": [ "Avengers", "Deceased", "Hulk", "International", "Villains" ] } } {code} Upon query submission, we'll convert the raw query to JSON (e.g. we'll JSONify it) and send it to the server. -- This message was sent by Atlassian JIRA (v7.5.0#75005)