+1 vote

Hello,

Does anyone knows how parameter isactiveparam is translated in sysqueries inside tag "<#USERLINK>"? is it indicating the possibility to pass an argument (param1 maybe) to set "ISACTIVE" to 0 or 1 on calling the defined sysquery?

<#USERLINK table="DOCUMENTS" usertable="DOCU_USER" key="K_DOCUMENT" isactiveparam="true">

And is there a documentation somewhere about these special tags in queris and their parameters?
Thank you in advance for your help.
Best Regards.

asked in Database by (559 points)

1 Answer

+2 votes
Best answer

Hello,

<#userlink> inserts a qualified relation to a user relation table.
The generated SQL will usually be similar to the following:

EXISTS(SELECT Q1.K_USER FROM ACC_GROUPS Q1, COMP_USER Q2
    WHERE Q1.K_USER = Q2.K_USER AND Q1.K_USER2 IN (:param1) AND Q2.K_COMPANY = COMPANIES.K_COMPANY AND Q2.ISACTIVE = :param2)

"isactiveparam" argument is a boolean argument of userlink which will be replaced by the corresponding runquery param in the WHERE clause (ISACTIVE =).

<#USERLINK table="PROJECTS" usertable="PROJ_USER" key="K_PROJECT" isactiveparam="true">

"isactive" argument allows you to provide the isactive value directly into the userlink tag.

<#USERLINK table="CASES" usertable="CASE_USER" key="K_CASE" isactive="1">

Good news, a new updated documentation will be available once Efficy 11.1 is released!

answered by (968 points)
selected by
Thank you Anthony, it's clear no :)
Does this also mean that sys_queries like 'Missed deadlines' will change?

[Where]
ACTI_USER.K_USER = userkey
ACTI_USER.ISACTIVE = 1[fixed]
ACTIONS.PLANNED <> 2 [fixed]
ACTIONS.DONE = 0 [fixed]
ACTIONS.D_DUE < today
ACTIONS.D_BEGIN <= today
ACTI_CONT.MAIN = 1 [fixed]
ACTI_PROJ.MAIN = 1 [fixed]
ACTI_COMP.MAIN = 1 [fixed]
1,249 questions
1,519 answers
1,859 comments
328 users