Fetching data from database in web portal using new Angular based web portal

Question

Hi, we are having trouble understanding how data is retrieved from the database in frontend. We are struggling to find examples of actual api calling methods, instead what we find are variables like data, datasource, entitySchema etc. without any pointers to what kind of data/variables they hold. As an example we want to include a dropdown with employment organisation, but we can&rsquo;t seem to figure out how to fetch this data. Even though this data is already fetched in the frontend in the form of item. Could you provide us with a code example of how to fetch/extract this or any other data? We are customising the existing modules to fit our needs. 
 Example of the issue: 
 
 We are using version 9.1 and the new Angular based web portal . 
 Regards 
 Anders Westby

Niels de Groot · Accepted Answer

Hello Juan Carlos, 
 About your question: Some columns are FK to another table. In our case, we want to show accounts (gapuser) and other data (primaryemail, is inactive, etc..) with their corresponding license (gapuseringapasku) in the same dst. 
 What is your exact use-case for this? Because from my technical perspective dynamically displaying entities with correct data type combined from two or more entity types doesn't seem let say easily possible/practical. 
 As example (away from Angular) if you try to do this by scripting on the Entitylayer you can use a join to identify the data to load. But a collection always loads entities of one specific type. So if the Entitylayer doesn't provide this it would be logical to think that it's also not possible in the Angular project. 
 Maybe this use-case is more suitable implemented as a sql view used in a report. I didn't want to leave you hanging, so I gave it my best shot ;-) Niels

Fetching data from database in web portal using new Angular based web portal

Top Replies