0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for information security professionals

SELECT
  c.Id AS CommentId,
  c.PostId AS PostId,
  c.Text AS CommentText,
  c.CreationDate,
  p.Title AS PostTitle,
  p.Body AS PostBody,
  CASE
    WHEN c.Text LIKE '%completeness%' OR c.Text LIKE '%functionality%' OR c.Text LIKE '%accurate%'
         OR c.Text LIKE '%exact%' OR c.Text LIKE '%perfect%' OR c.Text LIKE '%precise%' OR c.Text LIKE '%proper%'
         OR c.Text LIKE '%exactness%' OR c.Text LIKE '%accuracy%' OR c.Text LIKE '%clarity%' OR c.Text LIKE '%correctness%'
         OR c.Text LIKE '%perfection%' OR c.Text LIKE '%nicety%' OR c.Text LIKE '%unnecessary steps%' OR c.Text LIKE '%fulness%'
         OR c.Text LIKE '%wholeness%' OR c.Text LIKE '%absoluteness%' THEN 'Functional Suitability'
    WHEN c.Text LIKE '%reliable%' OR c.Text LIKE '%fault tolerant%' OR c.Text LIKE '%recoverability%' OR c.Text LIKE '%availability%' THEN 'Reliability'
    WHEN c.Text LIKE '%response time%' OR c.Text LIKE '%responsiveness%' OR c.Text LIKE '%throughput%' OR c.Text LIKE '%latency%'
         OR c.Text LIKE '%scalability%' OR c.Text LIKE '%reaction time%' OR c.Text LIKE '%latency period%' OR c.Text LIKE '%time interval%'
         OR c.Text LIKE '%interval%' OR c.Text LIKE '%processing time%' OR c.Text LIKE '%battery%' OR c.Text LIKE '%battery drainage%'
         OR c.Text LIKE '%memory usage%' OR c.Text LIKE '%CPU cycle%' OR c.Text LIKE '%storage%' OR c.Text LIKE '%capacity%'
         OR c.Text LIKE '%communication bandwidth%' THEN 'Performance'
    WHEN c.Text LIKE '%user-friendly%' OR c.Text LIKE '%ease of use%' OR c.Text LIKE '%easy to understand%' OR c.Text LIKE '%accessible%'
         OR c.Text LIKE '%appealing%' OR c.Text LIKE '%aesthetical appealing%' OR c.Text LIKE '%guidelines%' OR c.Text LIKE '%instruction%'
         OR c.Text LIKE '%direction%' OR c.Text LIKE '%suggestion%' OR c.Text LIKE '%advice%' OR c.Text LIKE '%easy to remember steps%'
         OR c.Text LIKE '%controllability%' OR c.Text LIKE '%error protection%' OR c.Text LIKE '%ability%' OR c.Text LIKE '%secure%'
         OR c.Text LIKE '%correct%' OR c.Text LIKE '%use of color%' OR c.Text LIKE '%graphical design%' THEN 'Usability'
    WHEN c.Text LIKE '%immunity%' OR c.Text LIKE '%safety%' OR c.Text LIKE '%integrity%' OR c.Text LIKE '%accountability%' OR c.Text LIKE '%authenticating%' THEN 'Security'
    WHEN c.Text LIKE '%similarity%' OR c.Text LIKE '%agreement%' OR c.Text LIKE '%fellow feeling%' THEN 'Compatibility'
    WHEN c.Text LIKE '%screen fields%' OR c.Text LIKE '%tables%' OR c.Text LIKE '%transaction volumes%' OR c.Text LIKE '%report formats%'
         OR c.Text LIKE '%installed by an end user%' OR c.Text LIKE '%compactness%' OR c.Text LIKE '%convenience%' OR c.Text LIKE '%handiness%'
         OR c.Text LIKE '%lightness%' OR c.Text LIKE '%replaceability%' THEN 'Portability'
    WHEN c.Text LIKE '%friendly%' OR c.Text LIKE '%wonderful%' OR c.Text LIKE '%reliable%' OR c.Text LIKE '%delightful%' OR c.Text LIKE '%first-class%'
         OR c.Text LIKE '%first-rate%' OR c.Text LIKE '%super%' OR c.Text LIKE '%fantastic%' OR c.Text LIKE '%incredible%' OR c.Text LIKE '%heavenly%'
         OR c.Text LIKE '%fabulous%' OR c.Text LIKE '%fab%' OR c.Text LIKE '%fantabulous%' OR c.Text LIKE '%awesome%' OR c.Text LIKE '%mind-blowing%'
         OR c.Text LIKE '%sparkling%' OR c.Text LIKE '%brilliant%' OR c.Text LIKE '%capital%' OR c.Text LIKE '%champion%' OR c.Text LIKE '%extremely good%'
         OR c.Text LIKE '%contentment%' OR c.Text LIKE '%gratification%' OR c.Text LIKE '%fulfillment%' OR c.Text LIKE '%joy%' OR c.Text LIKE '%enjoyment%'
         OR c.Text LIKE '%functionality%' OR c.Text LIKE '%fitness%' OR c.Text LIKE '%adequacy%' OR c.Text LIKE '%neatness%' OR c.Text LIKE '%convenience%'
         OR c.Text LIKE '%utility%' OR c.Text LIKE '%use%' OR c.Text LIKE '%value%' OR c.Text LIKE '%worth%' OR c.Text LIKE '%merit%' OR c.Text LIKE '%success%'
         OR c.Text LIKE '%benefits%' OR c.Text LIKE '%advantages%' OR c.Text LIKE '%helpfulness%' OR c.Text LIKE '%good avail%' OR c.Text LIKE '%help%'
         OR c.Text LIKE '%assistance%' OR c.Text LIKE '%confident%' OR c.Text LIKE '%believe%' OR c.Text LIKE '%faith%' OR c.Text LIKE '%safe%' OR c.Text LIKE '%assurance%'
         OR c.Text LIKE '%reliance%' OR c.Text LIKE '%safekeeping%' OR c.Text LIKE '%protection%' OR c.Text LIKE '%care%' OR c.Text LIKE '%guardianship%'
         OR c.Text LIKE '%fulfillment%' OR c.Text LIKE '%relief%' OR c.Text LIKE '%trust%' OR c.Text LIKE '%secure%' OR c.Text LIKE '%quality%' THEN 'Satisfaction'
    WHEN c.Text LIKE '%waste%' OR c.Text LIKE '%miss%' OR c.Text LIKE '%problem%' OR c.Text LIKE '%wrong%' OR c.Text LIKE '%accuracy%'
         OR c.Text LIKE '%completeness%' OR c.Text LIKE '%precision%' OR c.Text LIKE '%exactness%' OR c.Text LIKE '%validity%' OR c.Text LIKE '%authority%'
         OR c.Text LIKE '%reliability%' OR c.Text LIKE '%perfection%' OR c.Text LIKE '%faithfulness%' OR c.Text LIKE '%closeness%' OR c.Text LIKE '%truth%'
         OR c.Text LIKE '%truthfulness%' OR c.Text LIKE '%authenticity%' OR c.Text LIKE '%realism%' OR c.Text LIKE '%fairness%' OR c.Text LIKE '%rigour%' THEN 'Effectiveness'
    WHEN c.Text LIKE '%defense%' OR c.Text LIKE '%shielding%' OR c.Text LIKE '%shelter%' OR c.Text LIKE '%preservation%' OR c.Text LIKE '%conservation%'
         OR c.Text LIKE '%safe keeping%' OR c.Text LIKE '%safeguard%' OR c.Text LIKE '%safety%' OR c.Text LIKE '%support%' OR c.Text LIKE '%providence%'
         OR c.Text LIKE '%dependability%' THEN 'Freedom of Risk'
    WHEN c.Text LIKE '%slow%' OR c.Text LIKE '%limit%' OR c.Text LIKE '%fast%' OR c.Text LIKE '%lock%' OR c.Text LIKE '%unhurried%'
         OR c.Text LIKE '%leisurely%' OR c.Text LIKE '%moderate%' OR c.Text LIKE '%deliberate%' OR c.Text LIKE '%steady%' OR c.Text LIKE '%slow moving%'
         OR c.Text LIKE '%time to complete a task%' THEN 'Efficiency'
    ELSE 'Other'
  END AS Aspect
FROM
  Comments c
INNER JOIN
  Posts p ON c.PostId = p.Id
WHERE
 p.Tags LIKE '%gwt%'
 AND p.CreationDate >= '2023-01-01'
  AND (
    c.Text LIKE '%completeness%' OR c.Text LIKE '%functionality%' OR c.Text LIKE '%accurate%'
    OR c.Text LIKE '%exact%' OR c.Text LIKE '%perfect%' OR c.Text LIKE '%precise%' OR c.Text LIKE '%proper%'
    OR c.Text LIKE '%exactness%' OR c.Text LIKE '%accuracy%' OR c.Text LIKE '%clarity%' OR c.Text LIKE '%correctness%'
    OR c.Text LIKE '%perfection%' OR c.Text LIKE '%nicety%' OR c.Text LIKE '%unnecessary steps%' OR c.Text LIKE '%fulness%'
    OR c.Text LIKE '%wholeness%' OR c.Text LIKE '%absoluteness%' OR c.Text LIKE '%reliable%' OR c.Text LIKE '%fault tolerant%'
    OR c.Text LIKE '%recoverability%' OR c.Text LIKE '%availability%' OR c.Text LIKE '%response time%' OR c.Text LIKE '%responsiveness%'
    OR c.Text LIKE '%throughput%' OR c.Text LIKE '%latency%' OR c.Text LIKE '%scalability%' OR c.Text LIKE '%reaction time%'
    OR c.Text LIKE '%latency period%' OR c.Text LIKE '%time interval%' OR c.Text LIKE '%interval%' OR c.Text LIKE '%processing time%'
    OR c.Text LIKE '%battery%' OR c.Text LIKE '%battery drainage%' OR c.Text LIKE '%memory usage%' OR c.Text LIKE '%CPU cycle%'
    OR c.Text LIKE '%storage%' OR c.Text LIKE '%capacity%' OR c.Text LIKE '%communication bandwidth%' OR c.Text LIKE '%user-friendly%'
    OR c.Text LIKE '%ease of use%' OR c.Text LIKE '%easy to understand%' OR c.Text LIKE '%accessible%' OR c.Text LIKE '%appealing%'
    OR c.Text LIKE '%aesthetical appealing%' OR c.Text LIKE '%guidelines%' OR c.Text LIKE '%instruction%' OR c.Text LIKE '%direction%'
    OR c.Text LIKE '%suggestion%' OR c.Text LIKE '%advice%' OR c.Text LIKE '%easy to remember steps%' OR c.Text LIKE '%controllability%'
    OR c.Text LIKE '%error protection%' OR c.Text LIKE '%ability%' OR c.Text LIKE '%secure%' OR c.Text LIKE '%correct%' OR c.Text LIKE '%use of color%'
    OR c.Text LIKE '%graphical design%' OR c.Text LIKE '%immunity%' OR c.Text LIKE '%safety%' OR c.Text LIKE '%integrity%' OR c.Text LIKE '%accountability%'
    OR c.Text LIKE '%authenticating%' OR c.Text LIKE '%similarity%' OR c.Text LIKE '%agreement%' OR c.Text LIKE '%fellow feeling%' OR c.Text LIKE '%screen fields%'
    OR c.Text LIKE '%tables%' OR c.Text LIKE '%transaction volumes%' OR c.Text LIKE '%report formats%' OR c.Text LIKE '%installed by an end user%'
    OR c.Text LIKE '%compactness%' OR c.Text LIKE '%convenience%' OR c.Text LIKE '%handiness%' OR c.Text LIKE '%lightness%' OR c.Text LIKE '%replaceability%'
    OR c.Text LIKE '%friendly%' OR c.Text LIKE '%wonderful%' OR c.Text LIKE '%reliable%' OR c.Text LIKE '%delightful%' OR c.Text LIKE '%first-class%'
    OR c.Text LIKE '%first-rate%' OR c.Text LIKE '%super%' OR c.Text LIKE '%fantastic%' OR c.Text LIKE '%incredible%' OR c.Text LIKE '%heavenly%'
    OR c.Text LIKE '%fabulous%' OR c.Text LIKE '%fab%' OR c.Text LIKE '%fantabulous%' OR c.Text LIKE '%awesome%' OR c.Text LIKE '%mind-blowing%'
    OR c.Text LIKE '%sparkling%' OR c.Text LIKE '%brilliant%' OR c.Text LIKE '%capital%' OR c.Text LIKE '%champion%' OR c.Text LIKE '%extremely good%'
    OR c.Text LIKE '%contentment%' OR c.Text LIKE '%gratification%' OR c.Text LIKE '%fulfillment%' OR c.Text LIKE '%joy%' OR c.Text LIKE '%enjoyment%'
    OR c.Text LIKE '%functionality%' OR c.Text LIKE '%fitness%' OR c.Text LIKE '%adequacy%' OR c.Text LIKE '%neatness%' OR c.Text LIKE '%convenience%'
    OR c.Text LIKE '%utility%' OR c.Text LIKE '%use%' OR c.Text LIKE '%value%' OR c.Text LIKE '%worth%' OR c.Text LIKE '%merit%' OR c.Text LIKE '%success%'
    OR c.Text LIKE '%benefits%' OR c.Text LIKE '%advantages%' OR c.Text LIKE '%helpfulness%' OR c.Text LIKE '%good avail%' OR c.Text LIKE '%help%'
    OR c.Text LIKE '%assistance%' OR c.Text LIKE '%confident%' OR c.Text LIKE '%believe%' OR c.Text LIKE '%faith%' OR c.Text LIKE '%safe%'
    OR c.Text LIKE '%assurance%' OR c.Text LIKE '%reliance%' OR c.Text LIKE '%safekeeping%' OR c.Text LIKE '%protection%' OR c.Text LIKE '%care%'
    OR c.Text LIKE '%guardianship%' OR c.Text LIKE '%fulfillment%' OR c.Text LIKE '%relief%' OR c.Text LIKE '%trust%' OR c.Text LIKE '%secure%'
    OR c.Text LIKE '%quality%' OR c.Text LIKE '%waste%' OR c.Text LIKE '%miss%' OR c.Text LIKE '%problem%' OR c.Text LIKE '%wrong%' OR c.Text LIKE '%accuracy%'
    OR c.Text LIKE '%completeness%' OR c.Text LIKE '%precision%' OR c.Text LIKE '%exactness%' OR c.Text LIKE '%validity%' OR c.Text LIKE '%authority%'
    OR c.Text LIKE '%reliability%' OR c.Text LIKE '%perfection%' OR c.Text LIKE '%faithfulness%' OR c.Text LIKE '%closeness%' OR c.Text LIKE '%truth%'
    OR c.Text LIKE '%truthfulness%' OR c.Text LIKE '%authenticity%' OR c.Text LIKE '%realism%' OR c.Text LIKE '%fairness%' OR c.Text LIKE '%rigour%'
    OR c.Text LIKE '%defense%' OR c.Text LIKE '%shielding%' OR c.Text LIKE '%shelter%' OR c.Text LIKE '%preservation%' OR c.Text LIKE '%conservation%'
    OR c.Text LIKE '%safe keeping%' OR c.Text LIKE '%safeguard%' OR c.Text LIKE '%safety%' OR c.Text LIKE '%support%' OR c.Text LIKE '%providence%'
    OR c.Text LIKE '%dependability%' OR c.Text LIKE '%slow%' OR c.Text LIKE '%limit%' OR c.Text LIKE '%fast%' OR c.Text LIKE '%lock%' OR c.Text LIKE '%unhurried%'
    OR c.Text LIKE '%leisurely%' OR c.Text LIKE '%moderate%' OR c.Text LIKE '%deliberate%' OR c.Text LIKE '%steady%' OR c.Text LIKE '%slow moving%'
    OR c.Text LIKE '%time to complete a task%'
  )
ORDER BY
  c.CreationDate DESC;

fork query

edited feb 14 24 anonymous

created feb 11 24 jon.doe43791