Queries - Adding New Fields in the Result Tab

[Former Member]

Hi,

Can anyone explain me on adding the result columns in the resultField tab while creating a query, I don't understand the actual link between the bundle, resourceid and values that we give as a search criteria while looking up the result columns. I tried to replicate an existing query and it worked fine. But I don understand the actual working. Please help me acquire this understanding.

Also What happens when we say CONTEXTID=CONTEXT(upp.acl). As theory says, it retrives the records relevent to currently logged in user but how.

I am a beginner. Please help me on these.

[Former Member · Accepted solution]

Hi Sharmele,

The concept of bundle name, value etc can be understood better by going through the documentation for Localized Resources. Be sure to go through the Field Help section.

For understanding CONTEXT, search for Attribute Substitution (under Query definition) in the documentation.

I am sure you shall get all your answers.

Thanks

Devesh

[Former Member · Accepted solution]

Hi Devash,

Thanks for the reply. I understood that CONTEXT(upp.acl) is the class name of the object being queried. So in order to find the class ID, should I browse through the Class Names in the class List.

Sharmele.

[Former Member · Accepted solution]

Sharmele,

I would say it is partially correct.

In <%CONTEXT(upp.acl)%>, upp.acl is the class ID for a given class.

But the role of CONTEXT attribute is far more important. In a nutshell, we can say that by using the CONTEXT attribute, you ensure that the data users see in a report/query is only the data that they have access to. Here, by access, just the 'write' access in not implied. It also means 'View' access.

And to answer your question : Yes, in order to find the Class ID of a class, you must browse through the Class Reference. Additionally, in the page that opens up on clicking RG on a business document, the value in the Name section is same as the Class ID of that class.

Thanks

Devesh

[Former Member · Accepted solution]

Hi Devash,

I created a query SELECT <%RESULTS%> FROM <%SCHEMA%>.FCI_UPP_SECURITY_ACL WHERE DISPLAY_NAME = ? AND CONTEXTID=<%CONTEXT(upp.acl)%><%ORDERBY%> adding objectid, classid and displayname in to the result field.

The above query works fine without the filter prompt field. But after adding the display name in both the query and the filter prompt field, I got an Error saying "ACL": invalid identifier. What might be the cause of the error.

Please help. Thanks in Advance.

Sharmele.

[Former Member · Accepted solution]

Hi Sharmele,

I think it's related to what is defined in the Results Field tab. Have you defined a database column name like ACL.name_of_the_colum ? If you do than you should remove that ACL. or add ACL after table name in the query definition.

Regards,

Simion

[Former Member · Accepted solution]

Thanks for the reply. I rectified the error.

Sharmele.