Share
Report
140Hi All,
I am using On-Prem Business Central.
I am writing one query API to fetch item details from item table along the sales price from sales price list according to the product Id.
and there i need to call a procedure on the field in query column, but it shows it is not possible.
and there i need to call a procedure on the field in query column, but it shows it is not possible.
Below is my code :
query 50112 GetAllItemsDetails
{
QueryType = API;
APIPublisher = 'QueryV1';
APIGroup = 'QueryGroup';
EntityName = 'Item';
EntitySetName = 'Items';
elements
{
dataitem(ItemDetails; Item)
{
column(ItemNo; "No.")
{
}
column(Name; Description)
{
}
column(Inventory; Inventory)
{
}
column(PictureId; Picture)
{
}
column(Base_Unit_Price; "Unit Price")
{
}
column(Details; GetDetails()) // This i want to do. but not able to achieve.
{
}
{
QueryType = API;
APIPublisher = 'QueryV1';
APIGroup = 'QueryGroup';
EntityName = 'Item';
EntitySetName = 'Items';
elements
{
dataitem(ItemDetails; Item)
{
column(ItemNo; "No.")
{
}
column(Name; Description)
{
}
column(Inventory; Inventory)
{
}
column(PictureId; Picture)
{
}
column(Base_Unit_Price; "Unit Price")
{
}
column(Details; GetDetails()) // This i want to do. but not able to achieve.
{
}
dataitem(Price_List_Line; "Price List Line")
{
DataItemLink = "Asset No." = ItemDetails."No.";
SqlJoinType = LeftOuterJoin;
column(Unit_Price; "Unit Price")
{
}
}
}
}
{
DataItemLink = "Asset No." = ItemDetails."No.";
SqlJoinType = LeftOuterJoin;
column(Unit_Price; "Unit Price")
{
}
}
}
}
procedure GetDetails():Text
begin
// my logic
end
begin
// my logic
end
Does anyone have any idea about this. How we can achive this by Query API.
If anyone have any code snip please share.
If anyone have any code snip please share.
Thanks for your Help.
All responses (
Answers (
