Hi all
I need to be guided on how i can retrieve information from the database using 
API. Specifically, is there a way i can get the same output using API of the 
following queries?
Query1:
SELECT organisationunitid FROM usermembership WHERE userinfoid IN 
                                                                                
                                (SELECT userid FROM users WHERE 
username='$username')
                                                                                
                                ORDER BY organisationunitid ASC


Query2:
SELECT organisationunitid FROM usermembership
                                                                                
                                WHERE userinfoid IN 
                                                                                
                                (SELECT userinfoid FROM userinfo WHERE 
                                                                                
                                phonenumber='$number' OR phonenumber='$number2')
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Reply via email to