Quickbooks/QBFC 8.0 - 相同请求过滤器类型的多个标准
我想通过匹配名字和姓氏来查询员工。 理想情况下,我希望能够在一个 EmployeeQueryRq QBFC 对象中指定这一点。
我想我已经开始了:
Dim EmployeeQueryRq As IEmployeeQuery
EmployeeQueryRq = requestMsgSet.AppendEmployeeQueryRq()
EmployeeQueryRq.ORListQuery.ListFilter.ORNameFilter.NameFilter.MatchCriterion.SetValue(ENMatchCriterion.mcContains)
EmployeeQueryRq.ORListQuery.ListFilter.ORNameFilter.NameFilter.Name.SetValue(LastName)
有什么方法可以向同一请求添加额外的 NameFilter 吗? 或者我是否被困在其他标准的响应列表中(尽管较小的一个仅限于包含至少一个值)?
I would like to query an Employee by matching First and Last name. Ideally, I'd like to be able to specify that in one EmployeeQueryRq QBFC object.
I think I have a start:
Dim EmployeeQueryRq As IEmployeeQuery
EmployeeQueryRq = requestMsgSet.AppendEmployeeQueryRq()
EmployeeQueryRq.ORListQuery.ListFilter.ORNameFilter.NameFilter.MatchCriterion.SetValue(ENMatchCriterion.mcContains)
EmployeeQueryRq.ORListQuery.ListFilter.ORNameFilter.NameFilter.Name.SetValue(LastName)
Is there any way I can add an additional NameFilter to the same request? Or am I stuck walking a response list for the other criteria (albeit a smaller one limited to containing at least one value)?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
似乎员工是按全名搜索的(直接使用全名搜索与直接使用全名搜索之间的区别在于,这将允许以或包含开头),因此如果您以正确的顺序连接名字和姓氏(不幸的是顺序没有记录,但它应该与全名匹配,但这需要测试来确认)您应该进行名字和姓氏搜索。 您实际上不能做的是名或姓氏搜索。 不幸的是,这似乎不可用。
It seems that employee is searched by the full name (the difference between directly using a fullname search and this is that this will allow a starts with or a contains) so if you concatenate the first and last name in the right order (unfortunately the order is not documented but it should match the full name, but that would require testing to confirm) you should get a first and last name search. What you can't really do is a first or last name search. Unfortunately that doesn't seem to be available.