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 7 Months Ago
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
-
7 Months Ago
Hi David, Thanks for bringing this issue to our attention. I have...
LogViewPlus Support
-
7 Months Ago
Thanks for getting back! I tried with all of the custom string fields...
DavidL
-
7 Months Ago
Sorry, I realized that I didn't answer your question directly. No,...
DavidL
-
7 Months Ago
Thanks for the update. LogViewPlus attempts to resolve data types...
LogViewPlus Support
-
7 Months Ago
That's an interesting thought. I do have somewhat of a mix of data...
DavidL
-
7 Months Ago
I rewrote the parser to remove any "optional" fields and ensured that...
DavidL
-
7 Months Ago
Glad to hear the behaviour is looking better. LogViewPlus doesn't...
LogViewPlus Support
-
7 Months Ago
That makes sense. The problem I was trying to solve is that there's a...
DavidL
-
7 Months Ago
No problem David - glad that helped! Please do let me know if you have...
LogViewPlus Support
-
7 Months Ago
Post Reply
Like
3
Similar Topics
Post Quoted Reply
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search