Question

Forms Feature for lookup with "Value not equal" and "Like"

Forms Version 10 Ideas How To

Updated November 29, 2018

asked on November 19, 2018 • Show version history

I have not yet been able to create a Lookup on a form that implements this feature where we could specify that a field value will not equal a value in the database.

This is easy to do in SQL and easy to do in Workflow but Form don't seem to support this.

The only way I've seen is to create a Stored Procedure but, sometimes this doesn't work as, many of my customers do use System ODBC to non-MSSQL databases.

Will Laserfiche improve Forms lookup interface to start supporting this?

Is there other workarounds to this?

0 0

Replies

replied on November 29, 2018 • Show version history

Sorry, things have been busy with Thanksgiving and upcoming releases. We can add a feature request to support a custom query for a lookup.

We are also looking into supporting stored procedures using an ODBC system.

1 0

replied on November 22, 2018

A feedback from Laserfiche would be nice.

Can Laserfiche offer some sort of Custom Query interface option, when we need to design more complex integration?

0 0

You are not allowed to follow up in this post.

Question

Question

Forms Feature for lookup with "Value not equal" and "Like"

Replies

Sign in to reply to this post.