Hi!
Good day all,
The data being dumped to this "Test Structure" is from an sql query and that image column is related to 1 of my entities.Now i can get the Name column correctly but the image column doesnt get that data that i wanted. (KA_Logo)The value from the Image column from my sql is an Identifier for the said entity.Use case:Instead of using the normal aggregate, i use advance sql to query my data dynamically and "IN" cluase doesnt work for aggregates.
On my scenario, As given, name is equals to a name and Image is the image uploaded on my other entity.any workarounds for this?
All good now from my end. I have it fixed already. Thanks for the assistance.My query has been rebuild this waySELECT e.name, u.ImageFROM {EmployeeID} eLEFT JOIN {UserInformation} uON e.name = u.CSONameWHERE e.name in (@safelist) The image now is showing base on the entity {UserInformation}
Hi Kert P,
I guess the query which you are executing in the advance SQL may be incorrect i.e joins etc.
So is it possible to share the SQL here.
Hi @Kert P ,
If you don’t mind, could you share the OML file or the SQL query you’re using? That way, we can take a closer look and better understand what might be causing the issue.
The SQL is pretty short, atm. havent encountered with this before
SELECT name,Image From {EmployeeID} Where name in (@safelist)
I think the JOIN from @Rajan C might be the answer as this Image list from my previous screenshot is from a database named UserInformationIll try the join@Mihai Melencu as long as i want to, i cant share the oml due to company compliance, Il ltry to use the JOIN as mention by Rajan, remembered Aggregates use this on related databases
Can you provide the attributes of your entities so we can help you build the necessary SQL?