248 Posts
Giuse
5 years ago
2
Topic

Hi, the availability check in the validation offers a "Fields" parameter to type additional fields that can restrict the query of availability of the value so that the value is searched adding WHERE clause with the additional fields compared to the values of current form.

I have seen (undocumented feature in the user manual) that multiple fields can be entered if separated by "||" (double pipe) but... it seem not to work: the validation just throws a Error 500 Server Error.

Is it a bug or this need a different syntax for multiple fields (belonging to the table btw)?
Thanks

Giuse

Get a Book for SEBLOD
4229 Posts
Kadministrator
5 years ago
1
Level 1

Hi,

not sure whether that is related, but there is an error in this part of the field, try replacing in the _where function lines 170-171 as $s_field is undefined in the else part of the if clause

if ( isset( $fields[$w] ) && $fields[$w]->storage == 'standard' && $fields[$w]->storage_table == $table ) {
   $v    =  $values[$w]->value;

with

if ( isset( $fields[$w] ) && $fields[$w]->storage == 'standard' && $fields[$w]->storage_table == $table ) {
   $s_field    =  $fields[$w]->storage_field;
   $v    =  $values[$w]->value;
248 Posts
Giuse
5 years ago
0
Level 2

Thanks, tTried to make this fix but it's not working anyway.

Opened issue https://github.com/Octopoos/SEBLOD/issues/522

Get a Book for SEBLOD