Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Need help with portal and value list

bodadea
in Portals

Featured Replies

  • Newbies

In the attached file, a project can have multiple machines and a machine can have multiple issues. I am using issues portal on project layout to collect machine issues data. But in project layout i can not select particular machine from machine list (or from machine list for a particular product). Any recommendation on relationship between project, machine and issues list table is appreciated.

test.zip

a machine can have multiple issues.

That's not what your file shows: there is no relationship between Machine and IssueList. The basic relationship should be:

Projects -< Machines -< Issues

In order to view only Issues of a selected machine (from the point-of-view of Projects), you could filter the portal to Issues, or construct an auxiliary relationship between Projects and another occurrence of Issues.

Note that ProjectID has no place in the Issues table. An issue belongs to a machine. The parent project of the machine is ipso facto the grandparent of its issues.

  • Author
  • Newbies

Thanks for the quick response. I have attached modified file with project-<Machine-<IssueList relationship. I think my explanation was not sufficient in previous post. Sorry about that. Here is the situation.

Company A has two machines (MACHINE X and MACHINE Y) in project # 80. I have inserted a issue list portal in Project layout so that I can log issues encountered on MACHINE X and MACHINE Y during this project phase. Final goal is to capture all issues for all project by machineID and customer information.

But in issue list portal, I can see only machine X. I am trying to figure out why MACHINE Y is not shown in issue list portal.

Thanks again... Any help to look into it is highly appreciated.

IssuesList.zip

I am trying to figure out why MACHINE Y is not shown in issue list portal.

There is no MACHINE Y in your file.

--

BTW, it's excellent that you have chosen to use a test file for this - but if it's supposed to be a test file, let's make it suitable for testing.

test2.zip

There is no MACHINE Y in your file.

--

BTW, it's excellent that you have chosen to use a test file for this - but if it's supposed to be a test file, let's make it suitable for testing.

Actually there is a Machine Y; record 2 in the Machine table. But MachineID is set up as a number field.

  • Author
  • Newbies

Thanks a lot for the help.

Create an account or sign in to comment

https://fmforums.com/topic/77411-need-help-with-portal-and-value-list/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.