Question: I have a db with records like the following structure in the table;

```
 id,msg,date,fid 
 19 ,"start","2012-02",NULL
 20 ,"end","2012-03",19
 21 , "start",2012-04,NULL

```

I have and entire db set up like this where the fid in some cases matches the id of another record. Id like to return all records that have matching start and end dates and just the start date if it doesn't have a corresponding end date fid like below: 

```
19 ,"start","2012-02","end","2012-03"
21 , "start,"2012-04,"",NULL

```

Answer: 
your problem can be resolved just follow these steps:
To jetify / convert node\_modules dependencies to AndroidX
Imagine you have a react-native project. One of your library dependencies converts to AndroidX., and you need to use the new version.

So now you need to convert your app to AndroidX, but many of your react-native libraries ship native Java code and have not updated. How is this done?

First, use Android Studio's refactoring tool to convert your app re: the Android developer docs
npm install --save-dev jetifier
npx jetify
npx react-native run-android (your app should correctly compile and work)
Call npx jetify run in the postinstall target of your package.json (Any time your dependencies update you have to jetify again

you can follow this link as well: <https://www.npmjs.com/package/jetifier>

feel free for any confusion.
The error is due to the version of JDK or JDK not installed.

i think you need to solve in the section:

open the androind folder with android studio

then file-> project structure -> SDK location
and in here you can change, in my case i change the version
[![enter image description here](https://i.stack.imgur.com/4fAeL.jpg)](https://i.stack.imgur.com/4fAeL.jpg)

before that, for to know what was the error:

i realized what is the problem with this command

```
npx @react-native-community/cli doctor

```

i got these errors:
[![enter image description here](https://i.stack.imgur.com/ja5FY.png)](https://i.stack.imgur.com/ja5FY.png)