Hi Guys
On Query object -I'm struggling with a left join from Item table to attributes table. Some items don't have all the attributes and these items are not displayed since the DataItemTableFilter acts as a where clause. Is there anyway get all items including items without attributes. Sample code:
dataitem(ItemAttributeValueMapping; "Item Attribute Value Mapping")
{
DataItemLink = "No." = Item."No.";
SqlJoinType = LeftOuterJoin;
DataItemTableFilter = "Table ID" = const(27), "Item Attribute ID" = const(12);
Converted to SQL what I really want is something like:
Left Join No = Item.No and Table ID = 27 and Attribute ID = 12
So all items are displayed. I'm wondering if BC queries are advanced enough to handle this or we have develop pages with variables etc
