Can I query a 'Foreign ID' and list rows based on that query?

SOLVE
Highlighted
Regular Contributor

Hello : )

So, I'm working with a database full of courses (each row). One of the COLs I'm using is the course instructor which I made a 'Foreign ID' as the COL type. I was successful in listing (with filters) row to specific categories yesterday. But when I try to filter a COL with the 'Foreign ID' type, I'm getting a blank page.

Here are three itterations - the first one works and uses a 'selector' (id=session_category) COL type:

{% for row in hubdb_table_rows(2033946, 'session_category=3') %}

The second one is pointing to a 'foreign id' (id=select_speaker_associated) and does not work:

{% for row in hubdb_table_rows(2033946, 'select_speaker_associated=3') %}

I aslo tried the literal value instead (which is the course instructor's name):

{% for row in hubdb_table_rows(2033946, 'select_speaker_associated=Ira Bedenbaugh') %}


I was able to swap out the HTML/HUBL on this page with working HTML/HUBL and narrowed the bug down to this line. Does anyone have experience in listing Foreign ID's and if so, I would greatly appreciate any/all help. Thank you in advance.

Reply
0 Upvotes
1 Accepted solution

Accepted Solutions
Highlighted
Advisor | Elite Partner

Try replacing spaces with a + in your filter, like so:

 

{% for row in hubdb_table_rows(2033946, 'select_speaker_associated=Ira+Bedenbaugh') %}

Alyssa Wilie

Web Developer at LyntonWeb

If this answer solved your question, please mark it as the solution!

3 Replies 3
Highlighted
Advisor | Elite Partner

Try replacing spaces with a + in your filter, like so:

 

{% for row in hubdb_table_rows(2033946, 'select_speaker_associated=Ira+Bedenbaugh') %}

Alyssa Wilie

Web Developer at LyntonWeb

If this answer solved your question, please mark it as the solution!

Highlighted
Regular Contributor

Alyssa!!!! You are a God-send with fantastic shoes (can not verify but will still argue this point) and you totally rock! Thank you thank you thank you!

I think if I were more proficient in back end code I'd have caught that? My experience in PHP and Hubl is limited. Can you do me one more favor? Please have a fantastic weekend!!!

Valid depiction of me right now but no tieValid depiction of me right now but no tie

Highlighted
Advisor | Elite Partner

Even those with tons of experience can miss the littlest things. A pair of fresh eyes is always helpful.

You also have a fantastic weekend!!
steve-thumbs-up.gif


Alyssa Wilie

Web Developer at LyntonWeb

If this answer solved your question, please mark it as the solution!