Features
Support
Purchase
Documentation
Download
Login
Register
Login
Register
Home
»
LogViewPlus Support
»
Help & Support
»
Can't use SQL Filter on Custom Parser column
Can't use SQL Filter on Custom Parser column
Post Reply
Like
3
Can't use SQL Filter on Custom Parser column
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
DavidL
DavidL
posted Last Year
ANSWER
Topic Details
Share Topic
Group: Forum Members
Posts: 6,
Visits: 26
I created a Custom Parser for my log file and it seems to work well, except when I try to add a SQL filter. It never returns any results if I try to use a custom column in the WHERE clause. The custom column does show up in the "Available Columns" tab when I'm editing the filter, but when I click on the "Execution Result" tab, I get a warning that says, "No data found for field '<CustomFieldName>'". The "Test" button tells me that the SQL statemen parsed correctly.
What am I missing?
Tags
Custom Parser
SQL Filter
Reply
Like
3
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
Can't use SQL Filter on Custom Parser column
DavidL
-
Last Year
Hi David, Thanks for bringing this issue to our attention. I have...
LogViewPlus Support
-
Last Year
Thanks for getting back! I tried with all of the custom string fields...
DavidL
-
Last Year
Sorry, I realized that I didn't answer your question directly. No,...
DavidL
-
Last Year
Thanks for the update. LogViewPlus attempts to resolve data types...
LogViewPlus Support
-
Last Year
That's an interesting thought. I do have somewhat of a mix of data...
DavidL
-
Last Year
I rewrote the parser to remove any "optional" fields and ensured that...
DavidL
-
Last Year
Glad to hear the behaviour is looking better. LogViewPlus doesn't...
LogViewPlus Support
-
Last Year
That makes sense. The problem I was trying to solve is that there's a...
DavidL
-
Last Year
No problem David - glad that helped! Please do let me know if you have...
LogViewPlus Support
-
Last Year
Post Reply
Like
3
Similar Topics
Post Quoted Reply
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search