Project

General

Profile

Feature #5805

TypeAHead SQL value instead of key stored

Added by Nicola Chiapolini over 2 years ago. Updated 8 months ago.

Status:
Some day maybe
Priority:
Normal
Assignee:
-
Target version:
Start date:
10.04.2018
Due date:
% Done:

0%

Estimated time:
Discuss:

Description

Ich habe ein Textfeld mit folgenden Parametern:


typeAheadSql = SELECT shortname AS 'id', CONCAT(firstname, ' ', lastname, ', ', shortname) AS 'value' FROM _right_to_confer_phd WHERE lastname LIKE ? OR firstname LIKE ? or shortname LIKE ? ORDER BY lastname
typeAheadSqlPrefetch = SELECT CONCAT(firstname, ' ', lastname, ', ', shortname) AS value FROM _right_to_confer_phd WHERE shortname=?
typeAheadMinLength = 1
typeAheadLimit = 20
typeAheadPedantic = 0

Die Suche funktioniert, aber beim Speichern wird der Value (firstname lastname, shortname) statt der id (shortname) gespeichert.
Problem scheint, dass JS im hidden Feld den Value statt der id einfügt...


Related issues

Related to QFQ - Bug #5444: typeahead: Nach einem Save wird der key angezeigt statt dem ValueSome day maybe2018-02-14

History

#1 Updated by Nicola Chiapolini over 2 years ago

Scheint typeAheadPedantic = 1 löst das Problem

Evtl. könnte das in der Dokumentation besser erklärt werden...

#2 Updated by Nicola Chiapolini over 2 years ago

  • Status changed from New to Ready to sync (develop)

#3 Updated by Carsten Rose over 2 years ago

  • Status changed from Ready to sync (develop) to In Progress
  • Target version set to next

In Doku besser beschreiben

#4 Updated by Carsten Rose over 2 years ago

  • Related to Bug #5444: typeahead: Nach einem Save wird der key angezeigt statt dem Value added

#5 Updated by Carsten Rose almost 2 years ago

  • Tracker changed from Support to Feature

#6 Updated by Carsten Rose almost 2 years ago

  • Status changed from In Progress to New

#7 Updated by Carsten Rose 9 months ago

  • Status changed from New to Some day maybe

#8 Updated by Carsten Rose 8 months ago

  • Target version changed from next to next4

Also available in: Atom PDF