Skip to main content ↑ ↓
Topic: List View and multiple value in a field (Read 1519 times) previous topic - next topic

List View and multiple value in a field

Dear Sirs,

Suppose I've this table called POSTS:

POST_ID,
POST_TITLE,
POST_REGION

And this table called REGIONS:

REGION_ID,
REGION_NAME

I want to put multiple REGION_ID in the POST_REGION field separated by commas.
If I put value 1,2,3 in the POST_REGION field I see different results in the LIST PAGE and the VIEW PAGE.
In the view page I'm able to see something like this
  • REGION A,
  • REGION B,
  • REGION C, selected.
In the list page I only obtain REGION A using JOIN, but I completely lost information abount REGION B, and REGION C.

Have you any suggestion about this ?
Thank you in advance.
Gio

Re: List View and multiple value in a field

Reply #1 –
Someone?
Thank you.

Re: List View and multiple value in a field

Reply #2 –
@gioco‍ make to configure multiselect for the field, then use the page event, after view and after list to query the names of the list using the ID stored on the field. 

Re: List View and multiple value in a field

Reply #3 –
I was Unable to find this.
Can u please send me a screen shot or path?
 

Re: List View and multiple value in a field

Reply #4 –
Anyone?
Thank you in advance.
Gio