Need An excel report file sample

[memethemyn]

I want to ask a question..

can we input a dynamic tag into the SQL query ?

For Example

SQL (General; select top(1) * from test6Info where referans='261112-1639')

and I want to change the query like this.

SQL (General; select top(1) * from test6Info where referans='Globals.tags.testrefnum.value')

Is it possible ?

Thanks Already..

Mehmet

[mark.monroe]

You can access a tag's value by referencing it like this:

Code: Select all

<#TAG(MyTag)>

I do not know the order Excel executes the code, so entering your tag name like above into the query string may or may not work.

[memethemyn]

Ok.. I will try this tomorrow..

I hope to work because there is two new project that I need this type report..

Thanks..

[memethemyn]

Dear Mark..

I tried to create a report and tried to use <#Tag(Mytag)> but it didnt worked

Here I send you the report files of my system..

In the first I use a constant value in sql and it worked very well

but in the second I used <#Tag(MyTag)> and I saw that Sql query didnt worked..

Please help..

[mark.monroe]

It that doesn't work, then there is no way to do what you want.

I suggest that you retrieve all the data from your table and use Excel's filtering option to filter your results.

[memethemyn]

Ok..

This was the end point of my project so I will engage in a little

Thank you for your helps everytime..

[memethemyn]

hi

I have a question..

Why doesnt the quey like

Code: Select all

SQL(General; Select * from DataLogger6Varyak where ReferansNumarası like '<#Tag(TestRefNum)>' )

works?

İf it possible it will be very useful to generate the reports..

We are doing most of Test systems by using IX. It is very useful but this problem is decelerating us.

I hope in the future this problem will be solved..

PS: We are generally using the filter option of excel but sometimes it wasn't enough.