Discussions
Activity
Best Of...
Sign In
·
Register
Home
›
NAV Three Tier
Howdy, Stranger!
It looks like you're new here. Sign in or register to get started.
Sign In
Register
Quick Links
Categories
Recent Discussions
Activity
Best Of...
Unanswered
Categories
All Categories
73
General
73
Announcements
66.6K
Microsoft Dynamics NAV
18.7K
NAV Three Tier
38.4K
NAV/Navision Classic Client
3.6K
Navision Attain
2.4K
Navision Financials
115
Navision DOS
854
Navision e-Commerce
1K
NAV Tips & Tricks
772
NAV Dutch speaking only
615
NAV Courses, Exams & Certification
2K
Microsoft Dynamics-Other
1.5K
Dynamics AX
310
Dynamics CRM
110
Dynamics GP
10
Dynamics SL
1.5K
Other
993
SQL General
384
SQL Performance
34
SQL Tips & Tricks
34
Design Patterns (General & Best Practices)
Architectural Patterns
10
Design Patterns
5
Implementation Patterns
53
3rd Party Products, Services & Events
1.7K
General
1.1K
General Chat
1.6K
Website
79
Testing
1.2K
Download section
23
How Tos section
260
Feedback
12
NAV TechDays 2013 Sessions
13
NAV TechDays 2012 Sessions
the method readmultiple
sbilly
Member
Posts:
231
2011-05-30
edited 2011-05-30
in
NAV Three Tier
Hi all ;
I am working with webservice,
I want to ask if I can create a filter with two criteria based on two fields for the method readmultiple.
thanks
0
Comments
ufuk
Member
Posts:
514
2011-05-30
Here is an example which includes ItemNo and VariantCode filters:
ItemVariant itemVariant = new ItemVariant();
ItemVariant_Binding itemVariantBind = new ItemVariant_Binding();
NAVConn.PrepVrntBinding(ref itemVariantBind);
List<ItemVariant_Filter> filterArray = new List<ItemVariant_Filter>();
ItemVariant_Filter itemFilter = new ItemVariant_Filter();
ItemVariant_Filter variantFilter = new ItemVariant_Filter();
itemFilter.Field = ItemVariant_Fields.Item_No;
itemFilter.Criteria = itemNo;
filterArray.Add(itemFilter);
if (variantCode != null)
{
variantFilter.Field = ItemVariant_Fields.Code;
variantFilter.Criteria = variantCode;
filterArray.Add(variantFilter);
}
return itemVariantBind.ReadMultiple(filterArray.ToArray(), null, 0);
Ufuk Asci
Pargesoft
0
sbilly
Member
Posts:
231
2011-05-30
Thaaaaaaaaaaaaaaaaaaaaaanks very much
0
Sign In
or
Register
to comment.
Comments
ItemVariant itemVariant = new ItemVariant();
ItemVariant_Binding itemVariantBind = new ItemVariant_Binding();
NAVConn.PrepVrntBinding(ref itemVariantBind);
List<ItemVariant_Filter> filterArray = new List<ItemVariant_Filter>();
ItemVariant_Filter itemFilter = new ItemVariant_Filter();
ItemVariant_Filter variantFilter = new ItemVariant_Filter();
itemFilter.Field = ItemVariant_Fields.Item_No;
itemFilter.Criteria = itemNo;
filterArray.Add(itemFilter);
if (variantCode != null)
{
variantFilter.Field = ItemVariant_Fields.Code;
variantFilter.Criteria = variantCode;
filterArray.Add(variantFilter);
}
return itemVariantBind.ReadMultiple(filterArray.ToArray(), null, 0);
Pargesoft