check your mail thank you
Hi Thanks for responding But i already did it in the last 2 imgs and have an error implementing interface
It's a composite key Did you mean i must delete it from route ?? If i delete it it still have an unused route with Culture Id
i hope i can explain my big problem hi sir, i am trying to do update method in a composite key class here is my steps with some attachment: hope you can help me 1- created class (createUpdateDto) 2- put my key into it 3- create an interface 4- create service 5- create controller (i know abp gives me auto controller but i should do it because i have more than module)
i faced problem when trying to update in swagger (error 400) The value '{documentStatusId}' is not valid for DocumentStatusId. i cached the problem in routing he says unused route parameter like image below so i fixed it inject int documentStatuesId and string cultureId and error is gone but interface says i must generate method exactly right my interface see picture and you will understand me thank
i already did it and all is good
hi sir, i have a big problem now i made a query and used jsTree to make tree view and it works good but it works for just one level what i mean is one parent has 2 child what if one of these child is parent for another child what should i do? i want to make a view like image 1 and this is my query which is working good but just for one level of parent like image 2 is ABP support this feature and has a documentation link to do that or not??
ALTER PROCEDURE [dbo].[GetAccountTreeStructure2] AS BEGIN SET NOCOUNT ON;
WITH RecursiveCTE AS (
-- Anchor member: Select root nodes (accounts with no parent)
SELECT
A.Id,
A.AccountName AS ChildName,
A.ParentAccountId,
A.AccountLevelId,
AL.AccountLevelTitle AS ParentName,
0 AS Level
FROM
Acc_Account A
INNER JOIN
Acc_AccountLevel AL ON A.AccountLevelId = AL.Id
WHERE
A.ParentAccountId IS NULL
UNION ALL
-- Recursive member: Select child nodes recursively
SELECT
A.Id,
A.AccountName AS ChildName,
A.ParentAccountId,
A.AccountLevelId,
AL.AccountLevelTitle AS ParentName,
Level + 1 AS Level
FROM
Acc_Account A
INNER JOIN
Acc_AccountLevel AL ON A.AccountLevelId = AL.Id
INNER JOIN
RecursiveCTE R ON A.ParentAccountId = R.Id
)
-- Final query to retrieve the tree structure with account and level information
SELECT
Id,
ChildName,
ParentAccountId,
AccountLevelId,
ParentName,
Level -- Include the Level column to display the level of each node
FROM
RecursiveCTE;
END;
hi no , no errors when build
thanks sir it works