Hi,
I was wondering, if someone could help me out on this. I am trying to use this to get a list of projects in a customised person tracker. I have looked at the object explorer and I just can't get the syntax right. In object explorer and sort of example on page 220 of the user guide it indicates that a hash table is required. But I am guessing on this .
This is latest attempt but it returns the full dataset. The tracing log indicates that whereclause parameter is being passed through, the pagesize and absolutesize is pulling through a default from the method, I think.
Dim Personhashtable as System.Collections.Hashtable = New System.collections.Hashtable()
Dim ProjectLeadwc as string = "ShortChar02 = 'ChrisD'"
Dim Pagesize as integer = 0
Dim absolutepage as integer = 1
Personhashtable.add("WhereClause",ProjectLeadwc)
PersonHashTable.Add("PageSize",Pagesize)
PersonHashTable.add("absolutepage",Absolutepage)
Dim ProjectAdapter As ProjectAdapter = New ProjectAdapter(PersonForm)
ProjectAdapter.BOConnect()
Dim MorePages As Boolean
Dim opts As SearchOptions = New SearchOptions(SearchMode.AutoSearch)
"
opts.NamedSearch.WhereClauses.Add("ProjectListDataSet",PersonHashTable)
Dim Projectds As Data.DataSet = ProjectAdapter.GetList(opts,MorePages)
Thanks in advance
I was wondering, if someone could help me out on this. I am trying to use this to get a list of projects in a customised person tracker. I have looked at the object explorer and I just can't get the syntax right. In object explorer and sort of example on page 220 of the user guide it indicates that a hash table is required. But I am guessing on this .
This is latest attempt but it returns the full dataset. The tracing log indicates that whereclause parameter is being passed through, the pagesize and absolutesize is pulling through a default from the method, I think.
Dim Personhashtable as System.Collections.Hashtable = New System.collections.Hashtable()
Dim ProjectLeadwc as string = "ShortChar02 = 'ChrisD'"
Dim Pagesize as integer = 0
Dim absolutepage as integer = 1
Personhashtable.add("WhereClause",ProjectLeadwc)
PersonHashTable.Add("PageSize",Pagesize)
PersonHashTable.add("absolutepage",Absolutepage)
Dim ProjectAdapter As ProjectAdapter = New ProjectAdapter(PersonForm)
ProjectAdapter.BOConnect()
Dim MorePages As Boolean
Dim opts As SearchOptions = New SearchOptions(SearchMode.AutoSearch)
"
opts.NamedSearch.WhereClauses.Add("ProjectListDataSet",PersonHashTable)
Dim Projectds As Data.DataSet = ProjectAdapter.GetList(opts,MorePages)
Thanks in advance