It's ok now! thanks!

And other guestions are:

1. In the SQL querry the first column is "DateSubitted" but it doesn't show in the table. How to make it visible?
2. In the SQL querry I specified the order of column:

'DateSubitted','surname','Name','birth','place_of_birth' but in the table is different ( the surname is the last...)

3. How to hide in table the first column, "id"?

1. The table doesn't contain column "DateSubited" or form field with this name. You can see table columns using PHPMyAdmin or other DB manager which is usually provided by hosting provider. List of available form fields you can see if execute the following SQL query:


SELECT
DISTINCT FieldName
FROM
`meox_rsform_submission_values`
WHERE
FormId = 5


2. It is not columns order, it just name of form fields which you want to show. The table doesn't contain any column which can help to change order of fields. It is not possible to order fields by name in ascending or descending order using MySQL functionality.

3. Set "Columns settings -> ID" parameter to 0 value and "Columns settings -> Hidden" parameter to "Yes":



Regards,
ARI Soft

Thanks for your help!

1. Strange, in admin panel of Joomla I have this column as first and would be very useful to have it in ARI table. It makes possible to filter by submission date.

2. If this is just an order of fields, then the fields in the form and database are ordered as I need, see the screenshot I send the first.
Why then they should be in ARI table in different order?
Thinking a little, I found the solution somehow spontaneously, and this makes me happy now
I just changed in Querry the:

ORDER BY SubmissionId DESC, FieldName ASC
to
ORDER BY SubmissionId DESC
Now the order of columns in the ARI table is the same as in my table in backend.

3. I did, it is OK now!

Thanks a lot again!

1. Send a screenshot where we can see the column.

Regards,
ARI Soft

I've sent you again the first email with the this screenshot.