Name instead of ID

  • Resolved jhione

    (@jhione)


    3 years, 10 months ago

    Hello,

    Probably a newbie question. I searched this forum using the title of my post and received “No results”.

    I’m accessing a remote db and table and am creating a publication. I can retrieve company row date but my “state” and “country” come from related tables and instead of the names being pulled in I’m getting the related ID stored in the company table.

    I know I can programmatically retrieve this information but I can’t seem to figure out how to do that in the publication where only one table and the direct field names of the table are selectable. How do I reference the name instead of the id in the “fields” section of the publication builder? Or is it done elsewhere?

    Thank you for any assistance.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi @jhione,

    Not sure if I understand your question correctly, but it sounds like you want to join multiple tables in a query. Is that correct? If you are fimiliar with views, you can use the Query Builder to create a view for the query you need for your publication and use a view instead of a table.

    Does this help?
    Peter

    Thread Starter jhione

    (@jhione)

    Hi @peterschulznl
    Yes, I am looking to join multiple tables in a query.

    I will try the Query Builder to create a view and get back if I am having difficulty.

    Thank you for the quick response, it is appreciated.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Name instead of ID’ is closed to new replies.