Categories
View Replies (3)

Resolved How can I export entries that have a specific value - or no value in a specific column?

  1. elisa
    elisa
  2. RO CSVI
  3. Wednesday, 26 January 2022
  4.  Subscribe via email
Dear RO CSVI Team,
I need to export a table with all entries that have a specific value in one cell and not any value in another cell.
Is there any way to perform "WHERE" and "LIKE" SQL queries on the exports?
thank you!
Elisa
0
Responses (3)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Elisa,
Custom SQL queries for exports is not supported yet but you can write a custom rule plugin to add the needed query for specific fields and run the export. Let me know if that helps.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
elisa
elisa
Accepted Answer Pending Moderation
Hi Tharuna,
I tried to copy the skip Plugin and adjust it but its over my knowledge, can you send me a custom offer to create such a plugin for me.
I have a custom table export and want to include only records that have the value "Error" in a specific field.
thanks
Elisa
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Elisa,
I have a custom table export and want to include only records that have the value "Error" in a specific field.

In that case you don't need a custom plugin. You can use RO CSVI Skip rule plugin with regular expression to skip records which do not have "Error" text in its value and export the rest. See attached screenshot. Try the regex in skip rule and let me know if that helps.



/^(?!Error$)/
Attachments (1)
Screenshot 2022-01-27 at 2.37.20 PM.png Screenshot 2022-01-27 at 2.37.20 PM.png
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!