Skip to Content
0
Dec 19, 2018 at 03:45 PM

FlexibleSearch mystic AND WHERE

220 Views

Can someone explain me following translatins from FlexibleSearch to SQL?

FlexibleSearch:

 SELECT {C.uid} from {Customer as C} where {C.uid} = 'anonymous'

SQL-Query (invalid):

 SELECT  item_t0.p_uid  FROM users item_t0 WHERE ( item_t0.p_uid  = 'anonymous') AND (item_t0.TypePkString=? )

SQL-Query (valid):

 SELECT  item_t0.p_uid  FROM users item_t0 WHERE ( item_t0.p_uid  = 'anonymous')

Where does following come from and why:

 ... AND (item_t0.TypePkString=? )