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