only display with mysql condition

I just bought this software tonite. Everything seems to be working.

I see the the advance condition which is not apply to database query...It makes me worry. 'cause I only advance condition apply to database to display certain information base on my sql condition.

Hi Vincent,

what kind of advanced condition did you apply?

If this is id=@user_id and you are using e.g. Oracle DB, then you must provide table or view in Oracle DB with column id (copy of joomla column id in jos_users table).

If something else please let me know...

Best regards,
Viljem

it is something else...

for instance...in my database table, i have following "status" column, i want only display "open" status for my database table with this condition apply.

E.G.:

In mssql I have table Customers (see demo page). I want to filter ContactTitle (the name from DB) only Owners.

WHERE ContactTitle = 'Owner'

When I look on frontend I see only Customers that have ContactTitle equal to Owner.


Which DB are you using?

it is external database that I use to display for trading record.

Yes, above example uses external db, in fact MS-SQL.

What is the type of the Status field?