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.
Juggernaut

Set Portal to certain rec?

Featured Replies

  • Newbies

Hello-

Is there a script or something that i can use to set a portal to retrieve all rows of a DB based on a critria? For example, the SQL would look ike this:

SELECT Speaker, Quantity, Cost FROM JobInfo WHERE OrderID="Current records OrderID"

I am not running an ODBC source on my computer, otherwise i would probably just write the SQL for it.

When i am in the "order" DB it works fine, but what i am hoping to acomplish is when i look up a contact,(in the conatcts DB) i can pull all the PO's that they have on file with us, click on a PO number, and it takes me to another screen where it shows the details of that specific PO, all without switching databases.

I can go to the related record in the Order DB, and it pulls all the info from there just fine, but when i try to do the same thing in the Contacts DB, it lists all the lines from each PO, even though it tells me that i am on one specific PO.

So i would like to force the Portal to only view records from that specific PO.

Does this maka da sense?

Create an account or sign in to comment

Important Information

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

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.