on 02-25-2014 2:37 PM
Hi,
I have tag query with 100 columns like datetime and rest all with different tag names.
Like DateTime, Tag1, Tag2...........Tag100.
Query returns all tag values in one row. Now I want to get tag name and value for each tag and store it in oracle.
If I use repeater on rowset/row of tag query, I have to map 100 parameters to insert query to store tag values and I won't get tag names here.
So please how do I get tag name and tag value from tag query in trx to map those to insert sql query ,Since I am maintaining these two as columns in oracle table.
Please guide me to resolve it.
Regards,
Rakesh.
You can repeat on the Columns to get the names.
Repeater XPath: Document_0.Output{/Rowsets/Rowset/Columns/Column}
Link editor to get column name XPath: Repeater_0.Output{/Column/@Name} or
Repeater_0.Item{/Column/@Name} depending on your version
Then in the same loop get the columns value.
Link editor to get column value XPath:
Document_0.Output{/Rowsets/Rowset/Row[1]/*[#Repeater_0.CurrentItem#]}
Regards,
Christian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Christian,
Thanks for your answer.
I am getting column name and values on repeater.
But I want skip the first column which is DateTime. I dont want this column to be repeated .
So to do this I have given xpath as Pcoquery.Results{/Rowsets/Rowset/Columns/Column[@Name!='DateTime']}
But it is not working.
Can you pls guid me how to skip the column on repeater.
Regards,
Rakesh.
User | Count |
---|---|
13 | |
6 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.