How to load data of grid with condition

Lien · Septembre 28, 2021, 10:26

I have a grid. I would like to filter data by the condition when the grid initialization.
Please help me. Thanks

siddique · Septembre 28, 2021, 10:49

context and model are filter friends

axelor/axelor-open-suite/blob/735e56d21bf4c3ba5190d6ef26f9c186be8fe2f3/axelor-sale/src/main/resources/views/Menu.xml#L52



	<action-view name="sc.root.sale.pack" title="Pack"
		model="com.axelor.apps.sale.db.Pack" >
		<view type="grid" name="pack-grid" />
		<view type="form" name="pack-form" />
	</action-view>
	
	<menuitem name="sc-root-sale-products" parent="sc-root-sale" order="15"
		title="Products &amp; services" action="sc.root.sale.products" />

	<action-view name="sc.root.sale.products" title="Products &amp; services"
		model="com.axelor.apps.base.db.Product" >
		<view type="cards" name="product-cards" />
		<view type="grid" name="product-grid" />
		<view type="form" name="product-form" />
		<view-param name="search-filters" value="products-filters"/>
		<domain>self.isModel = false AND self.sellable = true AND self.isShippingCostsProduct = false AND self.dtype = 'Product'</domain>
		<context name="_activeCompany" expr="eval:__user__.activeCompany"/>
		<context name="_fromSale" expr="eval:true" />
	</action-view>

Lien · Septembre 28, 2021, 11:22

Hi @siddique. Sorry, I don’t understand clearly.
Let’s say I have two models [A (id, model C), B (id, model C)] and they don’t have a direct relationship. but they are indirectly connected through model C (id, name).
In the view of model A, I want to display the view of model B with condition that A.model C.id = B.model C.id
How can I do that?
Please help me. Thanks.

siddique · Septembre 28, 2021, 6:08

I will share details later, but panel related can be used

fabiobottan · Septembre 29, 2021, 8:25

Hello @Lien
You can also use a custom report view.