I am giving full access rights to one form for the user “XXXX”. That form having only one datasource
Form is opened for that user , but No data is Showed for that user. its empty form.
I am tried lot of way. but only that table having the problem. That table having lot of records.
For Admin user it will works.
Please help me , its very urgent
Thanks and Regards,
Muthusamy.V
There may be record-level security or extensible data security in place.
Hi martin,
Thanks for the reply
No Record level security applied
No XDS applied
Applying the Normal Security .
That table and menuitem having full access rights.
Hi martin,
No Record level security applied
No XDS applied
Applying the Normal Security .
That table and menuitem having full access rights.
I am waiting for your comments.
Can you review the query? Maybe there is a filter preventing data to be shown to that user.
If the problem is just with a single user, try to delete personalization data for that user and form.
Hi Martin,
I didn’t use query in the form datasource. This problem occurring for all users those who are all not having the System Admin Role
I use directly table as a datasource.
its allowing to add data in the form. It does not show the data after record saving.
it does not fetch any data from that table.
I am writing one query in the Form-> Datasource ->Active method to show the first and last record of that table to display as info message. it didn’t fetch any records. it shows empty log.
Regards,
Muthusamy.V
I meant “database query” in general, regardless whether you’ve designed it as an AOT query or in any other way.
Hi martin,
I am checking in all the way. Now I am checked with another way.
No query in the form. Just the add the table in the form datasource and Add some fields in the design grid .
Create one Role and Assigning that Role to the user with full Access rights to access the menuitem and the table .
That user try to open the form. Form is opened with empty Grid. Try to add the New record , record also added , but after Saving the record , again the form shown as empty grid.
When I open the table using System admin role , the table having the same record.
Thanks and Regards,
Muthusamy.V
If there was no query to database, the form would never get any data. If you add a data source, AX will run a query to get such data from database.
If you have a problem with getting data, the query is exactly what you should analyze first.
If all records are filtered out, you’ll experience the same behavior you’re describing.
Hi martin ,
thanks for the support
Problem: Someone use that table in XDS for testing other issue.
Now its working fine.
Sorry for the improper checking.
Thanks and Regards,
Muthusamy