kitemp
Forum Replies Created
-
Forum: Plugins
In reply to: [Contact Form DB] Filter submit_time and orderby not workingJust in case it makes a difference I am using this with in html editor (under the text tab) on a public page and not in the admin area so you don’t have to log in?
Forum: Plugins
In reply to: [Contact Form DB] Filter submit_time and orderby not workingHi
I have tried setting them both to “Anyone” and it is still the same. I don’t understand how the same shortcode can work on the filter = but then not when the filter is >?
Works
[cfdb-table form=”Brochure Request” role=”Anyone” permissionmsg=”true”]Works
[cfdb-table form=”Brochure Request” show=”Submitted,your-name,tel-113″ role=”Anyone” permissionmsg=”true” filter=”submit_time=1432906131.1997″]Doesn’t Work
[cfdb-table form=”Brochure Request” show=”Submitted,your-name,tel-113″ role=”Anyone” permissionmsg=”true” filter=”submit_time>last week”]I even tried this shortcode with;
filter=”submit_time>-3000 days”
filter=”submit_time>-14 days”
filter=”submit_time>strtotime(‘last week’)”
filter=”submit_time>strtotime(‘-14 days’)”Like I said I have read everything I can find on the web and for the life of me I can not get the submit_time filter to work unless I put an exact figure in like the one above, I have even tried to see if I need any other plugins etc which I have missed, its driving me loopy!
Forum: Plugins
In reply to: [Contact Form DB] Filter submit_time and orderby not workingI have just discovered something that you maybe able to resolve.
When I use this code, [cfdb-table form=”Brochure Request” show=”Submitted,your-name,tel-113″ role=”Anyone” permissionmsg=”true” filter=”submit_time=1432906131.1997″]
It will display 1 result.
When I display this code, [cfdb-table form=”Brochure Request” show=”Submitted,your-name,tel-113″ role=”Anyone” permissionmsg=”true” filter=”submit_time>last week”]
I get a message saying “You do not have sufficient permissions to access this data.”
Do you think it could be something in the settings?
Forum: Plugins
In reply to: [Contact Form DB] Filter submit_time and orderby not workingCan you please tell me how to fix this?
Forum: Plugins
In reply to: [Contact Form DB] Filter submit_time and orderby not workingHello,
So I tested the filter matching an exact result from displaying the submit_time and the filter worked! Here is the one that worked
[cfdb-table form=”Brochure Request” show=”Submitted,your-name,tel-113″ role=”Anyone” filter=”submit_time=1432906131.1997″]
So it must be the 4 decimal places stored in the database that the submit_time can not match because it is only a 10 digit?