Skip to main content
Solved

List of Matrix Items linked to Template Item


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

Looking for a Generic Inquiry to get the List of Matrix Items associated to Template Items.

 

Best answer by Naveen Boga

Hi @manikantad18 I have created a simple SQL View and then created a GI for the same.

I have tested it and seems working well. Please import the below GI into your instance and verify.

 

drop view IF EXISTS NBTemplateItemsWithoutMatrix
GO
create view NBTemplateItemsWithoutMatrix
as
Select CompanyID,  InventoryID, InventoryCD, Descr from Inventoryitem where CompanyID=2 and istemplate=1 and InventoryID not in( Select TemplateItemID from InventoryItem Where CompanyID=2 and TemplateItemID is not null)

 

Hope this helps!!

View original
Did this topic help you find an answer to your question?

2 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • Answer
  • October 10, 2023

Hi @manikantad18 I have created a simple SQL View and then created a GI for the same.

I have tested it and seems working well. Please import the below GI into your instance and verify.

 

drop view IF EXISTS NBTemplateItemsWithoutMatrix
GO
create view NBTemplateItemsWithoutMatrix
as
Select CompanyID,  InventoryID, InventoryCD, Descr from Inventoryitem where CompanyID=2 and istemplate=1 and InventoryID not in( Select TemplateItemID from InventoryItem Where CompanyID=2 and TemplateItemID is not null)

 

Hope this helps!!


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

Hi @Naveen Boga 

Thank you for the Quick Help, Really helpful for me.

 

It is working Perfectly.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings