Technical FAQs

Ask a Question

Can we apply a new filter to the result being dispayed from the previously applied filter in Database Exchange Control which is getting data from SQL server in Vijeo Citect.

To implement such filter you have to modify your query and insert multiple filter in the same query. You cannot apply a new SQL query filter on the previous result filtered out from previous SQL query.

For you better clarification you will have to modify the Query as per below:

SELECT *
FROM CCF
WHERE (((CCF.[Plant]) Like 'UOP') AND ((CCF.[Tag No]) Like 'AC1-TIC-1'));

//To filter from the table CCF where Plant is UOP and Tag NO is AC1-TIC-1.
 
Was this helpful?
What can we do to improve the information ?