4 weeks ago
Hi Everyone,
I am trying pass arguments to my MDO throught illuminator. I create link like this:
http://<server>:<port>/XMII/Illuminator?server=MDOConnector&Mode=Insert&MDO=Project%2FMIIOBJ%2FMDOTest&Col1=Value1&Col2=Value2.
When I execute this link I recieve message in my browser that "Command Query Successful". After this when I check MDO in workbench I can see that It looks like this:
Why I can't see my values? Do I need to change anything in permissions?
Is there any different option to dynamically push data to MDO?
Ok, I got it, but what if I have table like this:
Col 1 Col2
Value1 Value5
Value2 Value6
Value3 Value7
Value4 Value8
And I would like to update value3 in Col1 to different value. Is it even possible throught illuminator service?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
yes,
That is possible, all you have to do is add only the attributes you want to update and the update condition in the query as below
for e.g., here i have only add 3 columns to get updated and the value will be updated based on the condition provided such as empid= param.1. and the update column values as param.2/3/4.
once your query is working fine here(from the workbench. test providing values in parameters tab, execute and see if the values are getting updated as expected or not.). then using the illuminator services, create a url and execute the url as below:
http://<server>:<port>/XMII/Illuminator?QueryTemplate=<your query path>&Param.1=<empid>&Param.2=<salary>&Param.3=<Designation>&Param.4=<Location>
User | Count |
---|---|
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.