I have a small query to run in my controller, it works fine in MySQL Workbench SELECT subprocess_id, MAX(CASE WHEN step_no = '1' THEN s_name END) AS first_step, MAX(CASE WHEN step_no = '2' THEN s_name END) AS second_step, MAX(CASE WHEN…
I'm attempting to retrieve information from a JSON, but the specific location of the information may vary. Here is an example of the data I have: id templatevalues 1 {"complexTypeProperties":[{"properties":{"Value":"NoDisruption","AttributeName":"Urgency"}},{"properties":{"Value":"SingleUser","AttributeName":"ImpactScope"}},{"properties":{"Value":"448928","AttributeName":"RegisteredForActualService"}},{"properties":{"Value":"10146","AttributeName":"Category"}},{"properties":{"Value":true,"AttributeName":"SkipEndUserAcceptance"}}]} 2 {"complexTypeProperties":[{"properties":{"AttributeName":"RegisteredForActualService"}},{"properties":{"Value":"SingleUser","AttributeName":"ImpactScope"}},{"properties":{"Value":"NoDisruption","AttributeName":"Urgency"}},{"properties":{"Value":"10154","AttributeName":"Category"}},{"properties":{"Value":"true","AttributeName":"SkipEndUserAcceptance"}}]} 3 {"complexTypeProperties":[{"properties":{"Value":"SingleUser","AttributeName":"ImpactScope"}},{"properties":{"Value":"NoDisruption","AttributeName":"Urgency"}},{"properties":{"Value":"721846","AttributeName":"RegisteredForActualService"}},{"properties":{"Value":"10146","AttributeName":"Category"}},{"properties":{"Value":"true","AttributeName":"SkipEndUserAcceptance"}}]} 4 {"complexTypeProperties":[{"properties":{"Value":"SingleUser","AttributeName":"ImpactScope"}},{"properties":{"Value":"SlightDisruption","AttributeName":"Urgency"}},{"properties":{"Value":"2854102","AttributeName":"RegisteredForActualService"}},{"properties":{"Value":"10153","AttributeName":"Category"}},{"properties":{"Value":"435331","AttributeName":"ServiceDeskGroup"}}]} 5 {"complexTypeProperties":[{"properties":{"Value":"NoDisruption","AttributeName":"Urgency"}},{"properties":{"Value":"SingleUser","AttributeName":"ImpactScope"}},{"properties":{"Value":"10146","AttributeName":"Category"}},{"properties":{"Value":"597224","AttributeName":"RegisteredForActualService"}},{"properties":{"Value":true,"AttributeName":"SkipEndUserAcceptance"}}]} 6 {"complexTypeProperties":[{"properties":{"Value":"NoDisruption","AttributeName":"Urgency"}},{"properties":{"Value":"SingleUser","AttributeName":"ImpactScope"}},{"properties":{"Value":"10146","AttributeName":"Category"}},{"properties":{"Value":"597224","AttributeName":"RegisteredForActualService"}},{"properties":{"Value":false,"AttributeName":"SkipEndUserAcceptance"}}]}…
I am trying to extract all words that start from 'M' character. For example I have a string: "[{"name": "Mary", "type": "Dog"}, {"name": "Max", "type": "Dog"}]" I want to get: "Mary, Max" I tried to regex_replace([{"name": "Mary", "type": "Dog"}, {"name":…
I would like to make a query similar to this: SELECT time, close - LAG(close) OVER (ORDER BY time) AS "diff" CASE WHEN diff > 0 THEN diff ELSE 0 END AS gain, CASE WHEN diff < 0 THEN diff…
I have a table Assets table Asset Id | Asset Name | Asset Type | Product Id Transfers Table Transfer Id | From Asset ID | To Asset Id | Product Id I'm trying to join these table to get…
Table 1 +--------+------------+-------+ | URI | Date | Name | +--------+------------+-------+ | Fred4 | 2023-04-05 | Fred | | Fred3 | 2023-04-01 | Fred | | Fred2 | 2023-03-15 | Fred | | Fred1 | 2023-03-06 | Fred | |…
I am trying to create simple trigger to ensure the "from" or "to" (database usernames) is equal to current_user, then can delete the record. But its always raises an exception. Table Schema: CREATE TABLE policy_test ( id serial not null,…
I have two tables and the data in table 1 is in rows. Key column in table 1 has the columns that are as rows now and want to trasnform to column Below is how i have the table now.…
I recently started to study SQL and I'm trying to solve the problem: I have a voting table db.votes, it records the nickname, time and type. Like an event log. It now has 500,000 lines. I need to record the…
I'm currently trying to extract latest visited domain information from a table that includes a visits history on my websites and information I want to retreive. Here is my table structure: CREATE TABLE `visit_record` ( `id` INT NOT NULL AUTO_INCREMENT,…