Hi ALl,
Tried create a query to get Item attributes shown as columns. Some items do not have attributes assigned so the query shoud still return these items. However DataItemTableFilter acts as SQL where clause. Is there any other way to get this in a Query work as a left join or do I have to create a page?
query 50121 TestItemAttribute
{
elements
{
dataitem(Item; Item)
{
column(No_; "No.")
{
}
column(Description; Description)
{
}
dataitem(ItemAttributeValueMapping9; "Item Attribute Value Mapping")
{
DataItemLink = "No." = Item."No.";
SqlJoinType = LeftOuterJoin;
DataItemTableFilter = "Table ID" = const(27), "Item Attribute ID" = const(9);
column(ItemAttributeValueID; "Item Attribute Value ID")
{
}
dataitem(AttributeValue; "Item Attribute Value")
{
DataItemLink = ID = ItemAttributeValuemapping9."Item Attribute Value ID";
SqlJoinType = LeftOuterJoin;
column(Value; Value)
{
Caption = '9';
}
}
}
}
}
}
