I have two tables, and I want to use a value from primary table (here: person.ref) to extract some data from a json field in a secondary table (here: person_details): create table person ( id int(8), ref varchar(20), primary key…
My tables: questions id: serial content: text tags id: serial name: text questions_tags question_id integer tag_id integer I need to select all questions with tag 'css', but don't remove all other tags from JSON from jsonb_agg(). I have this SQL…
In a Laravel project I have to store some data in json. For phpUnit tests I use a factory with faker. I try to fake a json structure for the tests, but it always fail on validation. Is there any…
The output of the db.name.aggregate() function gives output: [{}, {"abc": "zyx"}, {}, "opk": "tyr"] Actual output desired : [{"abc": "zyx"}, "opk": "tyr"]
Need to create new array object from two other arrays in JS var array1 = ['one', 'two', 'one, 'two']; var array2 = ['3', '4', '5', '6']; Here array1[0] = one represents array2[0] = 3 and vice versa. Need to create…
I have a database having columns id and profile fields where profile fields is of the type jsonb id profile_fields 101 {"1":"Chess" , "2":"08-02-2001"} 102 {"1":"Hockey" , "2":"1996-06-09"} In profile fields the key 2 stands for Date of Birth .…
In a aws_ssoadmin_permission_set_inline_policy ressource, i'm using a for_each to parse a list of name corresponding to my data source name. It doesn't work when using the each.key but wokring when hard coding the value inline_policy = data.aws_iam_policy_document.emobg-sso-billing-admin.json data "aws_iam_policy_document" "emobg-sso-billing-admin"…
I have a json string. Like this: "{"http_requests":[{"http_requests":{"code":"400","method":"PUT","value":89}},{"http_requests":{"code":"200","method":"PUT","value":45}}]}" I want to insert this json to mongodb. But I have error in my code. The error is "cannot transform type string to a BSON Document: WriteString can only write while positioned…
I have a table A and in it I have a column of type json that receives an array of dates. I need to fetch all female records from table A. I need to return a specific date from each…
I'm trying to get Tradingview signals to my remote php script using webhook and trading view alerts. I can't succeed . I'm following this way In my trading view strategy I have this strategy.entry("Long", strategy.long, alert_message = "entry_long") strategy.exit("Exit Long",…