I have a jpql as: @Query("SELECT b FROM Booking b WHERE " + "(:officeId is null OR b.officeId = :officeId) AND " + "(:status is null OR b.status = :status) AND " + "(:type is null OR b.officeType = :type)…
I am trying to remove the Parenthesis and its contents after a comma for an Employee Name Field. I cant seem to get the syntax right to remove special characters and numbers AFTER the first comma. Then i would like…
I have a users table, with the primary key being an id field, which is an autoincrementing integer. I don't have a username field right now, but I would like to add one. Now, the username should be UNIQUE and…
there is a table where some data is populated and have to get single data for every key value Fk| field1 | field2 ==================== 1|r |lo 2 |abcd |mem 3 |efghi |mem 4 |abcd |mem 5 |efghi |mem Trying to…
$myDate = date('m-d-Y 00:00:00', strtotime($myDate)); if($debugs)echo"<br>myDate is: $myDate in line: ".__line__."<br>"; $mysqlstart = date('Y-m-d 00:00:00', strtotime($myDate)); if($debugs)echo"<br>mysqlstart is: $mysqlstart in line: ".__line__."<br>"; From the code above, I would like to show $myDate to the audience while passing $mysqlstart into a…
I have a variable which contains a single JSON object like declare @jsonVar nvarchar(max) = N'{"key1":"value1","key2":"value2"}'; I need to convert it to XML and get something like this (or without 'root' at all) <root> <key1>value1</key1> <key2>value2</key2> </root> The solution should…
I have 2 table CREATE TABLE json_data_table(d_id int, d1_json json, d2_json json); CREATE TABLE user_data(uid int, username varchar); and data respectively are INSERT INTO user_data VALUES (1,'test_user_1'), (2,'test_user_2'), (3,'test_user_3'); INSERT INTO json_data_table VALUES (1,'{"stage1":1,"stage2":2 }', '{ "stage1": { "date": "12-01-2023",…
Like in below if my target_sum is 5 it should return id 1 8 then it should return id 1 and 2 13 then it should return id 1, 2 and 3 Basically my query should return the next possible…
I'm new to using postgresql and looking for some help on how translate these vars usage in MySql to Postgres it looks like postgres doesn't support this type of syntax. I do not want to use recursion because max_depth is…
I have two tables - employees and departments. The employees table has the following columns: emp_id, salary, dep_id. The departments table has the following: dep_id, department_name, manager. Now, I am trying to get the employee_ids of the employees who have…