255
Views
3
Comments
Solved
Fetching and display data from database
Question
Application Type
Reactive

Hello Experts,

I am displaying a list from the database where you can click on a name, so a new window will pop up. This list contains names. What I want to show is, when I click on a name the specific name needs to show up in this new window. I cant figure out how to fetch this information from the database. I dont want to show the full list from the database, just one single name. The name on the new window must be determined by the name i click on. This must be completed for a school project. 

Regards,

Jack IT student

2021-06-02 20-50-04
Márcio Carvalho
Solution

To do that or I pass the id of the record that you clicked or the name. And on clicking the screen that pop-ups, it will get by input parameter the name or the id where it can consult all data for that id again :)

It would be better that you could share an OML

ps: if you are using the popup widget, you need to pass the record on the client action that you clicked and then that record that is saved in a variable it will be used on the popup. if is a block it will be inserted in the input of the block.

Kind Regards,

Márcio

2018-10-18 08-34-00
Eric Bulters
 
MVP
Solution

Hi Jack,

Márcio's approach is solid.
Just to clarify, if you go the route of passing the id:
On your new window you'll have an aggregate with a filter that filters on that id (or use the getTableName(id) function)

However if you really only need the name and are not doing anything with that name or record in the new window besides showing it, then as Marcio said just pass the name

2021-06-02 20-50-04
Márcio Carvalho
Solution

To do that or I pass the id of the record that you clicked or the name. And on clicking the screen that pop-ups, it will get by input parameter the name or the id where it can consult all data for that id again :)

It would be better that you could share an OML

ps: if you are using the popup widget, you need to pass the record on the client action that you clicked and then that record that is saved in a variable it will be used on the popup. if is a block it will be inserted in the input of the block.

Kind Regards,

Márcio

2018-10-18 08-34-00
Eric Bulters
 
MVP
Solution

Hi Jack,

Márcio's approach is solid.
Just to clarify, if you go the route of passing the id:
On your new window you'll have an aggregate with a filter that filters on that id (or use the getTableName(id) function)

However if you really only need the name and are not doing anything with that name or record in the new window besides showing it, then as Marcio said just pass the name

UserImage.jpg
Jack van Dijkhuizen

Thank you Márcio and Eric! I have solved my problem! I wish you a merry christmas!

Kind Regards,

Jack

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.