Forum Discussion

Sergey's avatar
Sergey
Icon for OneStream Employee rankOneStream Employee
4 years ago

join statement in SQL command type data adapter/grid view

Hi all,   EDIT : I was able to sort this out with some more SQL 🙂 I wanted to confirm one point regarding data adapter using SQL statement. Right now, I am using a data adapter with SQL command ...
Dashboards
Sergey's avatar
Sergey
Icon for OneStream Employee rankOneStream Employee
4 years ago

Hi,

It was actually due to the column order : since I am using a data adapter, then in the grid view all columns details specifications should follow the same order of columns as in the data adapter, otherwise I wasn't able to get all columns as output.

 

Regards,

ckattookaran's avatar
ckattookaran
VIP
4 years ago

That's interesting. You can have different order in grid view.

  • Sergey's avatar
    Sergey
    Icon for OneStream Employee rankOneStream Employee
    4 years ago

    Correct, that was weird indeed. Could have been a setting that was hiding new columns as well, I'm just glad it has been solved ðŸ˜€