SBM JavaScript Get Field Value from another table

Mohammad Alsharayri 10 months ago

Hi!

I have a JavaScript that linked to Form1 and as you know the form has created based on Table1, so there is a JavaScript file linked to Form1 to handle some integration with a 3rd party database, now I need to get a field value from Table2 and use it in the JavaScript files that linked to Form1. Since the fields scope in Fom1 is coming from Table 1 , I have no clue if we can get a value from Table2 in this scenario.

Basically , I have a table called API settings , so in other forms Javascript files I wanna call the API Url , Name , Key ,etc. dynamically and I don't wanna harcode it for different environments deployment purposes.

Thanks!

Tags:

sbm composer

JavaScript

0 PM Thompson 10 months ago
Is Table1 an SBM primary table?

What type of table is Table2? Is it an SBM table?

Can you create an SBM Report or Report Filter that will return the data you want from Table2?

You can use the Javascript location object ("window.location") to return the current page's URL information. For example the information for this page as I'm entering this reply is:

host: "community.microfocus.com"
hostname: "community.microfocus.com"
href: "">community.microfocus.com/.../sbm-javascript-get-field-value-from-another-table"
origin: "">community.microfocus.com"
pathname: "/it_ops_mgt/sbm/f/discussions/525353/sbm-javascript-get-field-value-from-another-table"
port: ""
protocol: "https:"
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Mohammad Alsharayri 9 months ago in reply to PM Thompson

both tables are an SBM tables, how can I utilize creating a report to retrieve the data in my javascript file?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 PM Thompson 9 months ago in reply to Mohammad Alsharayri

See the SBM JSON API Guide. The functions "GetItemsByListingReport" and "GetItemsByReportFilter" can return report or filter results to JavaScript.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Mohammad Alsharayri 9 months ago in reply to PM Thompson

PM Thompson Thank you! I've never seen that guide before , I hope it is not hard to use it with my javascript integration
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Menu

SBM User Discussions

Verified Answers

SBM JavaScript Get Field Value from another table

Tags:

Resources