How to add the things in the case statement

My query is below select date(created_at), count(distinct updated = ‘3’ then user_id end) as unique, count(distinct updated <> ‘3’ then user_id end) as duplicate1, count(distinct updated_by <> ‘4’ then user_id end) as duplicate2 from user where date(created_at) between current_date-2 and current_date group by date(created_at) I need one more column saying TOTAL duplicates which is the…

Details

how to retrieve only field(field name ) as list array from FireStore in android?

I want to retrieve field as List Array from Firestore in this Horror field is “map” I want to retrieve all field in HINDI document as Array as shown in the image public class HindiStory extends AppCompatActivity { private static final String TAG = “HindiStory”; List<String> list; FirebaseFirestore db = FirebaseFirestore.getInstance(); private DocumentReference hindiStoryref =…

Details

isDepthDataDeliverySupported return false on Ipad pro 2018

I am trying to use PortraitEffectsMatte using iPad Pro 2018 which has a depth camera. The sample code from Apple’s documentation: https://developer.apple.com/documentation/avfoundation/cameras_and_media_capture/avcam_building_a_camera_app works fine on IphoneX but not on iPad although both have true depth cameras. How to make it work with iPad Pro 2018? Any ideas? Following code is from the same link photoOutput.isLivePhotoCaptureEnabled…

Details

Converting multilevel json to a dataframe using pysprk

My input JSON file is { “Name”: “Test”, “Mobile”: 12345678, “Boolean”: true, “Pets”: [“Dog”, “cat”], “Address”: { “Permanent address”: “USA”, “current Address”: “AU” } } The requirement is to convert the above multi-level JSON to dataframe using pyspark. I tried using the code path_to_input = “/FileStore/tables/sample_json_file2-6c20f.json” df = spark.read.json(sc.wholeTextFiles(path_to_input).values()) df.show() I got the output as…

Details

SWIFTUI TABVIEW MORE TAB

So I created a tabview in SwiftUI but it keeps showing the ‘three dots more’ tab. How do I remove that? TabView{ Text(“”) .tabItem { Image(systemName: “house”) Text(“Home”) } Text(“”) .tabItem { Image(systemName: “magnifyingglass”) Text(“Search”) } Text(“”) .tabItem { Image(systemName: “plus”) Text(“Add”) } Text(“”) .tabItem { Image(systemName: “suit.heart”) Text(“Likes”) } Text(“”) .tabItem { Image(systemName: “person”)…

Details