Forums

I do not know if they are stupid, but only lost one day to understand how the where conditions.
If I put
Article.id:100
it works.
but if thou wilt all article.id greater than or equal to 100 as I do?

Article.id:>100
so it does not work.

Hi salvok5,

For any v6 questions, please post here and I will try to answer them ASAP.

You can use this format:

Article.id/>:100

or

Article.id/>:{data:id}

and pass the "id" with the value you want in the url.

Best regards,
Max

Ok, if instead must be less than?

ok, find Article.id/<:100

but if I want to use the where from the links section on the index-> content,
and pass the "id" with the value you want in the url.

instead on event index of content
{fn:read_articles}
what should I use?

??????
{view:table1}
{view:paginator2}
{debug:}

if the value is passed in the url then it should be in the "connection" link, e.g: link&id=100

I'm not sure if this is what you mean, if not then please show me an example or a screenshot.

Best regards,
Max

It 100 must be the link
then I realized that putting on the where conditions
Article.id/>:{data:id}
and on link add &id=100
it works !!!

Best regards,
Salvo

I'm glad you solved it!

Best regards,
Max

I am beginning to understand how it works.
But if I want to personalize the table grid?
as with color or size?
And also how do I make the links on the record to open the information by clicking on that record?
I found this but the example was on the old version, and I did not succeed.

for example, as I do this?
http://www.chronojoomla.com/demos/data-reports

You can change the column width, by using the "columns width" in the table view:

Article.title:ten wide

For the color you may use the "Css" view and reference the table cells.

For the view links, use a "link" view, make the link open the "view" event, and in the "event" call a "read data" function to read one record only and pass the article id in the link like this:

Link parameters:

id={var:table1.row.Article.id}

I think the "view" feature will need to be written in the tutorial, please give me few hours to do that.

Best regards,
Max

After many attempts, I managed to figure out how to make a clickable record.
But when I click on the record as I do now to separate out information on that record?
I attached the backup.

Hi salvok5,

I have updated the tutorial here to explain how to view a record:
http://www.chronoengine.com/faqs/73-chronoconnectivity-v6/5283-build-a-basic-listing.html

The next part is to explain how to open the article for editing, hopefully later today or tomorrow.

Best regards,
Max

I'm sorry MAX, but I give up because I'm not understanding anything.
Mine is a frustration because you can not understand how the library.
Too few examples and no demo backup to understand how all of the library functions.
Too bad because your library seemed interesting.
I would like to achieve a similar job but I have no idea how to do.
http://www.comunesortino.gov.it/index.php/albo/peratti

Hi salvok5,

At which step exactly you have a problem ? please let me know the details and I can post the answers here.

Best regards,
Max

My problem is
1) view records with grouping by category


2) click on a category and view the related records of the category.



3) click on the record and extrapolate the information

Hi salvok5,

The images are not working, but try to get a list of ALL records or all categories working first, this you can do with following the tutorial, then you can start to make changes to pass the category id and create the categories views.

Best regards,
Max

http://www.comunesortino.gov.it/tmp/esempio1.jpg
http://www.comunesortino.gov.it/tmp/esempio2.jpg
http://www.comunesortino.gov.it/tmp/esempio3.jpg

MAX excuse me, but you might have to do it instead a simple project on joomla articles, and make a backup to be attached?

Hi salvok5,

Ok, I will try to have something ready today, I will post here after I finish it.

Best regards,
Max

Hi salvok5,

I added a new wizard mode, the new update is expected to be online soon, but you can also contact me through the "contact us" page to get a backup file.

Best regards,
Max

Thanks Max for backing, have greatly accelerated the understanding of the various functions.
Now I ask you to be able to develop the work I should connect to an external database, and not to the joomla default database.
How should I do since there is no external database function?

Hi, Salvo

Hi Salvo,

The next update has external database support, so you can just get everything working as you expect with a joomla database table then change the tables after the new update.

Best regards,
Max

Hi, Max
I feel there is an error on the function
check_article_exists
because the value of
Values setup
it should be
false: {error: article not found.} {redirect: index}
and not
true: {error: article not found.} {redirect: index}

I am wrong ?

It the problem is that the database is on another host.
However, to implement it can add provvisioramente of joomla.
When you think you do the new update of the component?

Hi salvok5,

You are right, but the data provider has something which may not work before the next update:

{var/empty:read_article}

The "empty" function returns true if the var is empty, and so we check for "true", but this feature has just been added and the online version does not have it yet.

I will try to package the new files and send them to you by email later today.

Best regards,
Max

on READ DATA :
WHERE CONDITIONS
files.ID_REG:docu.ID_REG

me this is wrong.
how do I go to the field to be "docu"?

Array
(
    [richiama_atto] => Array
        (
            [log] => Array
                (
                    [0] => SELECT COUNT(`docu`.`ID`) AS `docu.count` FROM `docs` AS `docu` WHERE `docu`.`ID` = '13494';
                    [1] => SELECT `docu`.`ID` AS `docu.ID`, `docu`.`ID_REG` AS `docu.ID_REG`, `docu`.`INT_NUM` AS `docu.INT_NUM`, `docu`.`SECT_NUM` AS `docu.SECT_NUM`, `docu`.`SECT_NUM_DATA` AS `docu.SECT_NUM_DATA`, `docu`.`PROTO_NUM` AS `docu.PROTO_NUM`, `docu`.`PROTO_DEL` AS `docu.PROTO_DEL`, `docu`.`DECORRENZA` AS `docu.DECORRENZA`, `docu`.`SCADENZA` AS `docu.SCADENZA`, `docu`.`TITOLO` AS `docu.TITOLO`, `docu`.`SOMMARIO` AS `docu.SOMMARIO`, `docu`.`GRUPPO` AS `docu.GRUPPO`, `docu`.`TITOLO_SECT` AS `docu.TITOLO_SECT`, `docu`.`ENTE` AS `docu.ENTE` FROM `docs` AS `docu` WHERE `docu`.`ID` = '13494' LIMIT 30;
                )

        )

    [read_files_id] => Array
        (
            [log] => Array
                (
                    [0] => SELECT COUNT(`files`.`ID`) AS `files.count` FROM `files` AS `files` WHERE `files`.`ID_REG` = '{docu.ID_REG}';
                    [1] => SELECT `files`.`ID` AS `files.ID`, `files`.`ID_REG` AS `files.ID_REG`, `files`.`FILENAME` AS `files.FILENAME` FROM `files` AS `files` WHERE `files`.`ID_REG` = 'docu.ID_REG' LIMIT 30;
                )

        )

)

Hi salvo,

Please try this:

files.ID_REG/=:docu.ID_REG/field

Best regards,
Max

not work :

[read_files_id] => Array
(
[log] => Array
(
[0] => SELECT COUNT(`files`.`ID`) AS `files.count` FROM `files` AS `files` WHERE `files`.`ID_REG` = 'docu.ID_REG';
[1] => SELECT `files`.`ID` AS `files.ID`, `files`.`ID_REG` AS `files.ID_REG`, `files`.`FILENAME` AS `files.FILENAME` FROM `files` AS `files` WHERE `files`.`ID_REG` = 'docu.ID_REG' LIMIT 30;
)

)

Sorry, the code I posted is for a relation condition, but it does not look like you have a relation here.

Are you trying to get files with specific "ID_REG" ? if yes then where do you call this read data function exactly ? if the "ID_REG" is passed in the url then you can try:

files.ID_REG:{data:url_param_name}

The syntax depends on where you call the function, so let me know this if it does not work.

Best regards,
Max

I knew this.
It was just to not pass a parameter the link.

If the read data function is called inside a page AFTER another function then you can get the data from the other function like this:

files.ID_REG:{var:other_function.something}

The syntax depends, so I need to know where do you call the read function to give you the right syntax.

Best regards,
Max

OK it's good