List Page / query

fauzi.mj · Post by **fauzi.mj** » Mon Mar 02, 2015 12:03 pm

Hi,

Appreciate if someone can help... How to list/show record on PO table based on query like below? and the text 'AKLEH' is from company on Table User.

SELECT *
FROM po
WHERE company LIKE 'AKLEH'

Table Setup is like this.

Table PO
PO_id
Name
Description
Company

Table User
UserID
UserName
UserLevel
Company

Thanks.

danielc · Post by **danielc** » Mon Mar 02, 2015 3:49 pm

fauzi.mj wrote:
WHERE company LIKE 'AKLEH'

Put your "where clause" into Table Filter. See Table Setup in help file about how to setup table filter.

Also read User_LoggedIn server event in "Server Events and Client Scripts" of the help file on how to save the Company of the user as session variable for use in the table filter.