Questions tagged [json-value]
The json-value tag has no usage guidance.
json-value
81
questions
0
votes
0
answers
10
views
MySQL JSON_VALUE fails with a path starting with a number? [duplicate]
SELECT JSON_VALUE('{"dateTime": "2024-07-21 08:11:07 -0600", "60SecInches": 0.00, "DailyInches": 0.01, "TotalInches": 10.61}', "$.60SecInches&...
- 129
0
votes
0
answers
44
views
SQL Json_value alternative in GraphQL with Hot Chocolate
I have a table with a string column that is formatted as json. I want to query my table by json. This is achievable with SQL
SELECT *
FROM [db].[dbo].[table]
WHERE JSON_VALUE(ColName, '$.jsonkey')...
0
votes
1
answer
296
views
"com.fasterxml.jackson.databind.exc.InvalidDefinitionException: Cannot construct instance of" error even though constructor exists
I have this Java enum:
public enum UserTypeEnum implements EnumConverter {
USER(1),
USERS_GROUP(2);
private final int type;
UserTypeEnum(int type) {
this.type= type;
}
@Override
@JsonValue
...
- 31
0
votes
0
answers
83
views
JSON_VALUE function is not working as expected in Cloud Spanner query, it is returning incorrect values from nested data blocks, how do I fix it?
JSON_VALUE function is not working as expected in my Query in Google Cloud Spanner.
Interestingly, it is selecting the wrong value instead of returning a blank value, but only in certain scenarios.
In ...
- 1
1
vote
1
answer
168
views
Typescript JSON type not working properly (recursive type definition problem?)
I created a legit JSONValue type with some recursive logic. I've tried everything and read a lot of documentation, still don't understand why this not works as expected (the compiler doesn't complain ...
- 422
0
votes
1
answer
86
views
Parsing a complex JSON GET CALL USING ORACLE JSON_TABLE
I have a following GET call response.
{
"PrepaymentIncludedonInvoiceFlag": null,
"ReferenceKeyTwo": null,
"ProductTable": null,
"links": [
{
&...
0
votes
3
answers
113
views
How to build JSON with selected fields from JSON columns in SQL Server keeping fields type
I have JSON like this:
{
"_key": {
"id": "3b8d1ed7-c3ec-32ec-a083-2ddc17152e94",
"rootId": "15c85327-9628-3685-b84a-375b546ba92a"
},
...
- 2,876
0
votes
2
answers
334
views
How to build new JSON with JSON_VALUE in SQL Server? Can't set value type
I have JSON like this:
{
"_key": {
"id": "3b8d1ed7-c3ec-32ec-a083-2ddc17152e94",
"rootId": "15c85327-9628-3685-b84a-375b546ba92a",
},
&...
- 2,876
0
votes
2
answers
130
views
Equivalent of the $[*] jsonpath for SQL Server?
I would like to use a JSON path like $[*].name or $[..].name on a JSON like this one:
[
{"id": 1, "name": "John"},
{"id": 2, "name": "...
- 339
0
votes
2
answers
65
views
JSON query returns data until I search for it
I have a table (code_table) with a lot of different types of records and values. One of the type of records contains a json field (but not all). The following returns the records with json fields:
...
- 1,354
0
votes
0
answers
87
views
How to remove a property name of a JSON with @JsonValue without deleting more properties of my object
I try to make a JSON with a 3 propertys, "items", "status" and "id", but if i use @JsonValue, my JSON don't take "status" and "id"; How can i make ...
0
votes
1
answer
675
views
Extract first value from a JSON dictionary in SQL Server
I have various translations stored in a JSON dictionary. I extract the values with JSON_VALUE (for that example I use a variable instead of a column. In real life it is a nvarchar(max) table column):
...
- 3
0
votes
3
answers
2k
views
How to fetch nested data using JSON_VALUE when it contains an array of objects
I have a table MYTABLE which has 3 columns as mentioned below.
|id | myclob_column | column3|
It has one column (myclob_column) which is clob data (json). Sample clob data is below.
{
"name"...
- 714
1
vote
2
answers
674
views
Extract value from a JSON array with no name
I have a table with a record that has JSON content and it is an array with no name. Sample data looks like this:
carId
carType
parts
Z003
Company
[{"Value":"New","Type":...
- 1,324
0
votes
1
answer
260
views
Fetching object multiple levels in JSON array using JSON_QUERY in MariaDB do not work
I have the following table in a mariadb database
| model_id | model_name |model_json |
then on the field model_json I have the following json
{"class":"GraphLinksModel",
"...
