Dynamic view tables

PHPMaker General Discussion (PHPMaker)
1

When i creating a view table, one element of my SQL query needs to be dynamic. example ==> f.user_id = CurrentUserInfo(‘id’) . is this possible?

SELECT 
    k.kitap_adi, 
    k.yazar1, 
    k.yayinevi, 
    f.eklenme_tarihi
FROM 
    favori_kitaplar f
JOIN 
    kitaplar k ON f.kitap_id = k.id
WHERE 
    f.user_id = CurrentUserInfo('id')
ORDER BY 
    f.eklenme_tarihi DESC;
2

CurrentUserInfo() is PHP, you cannot put it in your SQL directly. However, you may create a view without the WHERE clause, then add a Table Filter to the view.