charlesgodwin

I notice it only searches VARCHAR and ENUM fields, ignoring CHAR, TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT or is there some internal magic in WordPress.

How would you suggest I go about enhancing the method? I know I can replace the source code but that would last until your next update. Any other suggestions? I don’t see action or filter hooks.

I don’t know if this is a 4 or a variation on 1 and 2.

It would really be nice to open a page with a dynamic search value preloaded. The value I have in mind is dynamic. It could be implemented as either a query string or a value in session data. For example if a user filled in a form with a name of “jones” and pressed Submit and the data table page would open with a search of Jones.

Another application is the front end table maintenance in Data Project. Currently, if a user uses search to find some records, selects one to edit, completes the update and then presses Back to List the search is gone and must be repeated. The Back button works but gets a refresh message, at least in chrome. Dynamically loading or retaining the search value in this case would be very user friendly.

Thaks, keep up the good work.

I had it set for administrator and contributor before I opened this topic.

I also have access to page with the same access restraints and I get to the page.

How can I send an export of the project? It’s not very big I could put it in a message.

Her’s the short code. [wpdadiehard project_id=”1″ page_id=”1″]

Thanks I’ll experiment Saturday

Works like a charm. I used {"dom":"flirptip"}

Thanks again.

Thanks. The CSS help worked.

I still need a bit of guidance on getting the DOM model to work. I can’t seem to get it to work. Once it works I can experiment with different setup ups.

I have an embedded script in this page but it’s not working.
https://ottawa.ogs.on.ca/researching/indexes/library-catalog/

Search for “// inserted by Charles Godwin 2020-01-03” in the html

All help will be appreciated. Thanks

This is NOT urgent

I’ve done some reading and dataTables supports this.

click here

This explains the “what to do” but I need some help with the “How”. I understand the concepts of DOM model but the specifics of doing this inside a WordPress page or block or as pub options is a skill I want learn.

Can anyone help? Thanks.

No offence intended, it is a question I ask users. “Do you want it right, or do you want it right now?”

I agree that it should accept donations, it is a good product. I don’t see any way to donate at https://wpdataaccess.com/

Agreed. I was answering the “I want it right now” vs “I want it right”.

A duplicate function would be handy.

I agree about the typo in item 1 I noticed it too.
Item 2
I haven’t tested it but I presume this will work.You could put your where clause in the shortcode and then only have have one pub. Refer to https://wpdataaccess.com/docs/documentation/shortcodes/shortcode-wpdataaccess/ and the sql_where parameter.

Item 3 no comment.

• This reply was modified 5 years, 2 months ago by charlesgodwin.

I had “Allow Delete” disabled in Back-end settings. That influences the choices available in Data Publisher.

Thanks for your help

I think I tried SQL SECURITY INVOKER both ways for yesterday but i’ll revisit it.

I hadn’t looked at performance. ??

Thanks for the update.

I have succeeded in using a view. I changed the ON syntax in the JOIN to simple WHERE syntax.

before
FROM (nameindex JOIN library ON ((nameindex.LIBREF = library.Classification)))

after
FROM (nameindex JOIN library) WHERE (nameindex.LIBREF = library.Classification)

Try connecting now. sorry for the delay, I was away from my keyboard. I also emailed you the tables involved.

@peterschulznl What is your external IP address or country. We may have too tight blacklisting. We’ve been getting hit lately.