This site uses cookies and similar technologies.

If you don't change browser settings, you agree to it.

I understand
225 Posts
Giuse
1 month ago
4
Topic

Hi, I need to put a message in the Search Form, not just a fixed text but something that includes some data from the DB.

So I created a new text field and put the text and the retrieval of values from DB in the live value with SQL query.

It works but.. after the user press the button "Search" of the form, the value of this field (the message that is displayed) ends up in the URL of the page like a normal field to be searched: the problem is that if the message contains some characters like quotes ("), this confuses Seblod that cannot interpret correctly the query (it takes part of the message with initial quotes like it was another search field).

How is it possible to avoid this? Is it possible to define a dynamic text field in the search form that does not finish in the URL or to protect the query URL from this problem?

thanks

Giuse

Get a Book for SEBLOD
4218 Posts
Kadministrator
1 month ago
1
Level 1

Hi, how did you set storage for this field? Probably storage None would be the right one. 

4218 Posts
Kadministrator
1 month ago
0
Level 2

Otherwise in the SQL pack there is a SQL field (not live vlaue field..real field), you can use this one to display a vaue from db https://www.seblod.com/resources/extensions/plug-ins/sql-pack

225 Posts
Giuse
1 month ago
1
Level 1

Hi Klas and thanks. The storage was already None (and match is None) but this does not prevent the field to end up in the URL.

The SQL query field works in the List View (for the returned results), here I am looking for the Search Form where this field is not executed from my understanding and tests.

cheers

Giuse

225 Posts
Giuse
1 month ago
0
Level 2

Hi Klas, do you have any further feedback on this?

thanks a lot

best regards

Giuse

Get a Book for SEBLOD