Various data in a single cell (grid) GeneXus 15 for WEB

Question

Various data in a single cell (grid) GeneXus 15 for WEB

Navigation

#1 by (0 votes)

1

Good day for everyone, I have a grid made in GeneXus 15 with JAVA.

The tables involved are the following:

La Grilla (Table) I am filling it with the table "contactoempresa (Base table of the grid) but the emails are in the canalcontacto table and I would like to show them in the grid.

I also attach my grid.

My intention is that my grid is like this or something similar.

Thanks for the attention I'll be waiting for your answers.

Greetings.

genexus

asked by Angel Cayhualla 27.03.2018 в 22:59

source

1 answer

FATAL EXCEPTION: main java.lang.IndexOutOfBoundsException: 6, 1 in TextView (?) convert file content to array

score 0 · Accepted Answer

Now that you have provided us with the structure, what you should do is the following:

Your base table is contact company

For Each
    Order idContacto
    &emails = NullValue(&emails)  //  Se basea la variable que concatenará los correos
    For Each  //  Join hacia la tabla canalcontacto
        Order idContacto
        &emails += contactoemail + NewLine()
    EndFor

    Load  //  Load del Grid
EndFor

What happens is the following:

Parts of the base table to obtain the contact data.
You make a Join to the canalcontacto table, in which the variable & email will be loaded with the emails followed by a NewLine () for the line break.
Load of the Grid

This should be done in the Load event, if you have a single grid in the web form, just:

Event Load
    //  Tu codigo
EndEvent

If you have several grids:

Event TuGrid.load
    //  Tu codigo
EndEvent

And in the end, so that the emails come out to you vertically, in the properties of the variable & email (in the web form) you will have to put Autoresize: True .

I hope you will be helped, greetings.