Thunderstone Support Forums

We have an application that uses the soap search api with the parametric search appliance. We allow users to sort on some of the parametric fields. Is there a way to specify in the soap search request that we want the results sorted case-insensitive?

Thanks!

We tried with postgres 9.2 and 10. We have tried several tests, the latest test table is this:
people
(
lname character varying(20) NOT NULL,
fname character varying(20),
myid integer
)

The key-field specified in DB Walker is the myid field.

FYI - If I make a view that has all these fields from the table but casts the myid field to varchar, then I can point DBWalker to the view instead of the table and use myid as the key. I can also include additional numeric fields and it will read them. I just can't seem to use a numeric field as the key in a dbwalker setup with postgres. I've tried numeric, smallint, integer, and bigint types.

Hi, We are connecting dbWalker to a postgres table. We are getting an Internal Server Error during the walk. When we click on "Test" in dbwalker, it shows our key field values listed, but clicking on any of them gives this error:

com.thunderstone.DBWalker.ConfigurationException: SQL Error: java.sql.SQLException: ERROR: operator does not exist: bigint = character varying

Any ideas? Thanks!

--Britton Powers

Thank you!

I have a parametric field that is defined as a SET. How can I make a query to include only pages where that field is not empty (without regard for what the specific values are)?

Thank you! I appreciate the quick and detailed response.

We have a profile that has an associated DB Walker that reads a table in an external Oracle database. The walk takes over an hour to complete. The table has a primary key. Is there a way to issue a command to re-walk just one row (referencing the primary key)? Sometimes we have a change in the data in just one single row and would like to have the change reflected in the Thunderstone profile more quickly than a full walk, if possible. Thanks!

Is there any way to put more than 10 group by's on a profile?

We are using the SOAP api to get search results. If there are more than one page of matches, the Pages section of the results has PageLink elements for additional pages. How can we submit those values using the api to get another page of results? I wasn't sure which parameter to put the PageLink value into in the successive api call.

Thank you so much!