JQUERY TABLE SEARCH

  • Resolved rherson1

    (@rherson1)


    5 years, 11 months ago

    Hi Peter,

    I’ve created a MYSQL view using your Data Explorer GUI which worked successfully. However, the SEARCH option does not appear to work. I then tried a search directly against a table and that worked. Is there a issue using views? If there is what’s the recommended workaround?

    The above also applies when I use a view using is a Data Publisher component.

    Thanks.

    Richard.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    5 years, 11 months ago

    Hi Richard,

    I’m not aware of search problems with views. It should work just like searching tables.

    If you open the Data Explorer, search for your view, click the manage link and navigate to tab Columns, what do you see? Can you add a screenshot?

    Thanks,
    Peter

    Thread Starter rherson1

    (@rherson1)

    5 years, 11 months ago

    Hi Peter, I have now identified the problem. I had to cast the offending column’s content to CHAR within the view i.e.

    cast(‘Time since last flight in hours:minutes:seconds’ as CHAR) as vAnalysisPeriod # mysql

    It now works so the topic is resolved.

    Thanks and regards.

    Richard.

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    5 years, 11 months ago

    Thank you for your update Richard! 🙂

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘JQUERY TABLE SEARCH’ is closed to new replies.