DB Get JR ProfileURL from UserID
Jamroom Developers
Hi - Actually our API is coded in NodeJS, so we need to work with straight standard SQL. For integration coding, we have found it most productive if we are able to query our data directly at the DB level.
--
It looks like the two tables we need are:
jr_jrprofile_item_key - we found "profile_url" is stored here - Now just need to link JR UserID to JR ProfileID...
jr_jroneall_link - the "data" column of this table may work...
Also Maybe table: jr_jrprofile_profile_link
Does "data" column of "jr_jroneall_link" table store JR ProfileID?
Or do we need to use : jr_jrprofile_profile_link ?
--
Basicallly from the
@michael code above, we now have found the - profile_url - field.
--
We just need the simplest standard SQL, method, and tables involved to return "profile_url" from table jr_jrprofile_item_key , by querying using the JR UserID.
What would that standard SQL look like?
updated by @softdesigns: 05/15/18 04:12:10PM