AutoSearch Question

rbuser

I've designed a custom AutoSearch dialog that allows my user to add
a search field from the AutoSearch dialog. I want to be able to include
all fields as in the Query Designer, but I'm not sure how to retrieve the
entire list of fields. Does anyone know how retrieve the fields?

nicocizik

Hi Charley,

Try using the DBPipeline.GetFieldNames routine to get the names of each
field in your dataset. If you need to get a hold of the actual field, you
can perhaps use the GetFieldForName method.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

If all of the fields were selected for the Query, DBPipeline.GetFieldNames
would work
just fine, but DBPipeLine.GetFieldNames will only return the fields that
have been
selected for the Query and not all of the available fields in the table.

I did find a way to retrieve these fields by using
DBPipeline.DataView.SQL.AvailableFields.
This gets me all of the fields, but I expected these fields to contain the
Searchable, Sortable,
Mandatory, and Selectable values that are stored in the EndUser fields
table, but such was not
the case. Also in the Query designer I can select fields for the criteria
that are flagged as not
searchable in the EndUser fields table.

nicocizik

Hi Charley,

Sorry, I did not know you were interested in getting all the fields in the
table. You should be able to use the DataDictionary to get ahold of all of
these fields with their properties set correctly. See the ReportBuilder
help for the TppDataDictionary for more information.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com